Re: Inconsistent usage of Index

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Subra Radhakrishnan <subra100(at)yahoo(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Inconsistent usage of Index
Date: 2001-06-09 16:17:05
Message-ID: Pine.LNX.4.30.0106091815350.778-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Subra Radhakrishnan writes:

> I have attached file explaining inconsistent usage of
> Index.

In the first case the system thinks it's getting 22 rows back, in the
second 713. Depending on how many rows are in the table and whether those
estimates are close, choosing a sequential scan in the second case is
probably okay.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Eisentraut 2001-06-09 16:21:02 Re: Index usage
Previous Message Ondrej Palkovsky 2001-06-09 15:50:11 Do I have to lock table in this case?