From: Peter Koczan <pjkoczan@gmail.com>
To: Thomas Zaksek <zaksek@ptt.uni-due.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: Join Query Perfomance Issue
Date: Tue, 12 Feb 2008 14:34:28 -0600
Message-ID: <4544e0330802121234l33be13a9g5dec39ef032f6268@mail.gmail.com> (raw)
In-Reply-To: <47B08F19.8000500@ptt.uni-due.de>
References: <47B08F19.8000500@ptt.uni-due.de>
> I have serious performance problems with the following type of queries:
>
> Doesnt looks too bad to me, but i'm not that deep into sql query
> optimization. However, these type of query is used in a function to
> access a normalized, partitioned database, so better performance in this
> queries would speed up the whole database system big times.
> Any suggestions here would be great. I allready tested some things,
> using inner join, rearranging the order of the tables, but but only
> minor changes in the runtime, the version above seemed to get us the
> best performance.
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
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: pjkoczan@gmail.com, zaksek@ptt.uni-due.de
Subject: Re: Join Query Perfomance Issue
In-Reply-To: <4544e0330802121234l33be13a9g5dec39ef032f6268@mail.gmail.com>
* 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