Re: [GENERAL] Response time between shared buffer cache and operating system

2008-08-13 Thread RASHA OSMAN
> > Right now you need operating system profiling tools to figure all this > > > out. If you were using the latest development rev of PostgreSQL on > > > Solaris/FreeBSD/MacOS, you might collect this information with dtrace, but > > > none of that helps on the 8.1/Linux combo you're running. Ma

[GENERAL] Response time between shared buffer cache and operating system

2008-08-07 Thread RASHA OSMAN
I am using Postgres 8.1.4 on Linux. I am interested in the 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 bgwri