On 10/26/2010 11:41 AM, Merlin Moncure wrote:
yup, that's exactly what I mean -- this will give you more uniform insert performance (your temp table doesn't even need indexes). Every N records (say 10000) you send to permanent and truncate the temp table. Obviously, this is more fragile approach so weigh the pros/cons carefully. merlin
Truncate temporary table? What a horrible advice! All that you need is the temporary table to delete rows on commit.
-- Mladen Gogala Sr. Oracle DBA 1500 Broadway New York, NY 10036 (212) 329-5251 http://www.vmsinfo.com The Leader in Integrated Media Intelligence Solutions -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
