Re: PostgreSQL settings for 12GB RAM - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: PostgreSQL settings for 12GB RAM
Date
Msg-id 20030708050200.GF11964@libertyrms.info
Whole thread Raw
In response to Re: PostgreSQL settings for 12GB RAM  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-admin
On Mon, Jul 07, 2003 at 04:01:12PM -0600, scott.marlowe wrote:
>
> This increase in buffers isn't free, since it will now cost Postgresql the
> overhead of manageing said buffers, plus they're in unix shared memory,
> which isn't all that fast compared to kernel level cache.

Also, I learned through painful experience that it gets slower as it
has to manage large data sets.  After some testing, we attempted a 2G
buffer size once, on the grounds that we had 12 G.  At first, we saw
some happy results, but after a couple days, things got painfully
slow.  I eventually concluded that once the buffer was full, managing
it was making the system crawl.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-admin by date:

Previous
From: Rudi Starcevic
Date:
Subject: Re: exporting data
Next
From: "Donald Fraser"
Date:
Subject: Overloading functions that are used by operators.