On Mon, Dec 01, 2003 at 02:40:30PM +0100, Erik Norvelle wrote: > > it=> explain select * from indethom where clavis < 25;
What's the percentage of the table where clavis < 25? Have you ANALYSEd recently? What does the pg_stats view tell you about this table? > Feel free to point me to any FAQ or previous message that already > answers this question. Thanks in advance! This is a pretty common sort of problem. See the archives of this list for several fairly recent discussions of these sorts of problems. A -- ---- Andrew Sullivan 204-4141 Yonge Street Afilias Canada Toronto, Ontario Canada <[EMAIL PROTECTED]> M2P 2A8 +1 416 646 3304 x110 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org