pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
PostgreSQL and ZFS 3+ messages / 2 participants [nested] [flat]
* PostgreSQL and ZFS @ 2008-09-03 13:00 Thomas Bräutigam <thomas.braeutigam@nexustelecom.com> 0 siblings, 0 replies; 3+ messages in thread From: Thomas Bräutigam @ 2008-09-03 13:00 UTC (permalink / raw) To: pgsql-admin Hello, I am working with a PostgreSQL Database and I want to change the Filesystem to ZFS. Does someone have experience with PostgreSQL and its Performance with ZFS? Are the current write options for PostgreSQL suitable for ZFS? Do I need to finetune Postgres with the settings for ZFS? Like finetuning of... - fsync - wal_sync_method Thanks if someone can help me on this. Cheers Thomas ^ permalink raw reply [nested|flat] 3+ messages in thread
* PostgreSQL and ZFS @ 2008-09-03 15:21 Thomas Bräutigam <thomas.braeutigam@nexustelecom.com> 0 siblings, 1 reply; 3+ messages in thread From: Thomas Bräutigam @ 2008-09-03 15:21 UTC (permalink / raw) To: pgsql-admin Hello all, I am working with a PostgreSQL Database and I want to change the Filesystem to ZFS. Does someone have experience with PostgreSQL and its Performance with ZFS? Are the current write options for PostgreSQL suitable for ZFS? Do I need to finetune Postgres with the settings for ZFS? Like finetuning of... - fsync - wal_sync_method Thanks if someone can help me on this. Cheers Thomas ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PostgreSQL and ZFS @ 2008-09-03 20:17 Larry Rosenman <ler@lerctr.org> parent: Thomas Bräutigam <thomas.braeutigam@nexustelecom.com> 0 siblings, 0 replies; 3+ messages in thread From: Larry Rosenman @ 2008-09-03 20:17 UTC (permalink / raw) To: 'Thomas Bräutigam' <thomas.braeutigam@nexustelecom.com>; pgsql-admin I'm running on ZFS on a lightly loaded FreeBSD 7 box, and it's fine. I did give ZFS the hint with recordsize=8K on the data directory/fs, but nothing else. (other than the usual caveats with ZFS on FreeBSD (I'm on amd64)). LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Thomas Bräutigam Sent: Wednesday, September 03, 2008 10:22 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] PostgreSQL and ZFS Hello all, I am working with a PostgreSQL Database and I want to change the Filesystem to ZFS. Does someone have experience with PostgreSQL and its Performance with ZFS? Are the current write options for PostgreSQL suitable for ZFS? Do I need to finetune Postgres with the settings for ZFS? Like finetuning of... - fsync - wal_sync_method Thanks if someone can help me on this. Cheers Thomas ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-09-03 20:17 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2008-09-03 13:00 PostgreSQL and ZFS Thomas Bräutigam <thomas.braeutigam@nexustelecom.com> 2008-09-03 15:21 PostgreSQL and ZFS Thomas Bräutigam <thomas.braeutigam@nexustelecom.com> 2008-09-03 20:17 ` Larry Rosenman <ler@lerctr.org>
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