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 list
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 t
kers@postgresql.org
Subject: Re: [HACKERS] Estimating seq_page_fetch and random_page_fetch
"Tom Lane" <[EMAIL PROTECTED]> writes:
> "Umar Farooq Minhas" <[EMAIL PROTECTED]> writes:
>> How can we accrately estimate the "seq_page_fetch"
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 p
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
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 and
"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 tim
"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 ex
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
