Re: Optimize

Поиск
Список
Период
Сортировка
От Torsten Schulz
Тема Re: Optimize
Дата
Msg-id 3FC3D296.9040404@be-a-part.de
обсуждение исходный текст
Ответ на Optimize  (Torsten Schulz <comic@be-a-part.de>)
Ответы Re: Optimize
Список 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@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!




В списке pgsql-performance по дате отправления:

Предыдущее
От: Torsten Schulz
Дата:
Сообщение: Re: [Fwd: Re: Optimize]
Следующее
От: "Russell Garrett"
Дата:
Сообщение: Re: [Fwd: Re: Optimize]