Re: Hardware Tuning

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Hardware Tuning
Date: 2002-08-13 19:25:52
Message-ID: 20020813152552.N31856@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-jdbc

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(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Thomas O'Connell 2002-08-13 19:32:22 Re: performance tuning: shared_buffers, sort_mem; swap
Previous Message Bruce Momjian 2002-08-13 18:54:52 Re: performance tuning: shared_buffers, sort_mem; swap

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jun KAWAI 2002-08-14 06:48:44 md5 authentication bug?
Previous Message Dave Cramer 2002-08-13 19:09:33 Re: NAMEDATALEN going to 64