Proper Sizing of Shared Buffer Cache

From: "Don Kelloway" <dkelloway(at)commodon(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Proper Sizing of Shared Buffer Cache
Date: 2004-10-13 14:19:33
Message-ID: VPabd.2789$NX5.1793@newsread3.news.atl.earthlink.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm a first-time user with PostgreSQL so please forgive my ignorance.

I've purchased (and read) Practical PostgreSQL (O'Reilly) and PostgreSQL
Essential Reference (New Riders). So far, so good. I think learning
PostgreSQL will not be as difficult as I thought it would be. I've also
been googling for the last few days, but I have a question in regards to
determining the proper size of the buffer cache parameter.

http://www.postgresql.org/docs/aw_pgsql_book/hw_performance/node6.html

The above webpage states that ideally, the POSTGRESQL shared buffer cache
will be:

- Large enough to hold most commonly-accessed tables
- Small enough to avoid swap pagein activity

My question is how do you determine how large the most commonly-accessed
table(s) are? I thought maybe I could view the pg_stat_database, but I
don't think that provides the answer I'm seeking. Can someone point me in
the right direction? It would be very much appreciated.

Best regards,
Don Kelloway

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ken 2004-10-13 14:37:43 Re: query problem
Previous Message Bruce Momjian 2004-10-13 14:11:11 Re: [GENERAL] Reusable pl/pgsql samples ?