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 |
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 ? |
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 |