| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Manfred Koizar <mkoi-pg(at)aon(dot)at> |
| Cc: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, Vivek Khera <khera(at)kcilink(dot)com>, pgsql-general(at)postgresql(dot)org, Andrew Rawnsley <ronz(at)ravensfield(dot)com> |
| Subject: | Re: State of Beta 2 |
| Date: | 2003-09-12 14:37:20 |
| Message-ID: | 10980.1063377440@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Manfred Koizar <mkoi-pg(at)aon(dot)at> writes:
> On Thu, 11 Sep 2003 00:25:53 -0400, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-09-12 14:57:36 | Re: selecting random rows |
| Previous Message | Network Administrator | 2003-09-12 14:27:39 | Re: Picture with Postgres and Delphi |