Re: Partitioning option for COPY

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Emmanuel Cecchet <manu@asterdata.com>
Cc: Emmanuel Cecchet <Emmanuel.Cecchet@asterdata.com>, Jan Urbański <wulczer@wulczer.org>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2009-11-17T15:55:25Z
Lists: pgsql-hackers
Emmanuel Cecchet <manu@asterdata.com> writes:
> Actually the list is supposed to stay around between statement 
> executions. You don't want to restart with a cold cache at every 
> statement so I really want this structure to stay in memory at a more 
> global level.

Cache?  Why do you need a cache for COPY?  Repeated bulk loads into the
same table within a single session doesn't seem to me to be a case that
is common enough to justify a cache.

(BTW, the quoted code seems to be busily reinventing OID Lists.  Don't
do that.)

			regards, tom lane