Обсуждение: Does PostgreSQL support to write glusterfs by Libgfapi
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.
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.comScott Mead
Sr. Architect
OpenSCG
PostgreSQL, Java & Linux Experts
--
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
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.
Вложения
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.
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.