On Wed, Oct 29, 2003 at 02:08:03PM -0500, Andrew Biagioni wrote:
>
> So finally, my question. Why is this behavior present? Is it actually
> a feature that I don't know enough to appreciate?
It's the side-effect of some other features in the system. If you
search on -hackers archives you'll
I'm running 7.3, and I recently observed something rather disconcerting,
using EXPLAIN ANALYZE.
If I have an index on an int8 column, and I run a query such as
SELECT * FROM [tablename] WHERE [colname] = 12345
the index is NOT used, and a sequential scan of the 200K rows is done,
taking ~ 175
I'm running 7.3, and I recently found out something rather disconcerting: if I
have an index on an int8 column, and I run a query such as
SELECT * FROM [tablename] WHERE [colname] = 12345
the index is NOT used, and sequential scan of the 200K rows is done, taking ~
17500 msec.; if I ch
