Re: Disable WAL completely

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Disable WAL completely
Date: 2008-02-19 15:48:01
Message-ID: 20080219154801.GB6148@crankycanuck.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Douglas J Hunley 2008-02-19 18:03:58 7 hrs for a pg_restore?
Previous Message Cousin Marc 2008-02-19 15:27:58 strange plan choice