Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] New Driver and Unique Indexes

From: "Vadim B(dot) Mikheev" <vadim(at)sable(dot)krasnoyarsk(dot)su>
To: Byron Nikolaidis <byronn(at)insightdist(dot)com>
Cc: "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: [HACKERS] New Driver and Unique Indexes
Date: 1998-04-28 01:57:31
Message-ID: 3545378B.C6263F16@sable.krasnoyarsk.su (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-interfaces
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

In response to

Responses

pgsql-hackers by date

Next:From: Vadim B. MikheevDate: 1998-04-28 02:01:25
Subject: Re: [QUESTIONS] Postgres still dying on insert
Previous:From: John GoerzenDate: 1998-04-28 01:16:39
Subject: Re: User names cannot contain `-'

pgsql-interfaces by date

Next:From: Vadim B. MikheevDate: 1998-04-28 02:04:48
Subject: Re: [INTERFACES] Re: [HACKERS] New Driver and Unique Indexes
Previous:From: Byron NikolaidisDate: 1998-04-27 19:05:11
Subject: New Driver and Unique Indexes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group