On Sun, Dec 16, 2007 at 07:34:45PM +0100, Adam PAPAI wrote: > Why does it take cca 18-20 sec to get the results? > Too many indexes?
You cannot possibly have VACUUMed in a long time. Try a VACUUM FULL, and then schedule regular VACUUMs (or use autovacuum). /* Steinar */ -- Homepage: http://www.sesse.net/ ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
