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
//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
..@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
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
>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
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
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
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
> 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
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 "
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
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
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
13 matches
Mail list logo