Confusion on shared buffer

From: S Arvind <arvindwill(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Confusion on shared buffer
Date: 2009-10-01 08:11:33
Message-ID: abf9211d0910010111o32444cc7mada23c38d8000666@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

In some docs i read that shared buffer must be increased based on the
maximum dataset size. For my scenario the dataset size is relative small
less then a Gb, but database# handled by a server is nearly 200db per
server and average connection# to server will be >500 (approx 5/per each
DB). So for this scenario will increase in shared buffer will increase the
performance.
FYI: RAM in 8GB

Regards,
Arvind S

*
"Many of lifes failure are people who did not realize how close they were to
success when they gave up."
-Thomas Edison*

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message S Arvind 2009-10-01 09:46:59 Best suiting OS
Previous Message Gerd König 2009-10-01 07:20:09 long running insert statement