Re: Hardware Tuning - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: Hardware Tuning
Date
Msg-id 20020813152552.N31856@mail.libertyrms.com
Whole thread Raw
In response to Hardware Tuning  (Chris Gamache <cgg007@yahoo.com>)
List pgsql-admin
On Tue, Aug 13, 2002 at 11:37:15AM -0700, Chris Gamache wrote:
>
> ---[postgresql.conf]-----------
>
> max_connections = 32
> shared_buffers = 256

You can probably increase the shared buffers by a lot.  256 is _not_
256 meg: it's 256 buffers, which are typically 8192 bytes.

A

--
----
Andrew Sullivan                               87 Mowat Avenue
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110


pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: performance tuning: shared_buffers, sort_mem; swap
Next
From: Thomas O'Connell
Date:
Subject: Re: performance tuning: shared_buffers, sort_mem; swap