pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chris Cheston <ccheston@gmail.com>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: Doug McNaught <doug@mcnaught.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: postgres 7.4 at 100%
Date: Sat, 26 Jun 2004 16:03:19 -0700
Message-ID: <e071108e0406261603650d1b58@mail.gmail.com> (raw)
In-Reply-To: <40DD8425.3080108@commandprompt.com>
References: <e071108e04062423591d2b8aa9@mail.gmail.com>
	<40DBEBDF.3090605@archonet.com>
	<e071108e04062601087c442d5f@mail.gmail.com>
	<87llia78dj.fsf@asmodeus.mcnaught.org>
	<40DD8425.3080108@commandprompt.com>

Hi all,

I upped effective_cache to 16000 KB and I could only up the
shared_buffers to 3000.  Anything more and postgres would not start.

Postmaster is still using lots of CPU.  pg_stat_activity shows only
query is happening at a time so the requests are probably queueing on
this one thread. Is this the right way to go?

Any other suggestions for me to figure out why Postmaster is using so much CPU?

Thanks in advance,
Chris

numnet=# select * from pg_stat_activity;
 datid | datname | procpid | usesysid | usename |                     
                                                                      
                             current_query                            
                                                                      
                      |          query_start
-------+---------+---------+----------+---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------
 17144 | numnet  |   26120 |      103 | numnet  | <IDLE>              
                                                                      
                                                                      
                                                                      
                      | 2004-06-26 18:01:24.02042-04
 17144 | numnet  |   26121 |      103 | numnet  | <IDLE>              
                                                                      
                                                                      
                                                                      
                      | 2004-06-26 18:01:24.026025-04
 17144 | numnet  |   26122 |      103 | numnet  | <IDLE>              
                                                                      
                                                                      
                                                                      
                      | 2004-06-26 18:01:24.030917-04
 17144 | numnet  |   26123 |      103 | numnet  | <IDLE>              
                                                                      
                                                                      
                                                                      
                      | 2004-06-26 18:01:24.036266-04
 17144 | numnet  |   26124 |      103 | numnet  | <IDLE>              
                                                                      
                                                                      
                                                                      
                      | 2004-06-26 18:01:24.041551-04
 17144 | numnet  |   26125 |      103 | numnet  | <IDLE>              
                                                                      
                                                                      
                                                                      
                      | 2004-06-26 18:01:24.046449-04
 17144 | numnet  |   26126 |      103 | numnet  | <IDLE>              
                                                                      
                                                                      
                                                                      
                      | 2004-06-26 18:01:24.051666-04
 17144 | numnet  |   26127 |      103 | numnet  | <IDLE>              
                                                                      
                                                                      
                                                                      
                      | 2004-06-26 18:01:24.057398-04
 17144 | numnet  |   26128 |      103 | numnet  | <IDLE>              
                                                                      
                                                                      
                                                                      
                      | 2004-06-26 18:01:24.06225-04
 17144 | numnet  |   26129 |      103 | numnet  | SELECT id,name,number,
systemid,pin,last,to,from,lastest,start,end,continue,type,status,duration
FROM logs WHERE (((from= 'me') and (to= 'you')) and (serverip=
'23.6.6.33
 17144 | numnet  |   26147 |      103 | numnet  | <IDLE>              
                                                                      
                                                                      
                                                                      
                      | 2004-06-26 18:03:46.175789-04
(11 rows)




----- Original Message -----
From: Joshua D. Drake <jd@commandprompt.com>
Date: Sat, 26 Jun 2004 07:11:49 -0700
Subject: Re: [PERFORM] postgres 7.4 at 100%
To: Doug McNaught <doug@mcnaught.org>
Cc: pgsql-performance@postgresql.org


Hello,

Not to mention upping your effective_cache.


Doug McNaught wrote:

Chris Cheston <ccheston@gmail.com> writes:

  
shared_buffers = 40             # min 16, at least max_connections*2, 8KB each
    This is ridiculously low for any kind of production server.  Try
something like 5000-10000 for a start.

-Doug


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match
  

-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL



view thread (24+ messages)  latest in thread

Message-ID: <e071108e0406261603650d1b58@mail.gmail.com>
Permalink:  ../e071108e0406261603650d1b58@mail.gmail.com/
Also on:    postgresql.org/message-id/e071108e0406261603650d1b58@mail.gmail.com

 · 

reply

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-performance@postgresql.org
  Cc: ccheston@gmail.com, jd@commandprompt.com, doug@mcnaught.org
  Subject: Re: postgres 7.4 at 100%
  In-Reply-To: <e071108e0406261603650d1b58@mail.gmail.com>

* 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