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 по дате отправления: