On 06 Nov 2003 15:21:03 +0100
Marek Florianczyk <franki@tpi.pl> wrote:
> fsync = false
HOLD THE BOAT THERE BATMAN!
I would *STRONGLY* advise not running with fsync=false in production as
PG _CANNOT_ guaruntee data consistancy in the event of a hardware
failure. It would sure suck to have a power failure screw up your nice
db for the users!
> wal_buffers = 1024
This also seems high. come to think about it- shared_buffers is also
high.
> commit_delay = 10000
I could also read to data loss, but you'll get a speed increase on
inserts.
One of the best things you can do to increase insert speed is a nice,
battery backed raid card with a pile of disks hanging off of it.
--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/