Horton

Re[2]: Weird indices

Jean-Christophe Boggio <cat@thefreecat.org>

View thread View on postgr.es
From: Jean-Christophe Boggio <cat@thefreecat.org>
To: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: pgsql-general@postgresql.org
Date: 2001-02-18T14:29:00Z
Lists: pgsql-general 
Stephan,

Ref : Saturday, February 17, 2001 1:50:32 AM


SS> Do you have a value that is not null that is very common?
SS> It's estimating that there will be 10113 rows that match
SS> nomsession='xxx' which makes a seq scan a much less bad plan.

At first, I thought that couldn't be the case but we happen to have
100000 records where nomsession=''

Just updated them so that their value is null and everything runs
fine. Thanks for your help !

--
Jean-Christophe Boggio
cat@thefreecat.org
Independant Consultant and Developer
Delphi, Linux, Perl, PostgreSQL