From: | Anuradha Ratnaweera <anuradha(at)gnu(dot)org> |
---|---|
To: | Oliver Vecernik <vecernik(at)aon(dot)at> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: disable wal |
Date: | 2001-04-30 07:13:45 |
Message-ID: | Pine.LNX.4.21.0104301303570.5831-100000@presario |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Mon, 30 Apr 2001, Oliver Vecernik wrote:
> Anuradha Ratnaweera wrote:
> >
> > Is there a way to disable write ahead logging (WAL) in 7.1?
>
> Why do you want to do this?
>
Because I have a copy of my real server on a laptop and I do all the
development on it. I use pg_dumpall, diff and shell scripts to synchronize
the two databases, source code and mails.
Obviously, I don't want the data on the laptop to be reliable because even
if everything corrupts there, a fresh installation and a single run of the
sync scripts will take things back to normal. These scripts will _not_
corrupt the real server even if the data on the laptop is corrupt because
data is taken only _from_ the server and not the other way round.
WAL files seem to be a bottleneck for the laptop performance (not on the
real server). So I want to disable it on the laptop.
Regards,
Anuradha
From | Date | Subject | |
---|---|---|---|
Next Message | Blake, Stephen | 2001-04-30 12:59:58 | RE: Re: 7.1 performance |
Previous Message | Reiner Dassing | 2001-04-30 06:48:35 | Re: Restoring a pg_dump fails with |