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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html