Re: master/detail: master rows without details

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Thomas Guettler <hv(at)tbz-pariv(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: master/detail: master rows without details
Date: 2008-12-09 12:26:30
Message-ID: 493E63F6.8070405@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2008-12-09 12:33:46 Re: et_EE locale not found in debian
Previous Message Peter Eisentraut 2008-12-09 12:24:51 Re: et_EE locale not found in debian