From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Joel Fradkin <jfradkin@wazagua.com>
Cc: 'Marc G. Fournier' <scrappy@postgresql.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: who is best for support?
Date: Tue, 15 Feb 2005 15:30:09 -0600
Message-ID: <1108503008.11967.194.camel@state.g2switchworks.com> (raw)
In-Reply-To: <000c01c513a4$4a562110$797ba8c0@jfradkin>
References: <000c01c513a4$4a562110$797ba8c0@jfradkin>
On Tue, 2005-02-15 at 15:21, Joel Fradkin wrote:
> Us? :) Can you provide some more details?
>
> Hardware configuration,
> Dell 6560 4 processor, 8 gig memory, I think I have Postgres on two raids
four processors, or two hyperthreaded cpus? My experience has been that
hyperthreading usually doesn't help, and often hurts performance. This
may have improved with later model 2.6 kernels.
> separate from the OS (pgsql is a raid 10 4 10kdrive array) and /wal is 2 15k
> drives). I am running postgres 8 and am using the conf in
> /var/lib/pgslq/data to point the data at /pgsql and a link to point the /wal
> I set up inside the /pgsql/data folder to /wal.
Which RAID Controller are you using? Does it have battery backed cache?
> I have cut out most of the query but even the first join makes it go to 27
> seconds. In MSSQL with the first two left outers it takes 3 seconds.
Are the columns you are joining on the same type? Are they integers
(the fastest) or numerics (slow) or text (also slow)?
Is there a reason you're joining on so many different fields for each
table? If there is a good model of FK relations, that isn't usually
necessary.
IT looks kinda like there's some redundancy in the join on clauses by
how may of them are from all over the place in there.
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-admin@postgresql.org
Cc: smarlowe@g2switchworks.com, jfradkin@wazagua.com, scrappy@postgresql.org
Subject: Re: who is best for support?
In-Reply-To: <1108503008.11967.194.camel@state.g2switchworks.com>
References: <000c01c513a4$4a562110$797ba8c0@jfradkin> <1108503008.11967.194.camel@state.g2switchworks.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