Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
Lists: pgsql-hackerspgsql-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: ctas.patch
Description: text/x-patch (16.1 KB)


pgsql-hackers by date

Next:From: Luke LonerganDate: 2005-06-03 22:15:19
Subject: Re: NOLOGGING option, or ?
Previous:From: Bruce MomjianDate: 2005-06-03 21:38:07
Subject: Re: NOLOGGING option, or ?

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group