From: | Chris Albertson <chrisalbertson90278(at)yahoo(dot)com> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Curt Sampson <cjs(at)cynic(dot)net> |
Cc: | Martin Dillard <martin(at)edusoftinc(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Linux max on shared buffers? |
Date: | 2002-07-11 06:21:17 |
Message-ID: | 20020711062117.59467.qmail@web14706.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
What I have found, on a machine that is doing mostly DBMS servering
if you have a small shared buffer you will see that the CPU is
not fully utilized as it is waiting on I/O a lot of the time.
I keep adding buffer space until the CPU utilization goes to
~100%. Adding more buffer after this does little to speed up
querries. I use the "top" display under either Linux or Solaris.
This is purly imperical and based on observation but it makes
sense that if the point of the buffer is to avoid disk I/O that
after disk I/O is no longer the bottle neck then adding more
buffers does little good. On a typial 1 CPU PC after about 200MB
of buffer the CPU becomes the bottle neck
=====
Chris Albertson
Home: 310-376-1029 chrisalbertson90278(at)yahoo(dot)com
Cell: 310-990-7550
Office: 310-336-5189 Christopher(dot)J(dot)Albertson(at)aero(dot)org
__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Henrik Steffen | 2002-07-11 06:28:05 | Re: Serious Crash last Friday |
Previous Message | Steve Lane | 2002-07-11 06:04:49 | Hardware for PG |