| From: | "Joel Fradkin" <jfradkin(at)wazagua(dot)com> |
|---|---|
| To: | "'Scott Marlowe'" <smarlowe(at)g2switchworks(dot)com>, "'Vivek Khera'" <vivek(at)khera(dot)org> |
| Cc: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: getting count for a specific querry |
| Date: | 2005-04-08 21:09:21 |
| Message-ID: | 008001c53c7f$3c35a930$797ba8c0@jfradkin |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PFC | 2005-04-08 21:37:55 | Re: getting count for a specific querry |
| Previous Message | Scott Marlowe | 2005-04-08 20:50:54 | Re: getting count for a specific querry |