From: Jeff Davis <pgsql@j-davis.com>
To: Carlos Moreno <moreno_pg@mochima.com>
Cc: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: Please humor me ...
Date: Mon, 09 Apr 2007 14:05:44 -0700
Message-ID: <1176152744.4152.75.camel@dogma.v10.wvs> (raw)
In-Reply-To: <461A9C86.4000008@mochima.com>
References: <461A9C86.4000008@mochima.com>
On Mon, 2007-04-09 at 16:05 -0400, Carlos Moreno wrote:
> And by the subject, I mean: please provide a "factual" answer, as opposed
> to the more or less obvious answer which would be "no one in their sane
> mind would even consider doing such thing" :-)
>
> 1) Would it be possible to entirely disable WAL? (something like setting a
> symlink so that pg_xlog points to /dev/null, perhaps?)
You can't disable WAL, but you can disable fsync.
> 2) What would be the real implications of doing that?
>
A good chance that you lose your entire database cluster if the power
fails.
It's not just your tables that require WAL, it's also the system
catalogs. If you were to disable it, and a system catalog became
corrupt, the database would not know what to do.
There's always a chance you could recover some of that data by a manual
process (i.e. open up the database files in a hex editor and look for
your data), but there would be no guarantee.
Regards,
Jeff Davis
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pgsql@j-davis.com, moreno_pg@mochima.com
Subject: Re: Please humor me ...
In-Reply-To: <1176152744.4152.75.camel@dogma.v10.wvs>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox