Proper Sizing of Shared Buffer Cache
От | Don Kelloway |
---|---|
Тема | Proper Sizing of Shared Buffer Cache |
Дата | |
Msg-id | VPabd.2789$NX5.1793@newsread3.news.atl.earthlink.net обсуждение исходный текст |
Ответы |
Re: Proper Sizing of Shared Buffer Cache
|
Список | 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
В списке pgsql-general по дате отправления: