Re: Inconsistent usage of Index - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: Inconsistent usage of Index
Date
Msg-id Pine.LNX.4.30.0106091815350.778-100000@peter.localdomain
Whole thread Raw
In response to Inconsistent usage of Index  (Subra Radhakrishnan <subra100@yahoo.com>)
List 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@gmx.net   http://funkturm.homeip.net/~peter



pgsql-sql by date:

Previous
From: Subra Radhakrishnan
Date:
Subject: Inconsistent usage of Index
Next
From: Peter Eisentraut
Date:
Subject: Re: Index usage