Re: Multiple databases and shared_buffers

Поиск
Список
Период
Сортировка
От Melvin Davidson
Тема Re: Multiple databases and shared_buffers
Дата
Msg-id CANu8Fiww9QgBs7+varr36+FUJtZCqJ4hePY3SdPnHmmAquzqiA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Multiple databases and shared_buffers  (John R Pierce <pierce@hogranch.com>)
Ответы Re: Multiple databases and shared_buffers  (Rakesh Kumar <dcruncher4@aim.com>)
Список pgsql-general
I think this begs the question "Why do you think you need to separate the shared_buffers"?
What version of PostgreSQL are you using?
What is your O/S?
How many CPU's on your server?
How much memory?

On Wed, Feb 17, 2016 at 5:21 PM, John R Pierce <pierce@hogranch.com> wrote:
On 2/17/2016 6:54 AM, Data Cruncher wrote:
We will be creating multiple databases in a cluster (instance). Is there any way to separate shared_buffers for each database? Looks like not since PG does not allow user created shared buffers.



you would need to run multiple instances if you feel you need that level of control over shared_buffers.


-- 
john r pierce, recycling bits in santa cruz



--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Multiple databases and shared_buffers
Следующее
От: Tom Smith
Дата:
Сообщение: BRIN Usage