On Tuesday 24 May 2005 22:33, Tom Lane wrote: > Jerome Macaranas <jerome@xxxxxxxxx> writes: > > LOG: query: SELECT * FROM phpbb_smilies > > LOG: duration: 0.005410 sec > > LOG: duration: 390.731807 sec > > -- this table has only 295 rows > > I think this is an artifact of your lack-of-vacuuming problems; > the table has become hugely bloated and it takes a long time to > scan through it to find the few live rows. You'll need to do > a VACUUM FULL (or possibly CLUSTER) to shrink the table back > to a reasonable size. im doing a vacuum analyze every hour and doing a full vacuum every midnight.. > > regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
