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