RE: primary key scans in sequence

From: Gerald Gutierrez <gml1(at)coldresist(dot)com>
To: "Koen Antonissen" <Koen(at)Cee-Kay(dot)net>, "bernd pinter" <bernd(at)uptime(dot)at>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: RE: primary key scans in sequence
Date: 2001-05-31 23:26:33
Message-ID: 5.1.0.14.0.20010531162518.00ae4a68@coldresist.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I think you're just witnessing the optimizer at work. If it thinks that
doing sequential scans is faster, it will ignore the indices.

At 11:03 AM 5/31/2001 +0200, Koen Antonissen wrote:

>Thing I descovered after i posted to the group was that after creating
>the scheme again, the indexes are used! after vacuum (analyze) the use
>of indexes was gone again on certain tables...
>
>Any other suggestions?

Browse pgsql-sql by date

  From Date Subject
Next Message Muhammed Yazici 2001-06-01 07:41:06 Re: query on two databases ..
Previous Message Peter Eisentraut 2001-05-31 21:08:22 Re: Date manipulation