Re: Indices get ignored in large tables

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Apua Paquola <apua(at)iq(dot)usp(dot)br>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Indices get ignored in large tables
Date: 2001-08-29 18:30:24
Message-ID: Pine.BSF.4.21.0108291128180.48187-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


You probably need to run vacuum analyze after filling in the data.
Otherwise it's using bogus selectivity (see the number of expected
rows returned by the explain output, it's expecting 6000 rows after
the create index, which is large enough to make it guess that
it'll be cheaper to sequence scan the table.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephan Szabo 2001-08-29 18:36:21 Re: postmaster quits
Previous Message Stephan Szabo 2001-08-29 18:27:52 Re: Odp: PD: triggered data change violation on relation "tbl_b"