From: Charles H. Woloszynski <chw@clearmetrix.com>
To: Hilmar Lapp <hlapp@gmx.net>
Cc: Ron Johnson <ron.l.johnson@cox.net>
Cc: PgSQL Performance ML <pgsql-performance@postgresql.org>
Subject: Re: join over 12 tables takes 3 secs to plan
Date: Thu, 02 Jan 2003 19:36:12 -0500
Message-ID: <3E14DAFC.3080409@clearmetrix.com> (raw)
In-Reply-To: <C65E5887-1EB1-11D7-9B10-000393B4BFF6@gmx.net>
References: <C65E5887-1EB1-11D7-9B10-000393B4BFF6@gmx.net>
Hilmar Lapp wrote:
> We are in fact an Oracle shop, but the application I tried to get
> running (http://trackplus.sourceforge.net/) I wanted to run on an OSS
> RDBMS so that I could easily move it onto my laptop etc (BTW
> apparently it was primarily developed on InterBase/Firebird). Anyway,
> I was able to cut the planning time for those queries in half by
> setting geqo_pool_size to 512. However, now it gets stuck for an
> excessive amount of time after the issue update page and I have no
> idea what's going on, and I'm not in the mood to track it down. So
> finally I'm giving up and I'm rolling it out on MySQL on which it is
> working fine, even though I don't like MySQL to say the least.
>
> -hilmar
>
Uhoh, did I just hear a gauntlet thrown down ... works well on MySQL but
not on PostgreSQL. If I can find the time, perhaps I can take a look at
the specific query(ies) and see what is missed in PostgreSQL that MySQL
has gotten right.
If only there were 48 hours in a day :-).
Charlie
--
Charles H. Woloszynski
ClearMetrix, Inc.
115 Research Drive
Bethlehem, PA 18015
tel: 610-419-2210 x400
fax: 240-371-3256
web: www.clearmetrix.com
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: chw@clearmetrix.com, hlapp@gmx.net, ron.l.johnson@cox.net
Subject: Re: join over 12 tables takes 3 secs to plan
In-Reply-To: <3E14DAFC.3080409@clearmetrix.com>
References: <C65E5887-1EB1-11D7-9B10-000393B4BFF6@gmx.net> <3E14DAFC.3080409@clearmetrix.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