Re: unusual performance for vac following 8.2 upgrade

Kim wrote:

<snip>
> OS: Solaris 10
> write transactions/hr: 1.5 million
> size of pg_class: 535,226
> number of relations: 108,694
>
That is a huge pg_class.  I remember some discussion recently about
problems with 8.2 and the way it scans pg_class.  I also believe it's
fixed in 8.2.1.  Are you running that.  If not, I suggest you upgrade
and see if the fault still exists.

Regards

Russell Smith
> Thanks to all,
>
> Kim
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
>                http://www.postgresql.org/about/donate
>
>