At 16:23 18/11/2004 +0100, Martijn van Oosterhout wrote: > The system seems to think that a scan is cheap because the table is so > small. The table currently contains just over 10000 elements. So 238 rows is a small part of it. > Have you ever ANALYZEd that table? Yes. That and reindex (in case of a problem). I have also tried ALTER TABLE ALTER COLUMN SET STATISTICS, but without improvement. > Also, EXPLAIN ANALYZE gives a much better idea of what is going on... You mean ANALYZE VERBOSE ? Since the table is still growing, and the amount of rows in the reply of the query is quite uniform (it's not dependant on the size of the table), I hope that the statistics will evolve in a state that will force the use of the index. thanks -- Marc ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
