Re: Linux max on shared buffers?

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

In response to

Responses

Browse pgsql-general by date

  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