> I suggest you check this first. Check the performance tuning guide..
> That is a starters. As Josh suggested, increase checkpoint segments if you
> disk space. Correspondingly WAL disk space requirements go up as well.
Well, not if he has fsync=off. But having fsync off is a very bad idea. You
do realize, Herve', that if you lose power on that machine you'll most likely
have to restore from backup?
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Josh Berkus||Date: 2004-07-15 18:11:33|
|Subject: Re: Odd sorting behaviour|
|Previous:||From: Brian Hirt||Date: 2004-07-15 18:07:12|
|Subject: hardware raid suggestions|