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). > 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 7: don't forget to increase your free space map settings
