Re: Index of a table is not used (in any case)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mlw <markw(at)mohawksoft(dot)com>
Cc: Zeugswetter Andreas SB SD <ZeugswetterA(at)spardat(dot)at>, Doug McNaught <doug(at)wireboard(dot)com>, Reiner Dassing <dassing(at)wettzell(dot)ifag(dot)de>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Index of a table is not used (in any case)
Date: 2001-10-24 18:21:36
Message-ID: 21688.1003947696@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

mlw <markw(at)mohawksoft(dot)com> writes:
> ... Postgres' statistics are pretty poor too, a relative few very
> populous entries in a table will make it virtually impossible for the
> cost based optimizer (CBO) to use an index.

Have you looked at development sources lately?

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-10-24 18:29:07 Re: Index on wide column
Previous Message Tom Lane 2001-10-24 18:15:20 Re: copying a large object?