Re: Partitioning option for COPY - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Partitioning option for COPY
Date
Msg-id 29197.1258473325@sss.pgh.pa.us
Whole thread Raw
In response to Re: Partitioning option for COPY  (Emmanuel Cecchet <manu@asterdata.com>)
Responses Re: Partitioning option for COPY
List 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


pgsql-hackers by date:

Previous
From: Alex Hunsaker
Date:
Subject: Re: Writeable CTE patch
Next
From: Tom Lane
Date:
Subject: Re: Timezones (in 8.5?)