Josh, 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 > > have > > > 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 v7.4.3 ?? Tell me ... -- Hervé Piedvache Elma Ingénierie Informatique 6 rue du Faubourg Saint-Honoré F-75008 - Paris - France Pho. 33-144949901 Fax. 33-144949902 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html