pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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








view thread (22+ messages)  latest in thread

Message-ID: <3E14DAFC.3080409@clearmetrix.com>
Permalink:  ../3E14DAFC.3080409@clearmetrix.com/
Also on:    postgresql.org/message-id/3E14DAFC.3080409@clearmetrix.com

 · 

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 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