Re: master/detail: master rows without details - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: master/detail: master rows without details
Date
Msg-id 493E63F6.8070405@gmx.net
Whole thread Raw
In response to master/detail: master rows without details  (Thomas Guettler <hv@tbz-pariv.de>)
Responses Re: master/detail: master rows without details
List pgsql-general
Thomas Guettler wrote:
> My naive  first solution was quite slow. Why is it so slow?
> I guess (select d.master_id from detail as d) gets executed for every
> master-row. But why? Shouldn't
> it be possible to calculate it once and then reuse it?

Please show exact schema dumps and your PostgreSQL version.


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: et_EE locale not found in debian
Next
From: "Andrus"
Date:
Subject: Re: et_EE locale not found in debian