Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT * FROM table is too slow - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: SELECT * FROM table is too slow
Date
Msg-id 20071216190347.GA28010@uio.no
Whole thread Raw
In response to SELECT * FROM table is too slow  (Adam PAPAI <wooh@wooh.hu>)
List pgsql-performance
Tree view 
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/

pgsql-performance by date:

Previous
From: Craig James
Date:
Subject: Re: libgcc double-free, backend won't die
Next
From: Gregory Stark
Date:
Subject: Re: libgcc double-free, backend won't die