Does PostgreSQL support to write glusterfs by Libgfapi

Started by zh1029over 10 years ago5 messagesgeneral
Jump to latest
#1zh1029
zh1029@sina.com

Hi,
It seems low performance PostgreSQL(9.3.6) while writing data to glusterFS
distributed file system. libgfapi is provide since GlusterFS version 3.4 to
avoid kernel visits/data copy which can improve its performance. But I
didn't find out any instruction from the PostgreSQL web page. Do you know if
PostgreSQL later release supports using libgfapi to optimized write data to
ClusterFS file system.

--
View this message in context: http://postgresql.nabble.com/Does-PostgreSQL-support-to-write-glusterfs-by-Libgfapi-tp5877793.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#2Scott Mead
scottm@openscg.com
In reply to: zh1029 (#1)
Re: Does PostgreSQL support to write glusterfs by Libgfapi

On Wed, Dec 16, 2015 at 1:26 AM, zh1029 <zh1029@sina.com> wrote:

Hi,
It seems low performance PostgreSQL(9.3.6) while writing data to
glusterFS
distributed file system. libgfapi is provide since GlusterFS version 3.4 to
avoid kernel visits/data copy which can improve its performance. But I
didn't find out any instruction from the PostgreSQL web page. Do you know
if
PostgreSQL later release supports using libgfapi to optimized write data to
ClusterFS file system.

The real question is, why are you using GLusterFS? It's important to be

careful since PostgreSQL provides no mechanism to allow for shared-disk
clustering (active/active). If you are planning on using active/passive,
you must plan carefully so as not to create a split-brain scenario.

--
Scott Mead
Sr. Architect
*OpenSCG*
PostgreSQL, Java & Linux Experts
http://openscg.com <http://openscg.com&gt;

Show quoted text

--
View this message in context:
http://postgresql.nabble.com/Does-PostgreSQL-support-to-write-glusterfs-by-Libgfapi-tp5877793.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#3Alan Hodgson
ahodgson@simkin.ca
In reply to: zh1029 (#1)
Re: Does PostgreSQL support to write glusterfs by Libgfapi

On Tuesday, December 15, 2015 11:26:40 PM zh1029 wrote:

Hi,
It seems low performance PostgreSQL(9.3.6) while writing data to glusterFS
distributed file system. libgfapi is provide since GlusterFS version 3.4 to
avoid kernel visits/data copy which can improve its performance. But I
didn't find out any instruction from the PostgreSQL web page. Do you know
if PostgreSQL later release supports using libgfapi to optimized write data
to ClusterFS file system.

Putting a database on Gluster is a horrible idea in any case. But no,
PostgreSQL does not have Gluster-specific support.

I'm actually trying to think of a use case where it would make sense; I
suppose a large data warehouse could theoretically see some sequential read
improvements from a scale-out cluster file system. But you could only have one
client node accessing it.

#4zh1029
zh1029@sina.com
In reply to: Scott Mead (#2)
Re: Does PostgreSQL support to write glusterfs by Libgfapi

Hi,
Thank you for the advice.This was designed storage solution deployed in
cloud among with other storage usage. We will remove glusterfs solution to
DB usage.

--
View this message in context: http://postgresql.nabble.com/Does-PostgreSQL-support-to-write-glusterfs-by-Libgfapi-tp5877793p5878428.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#5zh1029
zh1029@sina.com
In reply to: Alan Hodgson (#3)
Re: Does PostgreSQL support to write glusterfs by Libgfapi

Hi,
Thank you. This was designed storage solution deployed in cloud among with
other storage usage. We will remove glusterfs solution to DB usage. We don't
intend to use glusterfs to do data replication. But PostgreSQL may think
about variable storage solutions.

--
View this message in context: http://postgresql.nabble.com/Does-PostgreSQL-support-to-write-glusterfs-by-Libgfapi-tp5877793p5878429.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general