Re: aggregate on zero rows slow? - Mailing list pgsql-general

From Patrick Welche
Subject Re: aggregate on zero rows slow?
Date
Msg-id 20020502123206.A1752@quartz.newn.cam.ac.uk
Whole thread Raw
In response to Re: aggregate on zero rows slow?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: aggregate on zero rows slow?
Re: aggregate on zero rows slow?
List pgsql-general
On Wed, May 01, 2002 at 10:21:48PM -0400, Tom Lane wrote:
> Patrick Welche <prlw1@newn.cam.ac.uk> writes:
> > ... the select appears to take much longer to complete if the WHERE clause
> > matches zero rows, than if it matches some rows.
>
> Doesn't make any sense to me.  Are you sure the same plan is being
> chosen in both cases?  If so, could you post a complete example?

Yes, same plan both cases. Thanks for the answer: as it doesn't make any
sense to anyone, it must mean there is some corruption somewhere as a result
of Monday morning's powercut => I'll look elsewhere.

Thanks,

Patrick

pgsql-general by date:

Previous
From: Thierry Besancon
Date:
Subject: hexadecimal values
Next
From: "murphy pope"
Date:
Subject: Re: Problem with cursors in PL/pgsql