| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Munteanu Gabriel <gmunteanu(at)rdslink(dot)ro> |
| Cc: | postgres-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: wal-debug |
| Date: | 2003-03-03 22:28:39 |
| Message-ID: | 20030303222839.GB31057@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Mar 03, 2003 at 03:11:37AM -0800, Munteanu Gabriel wrote:
> I am asking to improve performace.
> Can you explain me how WAL improves performance.
> ex:
> a query lasts 1 second when WAL would be disabled
> if it is enabled how WAL improves performance?
> What does it do?
Please read this:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=wal.html
The upshot that it doesn't need to write as much to disk to commit a
transaction and those write are sequential instead of scattered across the
disk.
What are you doing that makes you think WAL is bad?
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Support bacteria! They're the only culture some people have.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Munteanu Gabriel | 2003-03-03 22:36:21 | Re: wal-debug |
| Previous Message | Patrick Bye (WFF) | 2003-03-03 22:20:06 | Help with functions |