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/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
