avoiding WAL logging in 8.3

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: avoiding WAL logging in 8.3
Date: 2007-07-24 04:04:10
Message-ID: 20070724.130410.08320081.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

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.
--
Tatsuo Ishii
SRA OSS, Inc. Japan

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2007-07-24 04:14:44 autovacuum default parameters (was Re: 8.2 is 30% better in pgbench than 8.3)
Previous Message Joshua D. Drake 2007-07-24 03:23:39 Re: 8.2 is 30% better in pgbench than 8.3