Francisco Reyes wrote: > On 11:25 am 07/18/08 Richard Huxton <dev@xxxxxxxxxxxx> 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.
