Re: Index Scans become Seq Scans after VACUUM ANALYSE

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: mlw <markw(at)mohawksoft(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Index Scans become Seq Scans after VACUUM ANALYSE
Date: 2002-04-17 06:07:20
Message-ID: 1019023641.27903.93.camel@linda
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 2002-04-17 at 06:51, mlw wrote:
> I just think there is sufficient evidence to suggest that if a DBA creates an
> index, there is strong evidence (better than statistics) that the index need be
> used. In the event that an index exists, there is a strong indication that,
> without overwhelming evidence, that the index should be used. You have admitted
> that statistics suck, but the existence of an index must weight (heavily) on
> the evaluation on whether or not to use an index.

But indexes are not, for the most part, there because of a specific
choice to have an index, but as the implementation of PRIMARY KEY and
UNIQUE. Therefore the main part of your argument fails.

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C

"But as many as received him, to them gave he power to
become the sons of God, even to them that believe on
his name." John 1:12

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Oliver Elphick 2002-04-17 06:07:21 Re: Index Scans become Seq Scans after VACUUM ANALYSE
Previous Message mlw 2002-04-17 06:00:24 Re: Index Scans become Seq Scans after VACUUM ANALYSE