From: Vadim B. Mikheev <vadim@sable.krasnoyarsk.su>
To: Byron Nikolaidis <byronn@insightdist.com>
Cc: pgsql-interfaces@postgreSQL.org <pgsql-interfaces@postgreSQL.org>
Cc: Sbragion Denis <infotecn@tin.it>
Cc: pgsql-hackers@postgreSQL.org <pgsql-hackers@postgreSQL.org>
Cc: Olaf Mittelstaedt <mstaedt@va-sigi.va.fh-ulm.de>
Cc: Hannu Krosing <hannu@trust.ee>
Subject: Re: [HACKERS] New Driver and Unique Indexes
Date: Tue, 28 Apr 1998 09:57:31 +0800
Message-ID: <3545378B.C6263F16@sable.krasnoyarsk.su> (raw)
References: <3544D6E7.3211AAB4@insightdist.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: vadim@sable.krasnoyarsk.su, byronn@insightdist.com, infotecn@tin.it, pgsql-hackers@postgreSQL.org, mstaedt@va-sigi.va.fh-ulm.de, hannu@trust.ee
Subject: Re: [HACKERS] New Driver and Unique Indexes
In-Reply-To: <3545378B.C6263F16@sable.krasnoyarsk.su>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox