Re: SELECT * FROM table is too slow
This is a discussion on Re: SELECT * FROM table is too slow within the Pgsql Performance forums, part of the PostgreSQL category; --> Adam PAPAI <wooh@wooh.hu> wrote .. > Hi pgsql-performance, > > I've a problem with the select * on a ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 10:43 AM
| ||||
| ||||
 Re: SELECT * FROM table is too slow 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 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      |
Linear Mode
