adey wrote:
If you turn WAL logging off (via fsynch parameter in .conf), it is my
understanding that you will no longer log database updates, and will
therefore not be able to recover any uncommitted transactions in the
event of failure, (which seems contradictory to database practice).
You
If you turn WAL logging off (via fsynch parameter in .conf), it is my understanding that you will no longer log database updates, and will therefore not be able to recover any uncommitted transactions in the event of failure, (which seems contradictory to database practice).
Gut feel to me says
Hello,
My hardware
CPU: Intel 3 GHZ X 4
Memory: 9 GB
LINUX
My conf file are as follows:
shared_buffers=1
wal_buffers=128
vacuum_mem = 256000
sort_mem=32768
max_fsm_pages = 300
max_fsm_relations = 32768
checkpoint_segments = 2048
checkpoint_timeout = 1800
checkpoint_warning = 300
effect
