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 wrote:Hi,
If we run the commands "vacumm full analyze" and "reindex table", this
can be considered as equivalent to making a dump / restore in this case ?
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
