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 can not turn of WAL logging. You can only delay how the data is
written to disk.
Sincerely,
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
