Postgres Pro
Downloads
Home   >   mailing lists

Re: Mistake in my query or Index Scan on subquery failure? (7.4) - Mailing list pgsql-general

From Tom Lane
Subject Re: Mistake in my query or Index Scan on subquery failure? (7.4)
Date
Msg-id 19055.1078356086@sss.pgh.pa.us
Whole thread Raw
In response to Mistake in my query or Index Scan on subquery failure? (7.4)  ("Gellert, Andre" <AGellert@ElectronicPartner.de>)
List pgsql-general
Tree view 
"Gellert, Andre" <AGellert@ElectronicPartner.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

pgsql-general by date:

Previous
From: "Karl O. Pinc"
Date:
Subject: Re: Moving from MySQL to PGSQL....some questions (multilevel
Next
From: Tom Lane
Date:
Subject: Re: Moving from MySQL to PGSQL....some questions (multilevel