Re: Disable WAL completely - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: Disable WAL completely
Date
Msg-id 20080219154801.GB6148@crankycanuck.ca
Whole thread Raw
In response to Re: Disable WAL completely  (Matthew <matthew@flymine.org>)
List pgsql-performance
On Tue, Feb 19, 2008 at 02:48:55PM +0000, Matthew wrote:
> If there's not much write traffic, the WAL won't be used much anyway.

You still have checkpoints.

> If you really don't care much about the integrity, then the best option is
> probably to put the WAL on ramfs.

Um, that will cause the WAL to go away in the event of device crash.  Surely
that's a bad thing?

A


pgsql-performance by date:

Previous
From: Cousin Marc
Date:
Subject: strange plan choice
Next
From: Douglas J Hunley
Date:
Subject: 7 hrs for a pg_restore?