Thread

1. Re: Optimize

   Torsten Schulz <comic@be-a-part.de> — 2003-11-25T22:07:18Z

   Chester Kustarz wrote:
   
   > On Mon, 24 Nov 2003, Torsten Schulz wrote:
   >  
   >
   >> shared_buffers = 5000        # 2*max_connections, min 16
   >>   
   >
   >
   > that looks pretty small. that would only be 40MBytes (8k/page * 
   > 5000pages).
   >
   > http://www.varlena.com/GeneralBits/Tidbits/perf.html
   >
   >  
   >
   Ok, thats it. I've set it to 51200, now it seems to be very fast.
   
   Thank you!
   
   
   -------- Original Message --------
   Subject: 	Re: [PERFORM] Optimize
   Date: 	Tue, 25 Nov 2003 23:04:06 +0100
   From: 	Torsten Schulz <comic@be-a-part.de>
   To: 	Chester Kustarz <chester@arbor.net>
   References: 	<Pine.BSO.4.44.0311241718030.19584-100000@detroit.arbor.net>
   
   
   
   Chester Kustarz wrote:
   
   >On Mon, 24 Nov 2003, Torsten Schulz wrote:
   >  
   >
   >>shared_buffers = 5000        # 2*max_connections, min 16
   >>    
   >>
   >
   >that looks pretty small. that would only be 40MBytes (8k/page * 5000pages).
   >
   >http://www.varlena.com/GeneralBits/Tidbits/perf.html
   >
   >  
   >
   Ok, thats it. I've set it to 51200, now it seems to be very fast.
   
   Thank you!
   
   
   
   
   

2. Re: Optimize

   Shridhar Daithankar <shridhar_daithankar@persistent.co.in> — 2003-11-26T06:06:34Z

   Torsten Schulz wrote:
   
   > Chester Kustarz wrote:
   
   >> On Mon, 24 Nov 2003, Torsten Schulz wrote:
   >>> shared_buffers = 5000        # 2*max_connections, min 16
   >> that looks pretty small. that would only be 40MBytes (8k/page * 
   >> 5000pages).
   >> http://www.varlena.com/GeneralBits/Tidbits/perf.html
   > Ok, thats it. I've set it to 51200, now it seems to be very fast.
   
   Whoa..That is too much. You acn get still better performance at something low 
   like 10,000 or even 5000.
   
   Bumping up shared buffers stops being useful after a point and later it actually 
   degrades the performance..
   
     Shridhar