Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: PG slowdown
- From: "Joshua D. Drake" <jd(at)commandprompt(dot)com>
- To: adey <adey11(at)gmail(dot)com>
- Cc: Abu Mushayeed <amushayeed(at)hotmail(dot)com>, pgsql-admin(at)postgresql(dot)org
- Subject: Re: PG slowdown
- Date: Wed, 12 Jul 2006 20:50:38 -0700
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/
- References:
- PG slowdown
- From: Abu Mushayeed
- Re: PG slowdown
- From: adey
- PG slowdown
- Prev by Date: Re: PG slowdown
- Next by Date: Where are the temporary work / sort files please
- Previous by thread: Re: PG slowdown
- Next by thread: Restore Database
- Indexes: