Re: Remove xmin and cmin from frozen tuples

Josh Berkus <josh@agliodbs.com>

From: Josh Berkus <josh@agliodbs.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>, pgsql-hackers@postgresql.org, ITAGAKI Takahiro <itagaki.takahiro@lab.ntt.co.jp>
Date: 2005-09-01T16:13:41Z
Lists: pgsql-hackers
Tom,

> THe only fundamental disadvantage that COPY labors under is having to
> write WAL records.  It might be interesting to do something similar to
> the recent hacks for CREATE TABLE AS, so that a COPY into a table just
> created in the current transaction would skip writing WAL and instead
> fsync the table at the end.

Yes, I thought we discussed doing this for empty tables -- it would be, per 
our tests, a +10% to +30% boost to COPY.

But there was some problem the patch?

-- 
Josh Berkus
Aglio Database Solutions
San Francisco