Tomasz Ostrowski escribió:
On Sat, 01 Dec 2007, rihad wrote:
fsync = on;
synchronous_commit = off;
full_page_writes = off;
Thanks for any insights or clarifying missed points.
Also check whether a disks have write-caching turned off - it should.
On Linux the command is:
# hdparm -W /dev/sda
/dev/sda:
write-caching = 0 (off)
Uh? That command as was written lacks an argument for -W (0/1). From the
hdparm --help:
-W set drive write-caching flag (0/1) (DANGEROUS)
# hdparm -V
hdparm v6.9
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
