From: Joel Fradkin <jfradkin@wazagua.com>
To: 'Scott Marlowe' <smarlowe@g2switchworks.com>
To: 'Vivek Khera' <vivek@khera.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: getting count for a specific querry
Date: Fri, 08 Apr 2005 17:09:21 -0400
Message-ID: <008001c53c7f$3c35a930$797ba8c0@jfradkin> (raw)
In-Reply-To: <1112993454.20921.89.camel@state.g2switchworks.com>
I turned off hyperthreading (I saw that on the list that it did not help on
Linux).
I am using a pretty lightweight windows box Optiplex with IDE 750-meg
internal 2.4 mghz cpu.
My desktop has 2 gig, so might not be bad idea to try it local (I have
installed), but me thinks its not totally a hardware issue for us.
Joel Fradkin
Do you run your 2650s with hyperthreading on? I found that slowed mine
down under load, but we never had more than a couple dozen users hitting
the db at once, so we may well have had a different load profile than
what you're seeing.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
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-sql@postgresql.org
Cc: jfradkin@wazagua.com, smarlowe@g2switchworks.com, vivek@khera.org
Subject: Re: getting count for a specific querry
In-Reply-To: <008001c53c7f$3c35a930$797ba8c0@jfradkin>
* 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