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
>
>