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
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 ? |