On Tue, Oct 26, 2010 at 11:08 AM, Leonardo Francalanci <m_li...@yahoo.it> wrote: >> temp tables are not wal logged or >> synced. Periodically they can be flushed to a permanent table. > > > What do you mean with "Periodically they can be flushed to > a permanent table"? Just doing > > insert into tabb select * from temptable >
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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
