On Thu, Mar 08, 2007 at 07:01:17PM -0500, Umar Farooq Minhas wrote:
displayed, I want cpu cost and io cost displayed separated when i run
EXPLAIN on a particular query. Till now I haven't been able to figure
out a 'clean' way of doing this. Can anyone tell me how much time
should I expect to
It would be interested to see some code here.
Maybe this would be a great oportunity to start - some sort of 'auto-
tune' (as an option), in the area.
--
GJ
C/C++/SQL freelance to hire.
---(end of broadcast)---
TIP 4: Have you searched our
Umar Farooq Minhas [EMAIL PROTECTED] writes:
How can we accrately estimate the seq_page_fetch and =
random_page_fetch costs from outside the postgres using for example a =
C routine.
Use a test case larger than memory. Repeat many times to average out
noise. IIRC, when I did the experiments
Tom Lane [EMAIL PROTECTED] writes:
Umar Farooq Minhas [EMAIL PROTECTED] writes:
How can we accrately estimate the seq_page_fetch and =
random_page_fetch costs from outside the postgres using for example a =
C routine.
Use a test case larger than memory. Repeat many times to average out
on ma treo
-Original Message-
From: Gregory Stark [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 08, 2007 12:37 PM Eastern Standard Time
To: Tom Lane
Cc: Umar Farooq Minhas; pgsql-hackers@postgresql.org
Subject:Re: [HACKERS] Estimating seq_page_fetch
On Thu, Mar 08, 2007 at 05:35:03PM +, Gregory Stark wrote:
Tom Lane [EMAIL PROTECTED] writes:
Umar Farooq Minhas [EMAIL PROTECTED] writes:
How can we accrately estimate the seq_page_fetch and =
random_page_fetch costs from outside the postgres using for example a =
C routine.
On Thu, 2007-03-08 at 17:35 +, Gregory Stark wrote:
When I was running tests I did it on a filesystem where nothing else was
running. Between tests I unmounted and remounted it. As I understand it Linux
associates the cache with the filesystem and not the block device and discards
all
/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:16 PM
Subject: Re: [HACKERS] Estimating seq_page_fetch