"Simon Riggs" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
