| From: | "Carlos H(dot) Reimer" <carlos(dot)reimer(at)opendb(dot)com(dot)br> |
|---|---|
| To: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Context switching |
| Date: | 2006-11-01 05:23:17 |
| Message-ID: | PEEPKDFEHHEMKBBFPOOKKEDCDGAA.carlos.reimer@opendb.com.br |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi,
We've migrated one of our servers from pg 7.4 to 8.1 and from times to times
(4 hours) the server start doing a lot of context switching and all
transactions become very slow.
The average context switching for this server as vmstat shows is 1 but when
the problem occurs it goes to 250000.
CPU and memory usage are ok.
What can produce this context switching storms?
It is a box with 12GB RAM and 4 processors running RedHat Enterprise Linux
AS.
Thank you in advance!
Reimer
carlos(dot)reimer(at)opendb(dot)com(dot)br
OpenDB Serviços e Treinamentos PostgreSQL e DB2
Fone: 47 3327-0878 Cel: 47 9602-0151
www.opendb.com.br
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luke Lonergan | 2006-11-01 05:26:04 | Re: Help w/speeding up range queries? |
| Previous Message | Tom Lane | 2006-11-01 04:29:09 | Re: Help w/speeding up range queries? |