Postgres Pro
Downloads
Home   >   mailing lists

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

From Joshua D. Drake
Subject Re: SELECT * FROM table is too slow
Date
Msg-id 47657068.5070200@commandprompt.com
Whole thread Raw
In response to SELECT * FROM table is too slow  (Adam PAPAI <wooh@wooh.hu>)
Responses Re: SELECT * FROM table is too slow
List pgsql-performance
Tree view 
Adam PAPAI wrote:
> Hi pgsql-performance,
>
> I've a problem with the select * on a small table.
>
> See below:
>
>
> x7=# SELECT count(idn) from megjelenesek;
>  count
> -------
>    162
> (1 row)
>
> Why does it take cca 18-20 sec to get the results?
> Too many indexes?

You likely have a huge amount of dead rows. Try dumping and restoring
the table and remember to run vacuum (or autovacuum) often.

Sincerely,


Joshua D. Drake

pgsql-performance by date:

Previous
From: Adam PAPAI
Date:
Subject: SELECT * FROM table is too slow
Next
From: "Merlin Moncure"
Date:
Subject: Re: update 600000 rows