Postgres Pro
Downloads
Home   >   mailing lists

Re: simple update queries take a long time - postgres 8.3.1 - Mailing list pgsql-general

From mark
Subject Re: simple update queries take a long time - postgres 8.3.1
Date
Msg-id 82fa9e310804010559v69b8c5ekb14b582558de6dec@mail.gmail.com
Whole thread Raw
In response to Re: simple update queries take a long time - postgres 8.3.1  (Tomasz Ostrowski <tometzky@batory.org.pl>)
List pgsql-general
Tree view
On Tue, Apr 1, 2008 at 1:48 AM, Tomasz Ostrowski <tometzky@batory.org.pl> wrote:
On 2008-04-01 09:44, mark wrote:

> I already am running 8.3.1 [ i mentioned in subject].

But I have no experience on anything with more than 1GB of RAM...

Should I reduce shared_buffers to less than 1GB? If that is going to improve performance, I certainly can do it.   I somehow assumed allocating more shared_buffers is always good..?
thanks

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: HOWTO caching data across function calls: temporary tables, cursor?
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: HOWTO caching data across function calls: temporary tables, cursor?