OK, it'll be better to avoid a such improvement :-) Performance - yes, but not for any price :-)
Thank you! Rgds, -Dimitri On 5/11/09, Kevin Grittner <kevin.gritt...@wicourts.gov> wrote: > Dimitri <dimitrik...@gmail.com> wrote: > >> What about "full_page_writes" ? seems it's "on" by default. Does it >> makes sense to put if off?.. > > It would probably help with performance, but the description is a > little disconcerting in terms of crash recovery. We tried running > with it off for a while (a year or so back), but had problems with > corruption. I think the specific cause of that has since been fixed, > it's left us a bit leery of the option. > > Maybe someone else can speak to how safe (or not) the current > implementation of that option is. > > -Kevin > -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
