Re: WAL bypass for CTAS

Tom has applied this patch. Thanks.

---------------------------------------------------------------------------

Simon Riggs wrote:
> 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, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073