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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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!
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2003-11-25 22:19:36 | Wierd context-switching issue on Xeon |
Previous Message | Torsten Schulz | 2003-11-25 22:06:10 | Re: [Fwd: Re: Optimize] |