On Thu, 2007-01-11 at 15:01 -0600, Jim C. Nasby wrote: > I'm wondering if you see any issues with COPYing into a partitioned > table that's using triggers instead of rules to direct data to the > appropriate tables? The data demographics usually guides you towards what to do. You could COPY into the table that would receive most rows and use before triggers to INSERT into the other tables, rather than the main one. I'd be surprised if that was very fast for an even distribution though. It could well be faster if you have a small number of rows into a large number of targets because that would be quicker than re-scanning a temp table repeatedly just to extract a few rows each time. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com
