WAL bypass for CTAS

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Cc: Alon Goldshuv <agoldshuv(at)greenplum(dot)com>
Subject: WAL bypass for CTAS
Date: 2005-06-03 22:06:49
Message-ID: 1117836409.3844.1230.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

I enclose a complete patch for avoiding WAL usage for CREATE TABLE AS
SELECT, when not in archive mode (PITR). The main use case for this is
large BI environments that create summary tables or prejoined tables,
though there are many general applications.

There is no user interface for this. The speed gain is automatic, when
archiving is not enabled.

This contains all the lower level machinery required to do the same
thing for COPY, as discussed on hackers. The machinery includes some
additional freespace thinkery, aimed mainly at the forthcoming COPY
patch, which solely needs to be integrated with Alon's work.

Patch is diff -c format, compiles and make checks on cvstip as of now.

No performance tests *on this patch*, though the general principle has
already been proven via a similar prototype patch not published on list.

Best Regards, Simon Riggs

Attachment Content-Type Size
ctas.patch text/x-patch 16.1 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Luke Lonergan 2005-06-03 22:15:19 Re: NOLOGGING option, or ?
Previous Message Bruce Momjian 2005-06-03 21:38:07 Re: NOLOGGING option, or ?

Browse pgsql-patches by date

  From Date Subject
Next Message Alvaro Herrera 2005-06-03 23:44:14 Unused variable in explain.c
Previous Message Bruno Wolff III 2005-06-03 19:24:51 Re: O_DIRECT for WAL writes