Re: State of Beta 2 - Mailing list pgsql-general

From Tom Lane
Subject Re: State of Beta 2
Date
Msg-id 10980.1063377440@sss.pgh.pa.us
Whole thread Raw
In response to Re: State of Beta 2  (Manfred Koizar <mkoi-pg@aon.at>)
Responses Re: State of Beta 2
Re: State of Beta 2
List pgsql-general
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

pgsql-general by date:

Previous
From: Network Administrator
Date:
Subject: Re: Picture with Postgres and Delphi
Next
From: Jason Alan Smith
Date:
Subject: ...