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