From: | "Vadim B(dot) Mikheev" <vadim(at)sable(dot)krasnoyarsk(dot)su> |
---|---|
To: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | David Hartwig <daveh(at)insightdist(dot)com>, PostgreSQL-development <hackers(at)postgreSQL(dot)org> |
Subject: | Re: [HACKERS] Re: [BUGS] General Bug Report: palloc fails with lots of ANDs and ORs |
Date: | 1998-01-15 04:34:26 |
Message-ID: | 34BD91D2.8A0985F1@sable.krasnoyarsk.su |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Bruce Momjian wrote:
>
> > Bruce,
> >
> > I did some homework. Here is what I have. The default max data segment size on our (AIX 4.1.4) box is around 130000 kbytes.
> >
> > I put together a query which put me just past the threshold of the palloc "out of memory error". It is as follows:
> >
> > create table outlet (
> > number int,
> > name varchar(30),
> > ...
> > }
> >
> > create unique index outlet_key on outlet using btree (number);
> >
> > select count(*) from outlet
> > where
> > (number = 1 and number = 1 and number = 1) or
> > (number = 1 and number = 1 and number = 1) or
> > (number = 1 and number = 1 and number = 1) or
> > (number = 1 and number = 1 and number = 1) or
> > (number = 1 and number = 1 and number = 1) or
> > (number = 1 and number = 1 and number = 1) or
> > (number = 1 and number = 1 and number = 1) or
> > (number = 1 and number = 1 and number = 1) or
> > (number = 1 and number = 1 and number = 1);
> >
...
> >
>
> Wow, looks like a bug. Vadim, why would this happen? I got the same
> palloc failure message here, and there is NO data in the table.
This is bug in optimizer - try to EXPLAIN query...
I have no time to fix it now - could return to this after Feb 1.
Vadim
From | Date | Subject | |
---|---|---|---|
Next Message | Zeugswetter Andreas DBT | 1998-01-15 11:01:23 | Content-based access control |
Previous Message | Thomas G. Lockhart | 1998-01-15 04:23:17 | Linux Journal article on PostgreSQL |