Re: BUG #1681: Selection problem

On Thu, May 26, 2005 at 02:50:44PM +0100, fremaux wrote:
>
> PostgreSQL version: 7.2.2

PostgreSQL 7.2.2 is almost three years old -- consider upgrading
to 7.2.8, or better yet, 8.0.3.

> SELECT list.group_artifact_id, list.name
> FROM artifact_group_list list
> WHERE (list.group_artifact_id=167)
>
> returns 2 lines where the first list.group_artifact_id equals "165". The
> problem is that the only lines that have to be returned are the ones with
> list.group_artifact_id=167

Could you post the query results and the query's EXPLAIN ANALYZE
output?  Do you have an index on group_artifact_id?  If so, and if
EXPLAIN ANALYZE shows that the query uses the index, what happens
if you set enable_indexscan to off?  What type is group_artifact_id?
How often do you vacuum, analyze, and/or reindex the table?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/