From: | Vadim Mikheev <vadim(at)krs(dot)ru> |
---|---|
To: | phd2(at)earthling(dot)net |
Cc: | Hannu Krosing <hannu(at)trust(dot)ee>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] Bug on complex join |
Date: | 1999-03-10 02:20:13 |
Message-ID: | 36E5D6DD.749189C7@krs.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Oleg Broytmann wrote:
>
> Hi!
>
> On Tue, 9 Mar 1999, Hannu Krosing wrote:
> > > SELECT cn.date_i, cn.pos_id
> > > FROM central cn
> > > WHERE cn.date_i >= current_date - '300 days'::timespan
> > >
> > > returns 3156 rows. But this:
> > >
> > > SELECT cn.date_i, p.subsec_id, cn.pos_id, p.pos_id
> > > FROM central cn, shops sh, districts d, positions p
> > > WHERE cn.date_i >= current_date - '300 days'::timespan
> >
> > this should return
> > 3156 * count(shops) * count(districts) * count(positions)
> >
> > which is probably too much for the backend ;(
^^^^^^^^^^^^^^^
For the client-side, not for the backend - backend doesn't
keep all result tuples in memory.
>
> Bad news. Thanks for pointing this.
Vadim
From | Date | Subject | |
---|---|---|---|
Next Message | D'Arcy J.M. Cain | 1999-03-10 03:04:48 | Re: [HACKERS] Re: map |
Previous Message | Bruce Momjian | 1999-03-09 23:20:52 | Re: [HACKERS] Re: map |