Re: Optimizer isn't perfect

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Optimizer isn't perfect
Date: 2003-08-29 16:11:04
Message-ID: 27639.1062173464@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greg Stark <gsstark(at)mit(dot)edu> writes:
> This is the same thing someone else pointed out a while ago. The consequences
> of guessing wrong and favouring a full table scan instead of index lookups
> with nested loops are simply much more severe than the reverse.

It is easy to demonstrate cases where this isn't true.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sander Smeenk 2003-08-29 16:17:43 Re: PostgreSQL upgrade -> fails to start server
Previous Message Jenny - 2003-08-29 16:04:42 LOCK.tag(figuring out granularity of lock)--