Response time between shared buffer cache and operating system

Поиск
Список
Период
Сортировка
От RASHA OSMAN
Тема Response time between shared buffer cache and operating system
Дата
Msg-id BAY117-W50B7BCEC6580E2A63816D396750@phx.gbl
обсуждение исходный текст
Ответы Re: Response time between shared buffer cache and operating system  (Greg Smith <gsmith@gregsmith.com>)
Список pgsql-general

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 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 how should I change the source code.


Win £3000 to spend on whatever you want at Uni! Click here to WIN!

В списке pgsql-general по дате отправления:

Предыдущее
От: Sim Zacks
Дата:
Сообщение: Re: bytea encode performance issues
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: pg_restore fails on Windows