Re: Reducing memory usage of insert into select operations?

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: Douglas McNaught <doug(at)mcnaught(dot)org>
Cc: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Reducing memory usage of insert into select operations?
Date: 2008-07-18 03:27:06
Message-ID: cone.1216351626.907297.29970.1000@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Douglas McNaught writes:

> Is this a 32-bit installation or 64-bit? 3GB of shared_buffers is way
> too big for a 32-bit setup.

64-bit.
The machine has 12GB of RAM so shared-buffers is about 1/3.
Dedicated DB server.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Douglas McNaught 2008-07-18 03:38:28 Re: Reducing memory usage of insert into select operations?
Previous Message Douglas McNaught 2008-07-18 03:10:18 Re: Reducing memory usage of insert into select operations?