Hi,
Please find my original message below. This was originally posted to
pgsql-general, but didn't get any response.
Thanks,
-Umar
-- Forwarded message --
From: Umar Farooq
Date: Mon, Mar 9, 2009 at 12:39 PM
Subject: PostgreSQL Memory Management
To: pgsql-gene...@postgresq
Hello All,Recently, I have been involved in some work that requires me to
monitor low level performance counters for pgsql. Specifically, when I execute
a particular query I want to be able to tell how many system calls get executed
on behalf of that query and time of each sys call. The idea is
effect the cost estimates of the planner/optimizer?
Again your help is appreciated.
-Umar
- Original Message -
From: Luke Lonergan
To: Gregory Stark ; Tom Lane ; Ayush Parashar
Cc: Umar Farooq Minhas ; pgsql-hackers@postgresql.org
Sent: Thursday, March 08, 2007 2:1
Hi,
How can we accrately estimate the "seq_page_fetch" and "random_page_fetch"
costs from outside the postgres using for example a C routine. Using a very
simple program in C, I have two sets of files. I want to access one set
randomly i.e. pulling data from random locations within the files. T
