Re: Need input on postgres used for phpBB - Mailing list pgsql-general

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