Adam PAPAI <wooh@xxxxxxx> 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 the most frequently used index. Two: did you accidentally put the database on your floppy drive? ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
