Re: aggregate on zero rows slow?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: aggregate on zero rows slow?
Date: 2002-05-02 02:21:48
Message-ID: 3933.1020306108@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-05-02 02:33:00 Re: Fwd: Postfix Relay Hub SMTP server: errors from postgresql.org[64.49.215.8]
Previous Message Ron Snyder 2002-05-02 02:11:35 Using views and MS access via odbc