| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jeff <threshar(at)torgo(dot)978(dot)org> |
| Cc: | Roman Fail <rfail(at)posportal(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, "sszabo(at)megazone23(dot)bigpanda(dot)com" <sszabo(at)megazone23(dot)bigpanda(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: 7.3.1 New install, large queries are slow |
| Date: | 2003-01-17 15:11:17 |
| Message-ID: | 11880.1042816277@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Jeff <threshar(at)torgo(dot)978(dot)org> writes:
> Perhaps this should go on the TODO - when one side is an int8 and the
> other is a literal number assume the number to be int8 instead of int4?
It's been on TODO for so long that it's buried near the bottom.
* Allow SELECT * FROM tab WHERE int2col = 4 to use int2col index, int8,
float4, numeric/decimal too [optimizer]
This behavior interacts with enough other stuff that we can't just
change it willy-nilly. See many past discussions in the pghackers
archives if you want details. A recent example of a promising-looking
fix crashing and burning is
http://fts.postgresql.org/db/mw/msg.html?mid=1357121
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2003-01-17 15:15:34 | Re: 7.3.1 New install, large queries are slow |
| Previous Message | Timur Irmatov | 2003-01-17 15:08:14 | Re: index usage |