Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group