Connecting Tech Pros Worldwide Forums | Help | Site Map

shared buffer cache monitoring

Newbie
 
Join Date: Aug 2008
Posts: 1
#1: Aug 8 '08
I am using Postgres 8.1.4 on Linux. I am interested in calculating the following for a specific application:

How long it takes the operating system to fulfil a page demand, ie, reading the page from disk or from the OS cache to the Postgres shared buffer.

Also how long it takes the bgwriter to flush a page from the shared buffer into the OS cache or disk.

These can be averages or detailed info that I can analyze with other tools

Are there any functions/views available that log this information, if not where should I start in the source code.

Reply


Similar PostgreSQL Database bytes