Re: SELECT * FROM table is too slow

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: Adam PAPAI <wooh(at)wooh(dot)hu>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: SELECT * FROM table is too slow
Date: 2007-12-16 19:03:47
Message-ID: 20071216190347.GA28010@uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Gregory Stark 2007-12-16 20:06:47 Re: libgcc double-free, backend won't die
Previous Message Craig James 2007-12-16 19:03:11 Re: libgcc double-free, backend won't die