Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: aggregate on zero rows slow?
Date
Msg-id 3933.1020306108@sss.pgh.pa.us
Whole thread Raw
In response to aggregate on zero rows slow?  (Patrick Welche <prlw1@newn.cam.ac.uk>)
Responses Re: aggregate on zero rows slow?
List pgsql-general
Tree view 
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?

            regards, tom lane

pgsql-general by date:

Previous
From: Ron Snyder
Date:
Subject: Using views and MS access via odbc
Next
From: Tom Lane
Date:
Subject: Re: Fwd: Postfix Relay Hub SMTP server: errors from postgresql.org[64.49.215.8]