| From: | Jean-Christophe Boggio <cat(at)thefreecat(dot)org> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re[2]: Weird indices |
| Date: | 2001-02-18 14:29:00 |
| Message-ID: | 39202692.20010218152900@thefreecat.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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(at)thefreecat(dot)org
Independant Consultant and Developer
Delphi, Linux, Perl, PostgreSQL
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian deSouza | 2001-02-18 16:17:50 | Date types in where clause of PreparedStatement |
| Previous Message | Chris Humphries | 2001-02-18 13:03:17 | doh! 13000+ rows |