Re: getting count for a specific querry - Mailing list pgsql-sql

From Joel Fradkin
Subject Re: getting count for a specific querry
Date
Msg-id 008001c53c7f$3c35a930$797ba8c0@jfradkin
Whole thread Raw
In response to Re: getting count for a specific querry  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: getting count for a specific querry
Next
From: PFC
Date:
Subject: Re: getting count for a specific querry