Re: Fwd: Strangely Variable Query Performance - Mailing list pgsql-performance

From Tom Lane
Subject Re: Fwd: Strangely Variable Query Performance
Date
Msg-id 14929.1176785073@sss.pgh.pa.us
Whole thread Raw
In response to Fwd: Strangely Variable Query Performance  (Robins <tharakan@gmail.com>)
List pgsql-performance
Robins <tharakan@gmail.com> writes:
> If and when you do come up with a solution, please do post some details
> about them here... (i say that coz it seems that for obvious reasons, things
> must have gone off air after tom's last email, and one can understand that).
> But an analysis, or atleast a pointer may be of help to someone (like me)
> reading this list.

Oh, sorry, the subsequent discussion moved over to pgsql-hackers:
http://archives.postgresql.org/pgsql-hackers/2007-04/msg00621.php
and -patches:
http://archives.postgresql.org/pgsql-patches/2007-04/msg00374.php

Those are good places to look if a discussion on -bugs or other lists
seems to tail off...

            regards, tom lane

PS: the reason I couldn't reproduce the behavior was just that the dummy
data I was using didn't have the right statistics.

pgsql-performance by date:

Previous
From: Robins
Date:
Subject: Fwd: Strangely Variable Query Performance
Next
From: "Merlin Moncure"
Date:
Subject: Re: Basic Q on superfluous primary keys