Re: Reducing memory usage of insert into select operations?

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Francisco Reyes <lists(at)stringsutils(dot)com>
Cc: Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Reducing memory usage of insert into select operations?
Date: 2008-07-18 16:23:02
Message-ID: 20080718162302.GC4042@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Douglas McNaught 2008-07-18 16:29:31 Re: Writing a user defined function
Previous Message Scara Maccai 2008-07-18 16:12:31 Re: TODO list and "hyphen"