> 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;
>> (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.
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 ?
In response to
pgsql-performance by date
|Next:||From: Joshua D. Drake||Date: 2008-01-22 20:19:21|
|Subject: Re: SELECT * FROM table is too slow|
|Previous:||From: Luiz K. Matsumura||Date: 2008-01-22 19:32:17|
|Subject: Optimizing queries that use temporary tables|