Re: unusual performance for vac following 8.2 upgrade - Mailing list pgsql-performance

From Tom Lane
Subject Re: unusual performance for vac following 8.2 upgrade
Date
Msg-id 27939.1168539652@sss.pgh.pa.us
Whole thread Raw
In response to unusual performance for vac following 8.2 upgrade  (Kim <kim@myemma.com>)
Responses Re: unusual performance for vac following 8.2 upgrade  (Kim <kim@myemma.com>)
List pgsql-performance
Kim <kim@myemma.com> writes:
> size of pg_class: 535,226
> number of relations: 108,694

Oh, I shoulda read all the way to the bottom of your email :-(.  What
version of PG were you running before?  I would think that pretty much
any version of pgstat_vacuum_tabstats would have had a performance issue
with pg_class that large.  Also, could we see

    select relkind, count(*) from pg_class group by relkind;

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: unusual performance for vac following 8.2 upgrade
Next
From: Russell Smith
Date:
Subject: Re: Improving SQL performance