From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Chris Webster <cjw(at)ucar(dot)edu> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: postmaster(s) have high load average |
Date: | 2003-08-08 05:03:58 |
Message-ID: | 20030808050358.GA25873@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Have you run VACUUM and/or VACUUM FULL and/or ANALYZE recently?
On Thu, Aug 07, 2003 at 05:44:05PM -0600, Chris Webster wrote:
> I have one process which writes a single float into 300 columns once per
> second. I then run 4 process, from remote computers, to query a small
> subset of the latest row.
>
> I have even commented out everything in the query programs, all they do
> is sleep, and the associated postmaster still sucks up 15% - 20% CPU.
>
> Computer is a P4 /w 1Gig memory, all disk access is local. RH9 /w stock
> postgresql-7.3 installed.
>
> I have searched the documentation and tech site high and low for ideas....
>
>
> 17:36:27 up 31 days, 6:07, 13 users, load average: 4.11, 2.48, 1.62
> 107 processes: 99 sleeping, 8 running, 0 zombie, 0 stopped
> CPU states: 22.3% user 76.0% system 0.0% nice 0.0% iowait 1.5% idle
> Mem: 1030408k av, 976792k used, 53616k free, 0k shrd, 178704k
> buff
> 715252k actv, 33360k in_d, 22348k in_c
> Swap: 2048248k av, 91308k used, 1956940k free 589572k
> cached
>
>
> PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
> 23389 cjw 16 0 2896 2752 2132 R 18.2 0.2 0:44 0 postmaster
> 23388 cjw 16 0 2896 2752 2132 S 18.0 0.2 0:45 0 postmaster
> 23391 cjw 16 0 2896 2752 2132 S 18.0 0.2 0:43 0 postmaster
> 23366 cjw 16 0 3788 3644 2560 S 17.8 0.3 2:32 0 postmaster
> 23392 cjw 16 0 2896 2752 2132 R 16.2 0.2 0:05 0 postmaster
>
>
> --
> --Chris
>
> How is it one careless match can start a forest fire, but it takes a
> whole box to start a campfire?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> "All that is needed for the forces of evil to triumph is for enough good
> men to do nothing." - Edmond Burke
> "The penalty good people pay for not being interested in politics is to be
> governed by people worse than themselves." - Plato
From | Date | Subject | |
---|---|---|---|
Next Message | Bjorn T Johansen | 2003-08-08 05:07:42 | XML? |
Previous Message | Neil Zanella | 2003-08-08 04:28:52 | PostgreSQL and ACID properties support |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2003-08-08 05:20:11 | Re: Problem building contrib/array in current CVS |
Previous Message | Bruce Momjian | 2003-08-08 04:53:45 | Moved simple_prompt()/sprompt.c |