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 <pie...@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.