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