Francisco Reyes wrote: > On 11:25 am 07/18/08 Richard Huxton <[EMAIL PROTECTED]> wrote: > > Strace of the single/large process. > Again, all the query is doing is > insert into <file> select <subquery> > > The strace is pretty much a repetition of the lines below.
Do you have long-running transactions? (For example transactions that have been idle for a long time). -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
