-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dan Ruthers wrote:
| Now, if I run this query (note the int8 cast - also tried with the '' cast to
String, same results):
| test= explain select * from dmaildatum where idparent=int8(783219);
| QUERY PLAN
|
On Mon, 9 Aug 2004, Dan Ruthers wrote:
Now, if I run this query (note the int8 cast - also tried with the '' cast to
String, same results):
test= explain select * from dmaildatum where idparent=int8(783219);
QUERY PLAN
Dan Ruthers wrote:
The index is used!
I also did a vacuum analyze, and restarted Postgres and it did not
make any difference. I tried many other ID values (ex 783218 and
783220), and they seem to use the index correctly. Only that value
doesn't.
Possibly, that is the most common value and