Le jeudi 15 Juillet 2004 20:09, Josh Berkus a écrit :
> > I suggest you check this first. Check the performance tuning guide..
> > http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php
> > 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?
Hum ... it's only for speed aspect ... I was using postgresql with this option
since 7.01 ... and for me fsync=on was so slow ...
Is it really no time consuming for the system to bring it ON now with
Tell me ...
Elma Ingénierie Informatique
6 rue du Faubourg Saint-Honoré
F-75008 - Paris - France
In response to
pgsql-performance by date
|Next:||From: Litao Wu||Date: 2004-07-16 21:36:30|
|Subject: same plan, different time|
|Previous:||From: Matt Clark||Date: 2004-07-16 07:35:32|
|Subject: Re: Swapping in 7.4.3|