[EMAIL PROTECTED] (Simon Riggs) writes: > On Sat, 2005-12-10 at 12:07 +0000, Simon Riggs wrote: >> Following patch implements COPY ... FROM ... LOCK > > Patch now updated so that it includes an additional optimization of > COPY, so that WAL will not be written in the transaction that created > the table. > > This now gives two fast paths for COPY: > 1) COPY LOCK > 2) COPY in same transaction (e.g. reloading a pg_dump)
I presume that if this doesn't go into WAL, that means that this kind of update wouldn't play with PITR, right? That's presumably something that otta be pretty carefully documented :-). -- select 'cbbrowne' || '@' || 'cbbrowne.com'; http://cbbrowne.com/info/nonrdbms.html Microsoft Outlook: Deploying Viruses Has Never Been This Easy! ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend