On Tuesday 17 December 2002 07:13 pm, you wrote:
> On Tuesday, December 17, 2002, at 07:35 AM, Shridhar Daithankar wrote:
> > What is the vacuum frequency?
>
> Every morning. This db is almost exclusively INSERT and SELECT. Well,
> I take that back, a single table gets UPDATEs rather frequently.
> Otherwise, INSERT only.
i recommend a vacuum analyze per 1000/2000 records for the table that gets
updated. It should boost the performance like anything..
Shridhar