Re: [GENERAL] Multiple databases and shared_buffers

2016-02-19 Thread Karsten Hilbert
On Thu, Feb 18, 2016 at 05:38:45PM -0500, Melvin Davidson wrote: > From your questions, it appears you are a little weak on PostgreSQL > Database Administration. I respectfully suggest you obtain a copy of the > following book to get a clearer understandings of how things work. The PostgreSQL

Re: [GENERAL] Multiple databases and shared_buffers

2016-02-18 Thread Adrian Klaver
//www.postgresql.org/docs/9.5/interactive/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL -Original Message- From: Melvin Davidson <melvin6...@gmail.com> To: Rakesh Kumar <dcrunch...@aim.com>; pgsql-general <pgsql-general@postgresql.org> Sent: Thu, Feb 18, 2016 4:12 pm Sub

Re: [GENERAL] Multiple databases and shared_buffers

2016-02-18 Thread Melvin Davidson
..@aim.com>; pgsql-general < > pgsql-general@postgresql.org> > Sent: Thu, Feb 18, 2016 4:12 pm > Subject: Re: [GENERAL] Multiple databases and shared_buffers > > >What do you mean that the data is actually not stored in the shared > buffer. > >From the lin

Re: [GENERAL] Multiple databases and shared_buffers

2016-02-18 Thread Rakesh Kumar
temporarily, it will be great. -Original Message- From: Melvin Davidson <melvin6...@gmail.com> To: Rakesh Kumar <dcrunch...@aim.com>; pgsql-general <pgsql-general@postgresql.org> Sent: Thu, Feb 18, 2016 4:12 pm Subject: Re: [GENERAL] Multiple databases and shared_buffers

Re: [GENERAL] Multiple databases and shared_buffers

2016-02-18 Thread Melvin Davidson
>What do you mean that the data is actually not stored in the shared buffer. >From the link you provided : >"The “shared_buffers” configuration parameter determines how much memory >is dedicated to PostgreSQL to use for caching data." Again, you misunderstand. Cached data (and queries) is for

Re: [GENERAL] Multiple databases and shared_buffers

2016-02-18 Thread John R Pierce
On 2/18/2016 12:04 PM, Rakesh Kumar wrote: NOTE: It is very important you provide the version of PostgreSQL and O/S when addressing this mail list. Since it is a new project, we are going with: PG: 9.5.1 OS: RHEL 6.4 off topic for this list, but RHEL 6.4 was a 'snapshot' 3 years ago, and

Re: [GENERAL] Multiple databases and shared_buffers

2016-02-18 Thread Rakesh Kumar
NOTE: It is very important you provide the version of PostgreSQL and O/S when addressing this mail list. Since it is a new project, we are going with: PG: 9.5.1 OS: RHEL 6.4

Re: [GENERAL] Multiple databases and shared_buffers

2016-02-18 Thread Rakesh Kumar
What do you mean that the data is actually not stored in the shared buffer. >From the link you provided : "The “shared_buffers” configuration parameter determines how much memory is dedicated to PostgreSQL to use for caching data." This seems to be the same like other RDBMS. Typically the

Re: [GENERAL] Multiple databases and shared_buffers

2016-02-18 Thread Melvin Davidson
> Sent: Wed, Feb 17, 2016 9:53 pm > Subject: Re: [GENERAL] Multiple databases and shared_buffers > > 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? > Ho

Re: [GENERAL] Multiple databases and shared_buffers

2016-02-18 Thread Rakesh Kumar
this is a serious limitation at all. -Original Message- From: Melvin Davidson <melvin6...@gmail.com> To: pgsql-general <pgsql-general@postgresql.org> Sent: Wed, Feb 17, 2016 9:53 pm Subject: Re: [GENERAL] Multiple databases and shared_buffers I think this begs the question "

Re: [GENERAL] Multiple databases and shared_buffers

2016-02-17 Thread Melvin Davidson
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 wrote: > On 2/17/2016 6:54

Re: [GENERAL] Multiple databases and shared_buffers

2016-02-17 Thread John R Pierce
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

Re: [GENERAL] Multiple databases and shared_buffers

2016-02-17 Thread Venkata Balaji N
On Thu, Feb 18, 2016 at 1: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. shared_buffers