Quoting Tom Lane <[EMAIL PROTECTED]>:
> Kim Bisgaard <[EMAIL PROTECTED]> writes:
> > W.r.t. your rewrite of the query, I get this "ERROR: could not devise a
> > query plan for the given query" but no further details - I will try google
>
> Which PG v
Quoting Tom Lane <[EMAIL PROTECTED]>:
> Kim Bisgaard <[EMAIL PROTECTED]> writes:
> > SELECT station_id, timeobs,temp_grass, temp_dry_at_2m
> > FROM temp_dry_at_2m a
> > FULL OUTER JOIN temp_grass b
> > USING (station_id, timeob
rote:
On Wed, Jun 08, 2005 at 11:37:40 +0200,
Kim Bisgaard <[EMAIL PROTECTED]> wrote:
Hi,
I'm having problems with the query optimizer and FULL OUTER JOIN on
PostgreSQL 7.4. I cannot get it to use my indexes with full outer joins.
I might be naive, but I think that it should be p
re virtually identical??
I have tried to formulate the problem with left joins, but this demands
from me that I know which table has all the values (and thus has to go
first), and in practice no such table excists.
TIA,
Kim Bisgaard.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
btree (station_id, timeobs)
The difference between the two queries is if a (station_id,timeobs) row
is missing in one table, then the first returns one record(null,9.3)
while the second return no records.
Regards,
Kim Bisgaard.
Tom Lane wrote:
Kim Bisgaard <[EMAIL PROTECTED]> writes:
Hi,
Look for my comments further down...
John A Meinel wrote:
Kim Bisgaard wrote:
Hi,
I'm having problems with the query optimizer and FULL OUTER JOIN on
PostgreSQL 7.4. I cannot get it to use my indexes with full outer joins.
I might be naive, but I think that it should be possible?
I hav
.00..6.00 rows=1 width=16) (actual time=13.694..13.698 rows=1 loops=1)
Index Cond: (("outer".station_id = a.station_id) AND (a.timeobs = '2004-01-01 00:00:00'::timestamp without time zone))
Total runtime: 79.340 ms
(9 rows)
If further info like EXPLAIN VERBOSE is useful please say so and I will
provide it.
Thanks in advance!
Kim Bisgaard.