Re: Reducing memory usage of insert into select operations?

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.