Skip site navigation (1) Skip section navigation (2)

Re: Optimize

From: Torsten Schulz <comic(at)be-a-part(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Optimize
Date: 2003-11-25 22:07:18
Message-ID: 3FC3D296.9040404@be-a-part.de (view raw or flat)
Thread:
Lists: pgsql-performance
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(at)be-a-part(dot)de>
To: 	Chester Kustarz <chester(at)arbor(dot)net>
References: 	<Pine(dot)BSO(dot)4(dot)44(dot)0311241718030(dot)19584-100000(at)detroit(dot)arbor(dot)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!




Responses

  • Re: Optimize at 2003-11-26 06:06:34 from Shridhar Daithankar

pgsql-performance by date

Next:From: Josh BerkusDate: 2003-11-25 22:19:36
Subject: Wierd context-switching issue on Xeon
Previous:From: Torsten SchulzDate: 2003-11-25 22:06:10
Subject: Re: [Fwd: Re: Optimize]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group