pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Isolation of tx logs on VMware 2+ messages / 2 participants [nested] [flat]
* Isolation of tx logs on VMware @ 2016-12-13 20:16 ProPAAS DBA <dba@propaas.com> 2016-12-13 20:22 ` Re: Isolation of tx logs on VMware Joshua D. Drake <jd@commandprompt.com> 0 siblings, 1 reply; 2+ messages in thread From: ProPAAS DBA @ 2016-12-13 20:16 UTC (permalink / raw) To: pgsql-performance Hi All; We have a client running on VMware, they have heavy write traffic and we want to isolate the IO for the tx logs (pg_xlog). However it seems the best plan based on feedback from the client is either (a) simply leave the pg_xlog dir in the VMDK or (b) relocate pg_xlog to NAS/NFS I'm not a VMware expert, however I thought VMware would allow the creation of multiple disk volumes and attach them via separate mount points. Is this not true? If it is an option can someone point me to a how to... Also, if we cannot do multiple VMDK volumes then what is everyone's thoughts about relocating pg_xlog to an NFS mount? Thanks in advance -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Isolation of tx logs on VMware 2016-12-13 20:16 Isolation of tx logs on VMware ProPAAS DBA <dba@propaas.com> @ 2016-12-13 20:22 ` Joshua D. Drake <jd@commandprompt.com> 0 siblings, 0 replies; 2+ messages in thread From: Joshua D. Drake @ 2016-12-13 20:22 UTC (permalink / raw) To: ProPAAS DBA <dba@propaas.com>; pgsql-performance On 12/13/2016 12:16 PM, ProPAAS DBA wrote: > Hi All; > > I'm not a VMware expert, however I thought VMware would allow the > creation of multiple disk volumes and attach them via separate mount > points. Is this not true? If it is an option can someone point me to a > how to... Yes it is possible to do this and then you will be able to use standard OS tools to determine the IO utilization. > > > Also, if we cannot do multiple VMDK volumes then what is everyone's > thoughts about relocating pg_xlog to an NFS mount? > I personally wouldn't do it but it would depend on the implementation. JD > > Thanks in advance > > > > > -- Command Prompt, Inc. http://the.postgres.company/ +1-503-667-4564 PostgreSQL Centered full stack support, consulting and development. Everyone appreciates your honesty, until you are honest with them. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2016-12-13 20:22 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2016-12-13 20:16 Isolation of tx logs on VMware ProPAAS DBA <dba@propaas.com> 2016-12-13 20:22 ` Joshua D. Drake <jd@commandprompt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox