From: Dave Cramer <pg@fastcrypt.com>
To: bh yuan <bhyuan@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Question about shared_buffers and cpu usage
Date: Thu, 21 Feb 2008 07:24:01 -0500
Message-ID: <0DCE2361-E0B5-49F3-9E4D-B87B06DFBADC@fastcrypt.com> (raw)
In-Reply-To: <3c7b84c00802202113x3a705e34u9d9cf307fdde8048@mail.gmail.com>
References: <3c7b84c00802202113x3a705e34u9d9cf307fdde8048@mail.gmail.com>
On 21-Feb-08, at 12:13 AM, bh yuan wrote:
> Hi
>
> I am using Postgres8.3 on 8G memory , Xeon X5355 Quad Core x 2
> processer RH5 machine with 10G data. (with some table which have
> about 2,000,000~ 5,000,000 rows )
>
> I have two quesion.
> 1. how to set the shared_buffers and other postgresql.conf parameter
> for best performance?
> I only run the Postgres8.3 on the machine so I set the shared_buffers
> = 7168MB (7G)
> But somebody said it is too big, so confused.
Yes, it is too big! make it 2G to start
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pg@fastcrypt.com, bhyuan@gmail.com
Subject: Re: Question about shared_buffers and cpu usage
In-Reply-To: <0DCE2361-E0B5-49F3-9E4D-B87B06DFBADC@fastcrypt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox