-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 an