On Thu, 2008-11-06 at 13:02 -0600, Kevin Grittner wrote: > >>> "Kevin Grittner" <Kevin.Grittner@xxxxxxxxxxxx> wrote: > > If I find a particular tweak to the background writer or some such > is > > particularly beneficial, I'll post again. > > It turns out that it was not the PostgreSQL version which was > primarily responsible for the performance difference. We updated the > kernel at the same time we rolled out 8.3.4, and the new kernel > defaulted to using write barriers, while the old kernel didn't. Since > we have a BBU RAID controller, we will add nobarrier to the fstab > entries. This makes file creation and unlink each about 20 times > faster. Woah... which version of the kernel was old and new? > > -Kevin > -- -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
