Manfred Koizar <mkoi-pg@aon.at> writes:
> On Thu, 11 Sep 2003 00:25:53 -0400, Tom Lane <tgl@sss.pgh.pa.us>
> wrote:
>> "int8col = 42" isn't indexable. [...] --- maybe
>> just taking out the int8-vs-int4 comparison operators would improve
>> matters. I might be willing to advocate another initdb to do that,
> You mean
> DELETE FROM pg_operator WHERE oid in (15, 36, 416, 417);
> and possibly some more oids? Does this really require an initdb?
I think so. Consider for instance stored views that contain references
to those operators. In any case, I don't really want to have to ask
people who complain about 7.4 performance problems whether they've done
the above.
regards, tom lane