Alban Hertroys writes:
> I'm also somewhat surprised to see an array of what appear to be
> integers be cast to bpchar[]. Did you define those coordinates(?) as
> character types? Numerical comparisons tend to be faster than string
> comparisons, which should make some difference on sequenti
On 16 Oct 2009, at 10:59, Christian Schröder wrote:
Hi list,
I have the following query:
SELECT *
FROM base
INNER JOIN pt USING (x) WHERE pt.y IN ('1121', '11411', '11421',
'1161', '1162');
"explain analyze" yields the following result:
Hi list,
I have the following query:
SELECT *
FROM base
INNER JOIN pt USING (x) WHERE pt.y IN ('1121', '11411', '11421',
'1161', '1162');
"explain analyze" yields the following result:
QUERY PLAN
-
