Re: Need input on postgres used for phpBB

On Thu, 2005-05-12 at 00:33, Jerome Macaranas wrote:
> On Tuesday 10 May 2005 22:00, Scott Marlowe wrote:
> > On Mon, 2005-05-09 at 23:35, Jerome Macaranas wrote:
> > > i didnt set fsm... the config i paste is all that i put into place...
> >
> > OK, that's likely a part of your problem.
> >
> > Did you run the vacuumdb -af I recommended? Did it help? If so, you
>
> i have a routine of vacuumdb -af every midnight and vacuumdb -a every 8:00 , 12:00, 17:00
>
> what im seeing is:
>
>
> postgres 25542 32.3 10.5 337680 327816 ? R 12:17 1:09 postgres: myuser mydb myip DELETE
> postgres 25578 34.5 10.5 337684 327880 ? R 12:17 1:13 postgres: myuser mydb myip DELETE
>
> delete takes too long to finish..

You might want to run one of those vacuums, like the one at 1700 by hand
and do a vacuum verbose to see how many tuples are being reclaimed and
how many, if any, are getting left behind etc...

> > Note you may also need to reindex as well.
> >
> ill be doing this.. can i reindex all tables in my DB without starting my db on standalone mode?

Everything but some system indexes and tables, i believe.