Re: [HACKERS] Buffer miss ratio

2009-01-01 Thread Heikki Linnakangas
崔岩ccuiy...@sina.com wrote: I want to get the number of misses for the buffer pool of PostgreSQL. Is there any methods or performance tools I can use to get the information? Yes. Please see the manual chapters on "Monitoring database activity". The pgstatio_* views in particular. P

[HACKERS] Buffer miss ratio

2009-01-01 Thread 崔岩ccuiy...@sina.com
Dear all: A quick question about shared buffers in PostgreSQL: I want to get the number of misses for the buffer pool of PostgreSQL. Is there any methods or performance tools I can use to get the information? Best Wishes yyan