Re: [PERFORM] unusual performance for vac following 8.2 upgrade - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PERFORM] unusual performance for vac following 8.2 upgrade
Date
Msg-id 5414.1168549900@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PERFORM] unusual performance for vac following 8.2 upgrade  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses Re: [PERFORM] unusual performance for vac following 8.2upgrade  ("Simon Riggs" <simon@2ndquadrant.com>)
List pgsql-hackers
"Simon Riggs" <simon@2ndquadrant.com> writes:
> It's not clear to me how this fix will alter the INSERT issue Kim
> mentions.

I didn't say that it would; we have no information on the INSERT issue,
so I'm just concentrating on the problem that he did provide info on.

(BTW, I suppose the slow-\d issue is the regex planning problem we
already knew about.)

I'm frankly not real surprised that there are performance issues with
such a huge pg_class; it's not a regime that anyone's spent any time
optimizing.  It is interesting that 8.2 seems to have regressed but
I can think of several places that would've been bad before.  One is
that there are seqscans of pg_inherits ...

            regards, tom lane

pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: [PATCHES] Patch to log usage of temporary files
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] Checkpoint request failed on version 8.2.1.