On Sat, 29 Nov 2003 08:49:24 -0800 (PST), ow wrote
explain select b, c, a from test group by b, c, a having count(*) > 1
Why would you expect this to use an index scan when it needs to read the entire table? If you read the whole table (or even a significant fraction of it), a seq scan is faster.
Joe
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html