pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Thomas Zaksek <zaksek@ptt.uni-due.de>
To: pgsql-performance@postgresql.org
Subject: Re: Join Query Perfomance Issue
Date: Wed, 13 Feb 2008 12:17:29 +0100
Message-ID: <47B2D1C9.2080609@ptt.uni-due.de> (raw)
In-Reply-To: <4544e0330802121234l33be13a9g5dec39ef032f6268@mail.gmail.com>
References: <47B08F19.8000500@ptt.uni-due.de>
	<4544e0330802121234l33be13a9g5dec39ef032f6268@mail.gmail.com>

 > 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



view thread (12+ messages)  latest in thread

Message-ID: <47B2D1C9.2080609@ptt.uni-due.de>
Permalink:  ../47B2D1C9.2080609@ptt.uni-due.de/
Also on:    postgresql.org/message-id/47B2D1C9.2080609@ptt.uni-due.de

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: zaksek@ptt.uni-due.de
  Subject: Re: Join Query Perfomance Issue
  In-Reply-To: <47B2D1C9.2080609@ptt.uni-due.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox