| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: COPY with no WAL, in certain circumstances |
| Date: | 2007-01-06 21:40:16 |
| Message-ID: | 200701062140.l06LeGV29828@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Simon Riggs wrote:
> > > Or in other words, does this patch mean that all COPY execution that is
> > > within a transaction will ignore WAL?
> >
> > Yes, because it is possible to do in all cases.
>
> Very happy to add documentation where Tom suggested.
>
> Reason for no documentation was that CREATE INDEX and CREATE TABLE AS
> SELECT already use this optimisation, but to my knowledge neither was/is
> documented on those command pages.
I wasn't aware those used the optimization. Seems they all should be
documented somewhere.
--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2007-01-06 21:41:04 | Re: 8.3 pending patch queue |
| Previous Message | Dave Page | 2007-01-06 21:39:56 | Re: 8.3 pending patch queue |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Euler Taveira de Oliveira | 2007-01-06 21:53:05 | Re: COPY with no WAL, in certain circumstances |
| Previous Message | Simon Riggs | 2007-01-06 21:36:06 | Re: COPY with no WAL, in certain circumstances |