Re: Confusion on shared buffer
От | Robert Haas |
---|---|
Тема | Re: Confusion on shared buffer |
Дата | |
Msg-id | 603c8f070910031802x4de8770l29d271185474360@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Confusion on shared buffer (S Arvind <arvindwill@gmail.com>) |
Ответы |
Re: Confusion on shared buffer
|
Список | pgsql-performance |
On Sat, Oct 3, 2009 at 2:11 AM, S Arvind <arvindwill@gmail.com> wrote: > Thanks Robert, > So for our scenario what is the most important factor to be noted > for performance. Tough to say without benchmarking, but if you have a lot of small databases that easily fit in RAM, and a lot of concurrent connections, I would think you'd want to spend your hardware $ on maximizing the number of cores. But there are many in this forum who have much more experience with these things than me, so take that with a grain of salt... (You might also want to look at consolidating some of those databases - maybe use one database with multiple schemas - that would probably help performance significantly.) ...Robert
В списке pgsql-performance по дате отправления: