From: Scott Marlowe <scott.marlowe@gmail.com>
To: Bob Dusek <redusek@gmail.com>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: pgsql-performance@postgresql.org
Subject: Re: performance config help
Date: Mon, 11 Jan 2010 12:45:44 -0700
Message-ID: <dcc563d11001111145t63023051i6f72f495719c0f53@mail.gmail.com> (raw)
In-Reply-To: <61039b861001111134ja2ab11cr1c83e34b24377f4d@mail.gmail.com>
References: <4B4B177B020000250002E194@gw.wicourts.gov>
<61039b861001111134ja2ab11cr1c83e34b24377f4d@mail.gmail.com>
On Mon, Jan 11, 2010 at 12:34 PM, Bob Dusek <redusek@gmail.com> wrote:
> Yeah :) We haven't run into much trouble. But, we cut our teeth doing
> performance analysis of our app using PG 7.4. And, people on this list seem
> to be adamantly against this config these days. Is this safer in older
> versions of PG? Or, are the risks the same?
It's always been unsafe. Just that 7.4 was so slow that sometimes you
didn't really get to choose.
> We have some asynchronous communications processes that communicate
> permanent db changes to an enterprise-level data warehouse. And, we can
> recover that data back down to the server if the server goes belly-up. If
> something does go belly up, we really only lose the bit of data that hasn't
> been communicated yet. It's true, that this data is important. However,
> it's also true that it's very costly to guarantee this that very small
> amount of data isn't lost. And, practically speaking (for our purposes) it
> seems that the data's not worth the cost.
I have slave dbs running on four 7200RPM SATA drives with fsync off.
They only get updated from the master db so if they go boom, I just
recreate their node. There's times fsync off is ok, you just have to
know that that db is now considered "disposable".
However, I'd suggest doing some benchmarking to PROVE that you're
seeing an improvement from fsync being off. If there's no
improvement, then you might as well leave it on and save yourself some
headache later on when the machine gets powered off suddenly etc.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: scott.marlowe@gmail.com, redusek@gmail.com, Kevin.Grittner@wicourts.gov
Subject: Re: performance config help
In-Reply-To: <dcc563d11001111145t63023051i6f72f495719c0f53@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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