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

From Tom Lane
Subject Re: Strangely Variable Query Performance
Date
Msg-id 12736.1176439091@sss.pgh.pa.us
Whole thread Raw
In response to Re: Strangely Variable Query Performance  (Steve <cheetah@tanabi.org>)
Responses Fwd: Strangely Variable Query Performance  ("Robins Tharakan" <robins@pobox.com>)
List pgsql-performance
Steve <cheetah@tanabi.org> writes:
> On Thu, 12 Apr 2007, Tom Lane wrote:
>> I'm still not having any luck reproducing the failure here.  Grasping at
>> straws again, I wonder if it's got something to do with the order in
>> which the planner examines the indexes --- which is OID order.  Could
>> you send me the results of

> Here you go:

Nope, still doesn't fail for me.  [ baffled and annoyed... ]  There must
be something about your situation that's relevant but we aren't
recognizing it.  Are you in a position to let me ssh into your machine
and try to debug it?  Or other options like sending me a dump of your
database?   I'm about out of steam for tonight, but let's talk about it
off-list tomorrow.

            regards, tom lane

pgsql-performance by date:

Previous
From: Steve
Date:
Subject: Re: Question about memory allocations
Next
From: Andrew McMillan
Date:
Subject: Re: Question about memory allocations