On Tuesday 24 May 2005 22:33, Tom Lane wrote:
> Jerome Macaranas <jerome@gmanmi.tv> 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