"Simon Riggs" <simon@xxxxxxxxxxxxxxx> 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
