Adam PAPAI <wooh@wooh.hu> wrote ..
> Hi pgsql-performance,
>
> I've a problem with the select * on a small table.
>
I can think of two possibilities for such incredibly slow performance.
One: your table has not been VACUUMed for a long time and is full of dead tuples. Try VACUUM FULL on it, or CLUSTER on
themost frequently used index.
Two: did you accidentally put the database on your floppy drive?