| From: | "Vadim B(dot) Mikheev" <vadim(at)sable(dot)krasnoyarsk(dot)su> |
|---|---|
| To: | Byron Nikolaidis <byronn(at)insightdist(dot)com>, "pgsql-interfaces(at)postgreSQL(dot)org" <pgsql-interfaces(at)postgreSQL(dot)org>, Sbragion Denis <infotecn(at)tin(dot)it>, "pgsql-hackers(at)postgreSQL(dot)org" <pgsql-hackers(at)postgreSQL(dot)org>, Olaf Mittelstaedt <mstaedt(at)va-sigi(dot)va(dot)fh-ulm(dot)de>, Hannu Krosing <hannu(at)trust(dot)ee> |
| Subject: | Re: [INTERFACES] Re: [HACKERS] New Driver and Unique Indexes |
| Date: | 1998-04-28 02:04:48 |
| Message-ID: | 35453940.45CB3AD6@sable.krasnoyarsk.su |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-interfaces |
Sorry for koi-8 charset :)
Vadim B. Mikheev wrote:
>
> Byron Nikolaidis wrote:
> >
> > SELECT balance_id,company_id, balance_date, is_audited,comment,
> > balance_type, balance_filename FROM balance WHERE balance_id = 1 AND
> > company_id=1 OR balance_id = 1 AND company_id=2 OR balance_id = 1 AND
> > company_id=3 OR balance_id = 2 AND company_id=1 OR balance_id = 2 AND
> > company_id=2 OR balance_id = 2 AND company_id=3 OR balance_id = 3 AND
> > company_id=1 OR balance_id = 3 AND company_id=2 OR balance_id = 3 AND
> > company_id=3 OR balance_id = 4 AND company_id=1
> >
> > Any more than 2 keyparts, results in crashing the backend with the
> > message
> > "palloc failure: memory exhausted". Even at 2 keyparts, performance
> > suffers greatly.
>
> THis is known problem of canonificator in optimizer. This query will
> crash backend without any indices too.
> We told about this in the 6.3-beta period.
> No fix currently. I don't know when it will be at all.
>
> Vadim
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1998-04-28 02:17:55 | Re: [HACKERS] Re: [INTERFACES] retrieving varchar size |
| Previous Message | Thomas G. Lockhart | 1998-04-28 02:02:05 | Re: [HACKERS] postgres init script things solved |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1998-04-28 02:17:55 | Re: [HACKERS] Re: [INTERFACES] retrieving varchar size |
| Previous Message | Vadim B. Mikheev | 1998-04-28 01:57:31 | Re: [HACKERS] New Driver and Unique Indexes |