Re: Mistake in my query or Index Scan on subquery failure? (7.4)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gellert, Andre" <AGellert(at)ElectronicPartner(dot)de>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Mistake in my query or Index Scan on subquery failure? (7.4)
Date: 2004-03-03 23:21:26
Message-ID: 19055.1078356086@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Gellert, Andre" <AGellert(at)ElectronicPartner(dot)de> writes:
> Is it okay , that the word ref_artikel_pkey will be repeated for each
> condition ?

That's what it's supposed to do. EXPLAIN is trying to tell you that
this query involves three independent index probes, which should not be
very surprising.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karl O. Pinc 2004-03-03 23:22:44 Re: Moving from MySQL to PGSQL....some questions (multilevel
Previous Message Karl O. Pinc 2004-03-03 23:13:19 REFERENCES error message complaint, suggestion