Re: Join Query Perfomance Issue

> Can you send the table definitions of the tables involved in the
> query, including index information? Might be if we look hard enough we
> can find something.
>
> Peter

Table "messungen_v_dat_2007_11_12"
Column | Type | Modifiers | Description
---------------+--------------+-----------+-------------
ganglinientyp | character(1) | |
minute_tag | smallint | |
messpunkt | integer | |
Indexes:
"messungen_v_dat_2007_11_12_ganglinientyp_key" UNIQUE, btree
(ganglinientyp, minute_tag, messpunkt)
"messungen_v_dat_2007_11_12_messpunkt_idx" btree (messpunkt)
"messungen_v_dat_2007_11_12_messpunkt_minute_tag_idx" btree
(ganglinientyp, minute_tag)
Foreign-key constraints:
"messungen_v_dat_2007_11_12_messpunkt_fkey" FOREIGN KEY (messpunkt)
REFERENCES messpunkt(nr)
Inherits: messungen_v_dat
Has OIDs: no

Table "messpunkt"
Column | Type |
Modifiers | Description
--------+---------+--------------------------------------------------------+-------------
nr | integer | not null default
nextval('messpunkt_nr_seq'::regclass) |
zs_nr | integer
| |
mw_nr | integer
| |
Indexes:
"messpunkt_pkey" PRIMARY KEY, btree (nr)
"messpunkt_zs_nr_key" UNIQUE, btree (zs_nr, mw_nr)
"messpunkt_mw_idx" btree (mw_nr)
"messpunkt_nr_idx" btree (nr)
"messpunkt_zs_idx" btree (zs_nr)
Foreign-key constraints:
"messpunkt_mw_nr_fkey" FOREIGN KEY (mw_nr) REFERENCES de_mw(nr)
"messpunkt_zs_nr_fkey" FOREIGN KEY (zs_nr) REFERENCES de_zs(zs)
Has OIDs: no

Table "de_mw"
Column | Type | Modifiers
| Description
--------+----------+----------------------------------------------------+-------------
nr | integer | not null default nextval('de_mw_nr_seq'::regclass) |
j_ges | smallint | |
mw_abh | integer | |
Indexes:
"de_mw_pkey" PRIMARY KEY, btree (nr)
"de_mw_j_ges_key" UNIQUE, btree (j_ges, mw_abh)
"de_nw_nr_idx" btree (nr)
Check constraints:
"de_mw_check" CHECK (j_ges IS NOT NULL AND (j_ges = 0 AND (mw_abh =
0 OR mw_abh = 255 OR mw_abh IS NULL) OR j_ges > 0 AND j_ges <= 80 AND
mw_abh <> 0))
Has OIDs: no