Re: avoiding WAL logging in 8.3 - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: avoiding WAL logging in 8.3
Date
Msg-id 1185258650.4263.32.camel@ebony.site
Whole thread Raw
In response to avoiding WAL logging in 8.3  (Tatsuo Ishii <ishii@postgresql.org>)
Responses Re: avoiding WAL logging in 8.3  (Tatsuo Ishii <ishii@postgresql.org>)
Re: avoiding WAL logging in 8.3  (Jim Nasby <decibel@decibel.org>)
List pgsql-hackers
On Tue, 2007-07-24 at 13:04 +0900, Tatsuo Ishii wrote:

> I noticed in 8.3 there are chances where we can avoid WAL logging. For
> example, 8.3's pgbench was modified to use TRUNCATE right before
> COPY. Is there any documentation which describes that kind of
> techniques? If there's none, I would volunteer the work to create such
> a documentation since I think this is valuable information for DBAs
> who wish to migrate to 8.3.

The Performance Tips section has been modified to describe this. Would
you like me to add something elsewhere also? Multiple entry points to
information helps everybody, so I'll happily add more.

--  Simon Riggs EnterpriseDB  http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: autovacuum default parameters
Next
From: "Simon Riggs"
Date:
Subject: Re: Reviewing new index types (was Re: [PATCHES]Updatedbitmap indexpatch)