You may also need to tune shmmax and shmmin kernel parameters.
Regards,
Ganesh Korde.
On Fri, 20 May 2022, 1:58 pm aditya desai, wrote:
> Hi,
> One of our applications needs 3000 max_connections to the database.
> Connection pooler like pgbouncer or pgpool is not certified w
Thanks! I will run these suggestions with App team.
On Fri, May 20, 2022 at 4:01 PM Laurenz Albe
wrote:
> On Fri, 2022-05-20 at 12:15 +0200, Andreas Kretschmer wrote:
> > On 20 May 2022 10:27:50 CEST, aditya desai wrote:
> > > One of our applications needs 3000 max_connectio
On Fri, 2022-05-20 at 12:15 +0200, Andreas Kretschmer wrote:
> On 20 May 2022 10:27:50 CEST, aditya desai wrote:
> > One of our applications needs 3000 max_connections to the database.
> > Connection pooler like pgbouncer or pgpool is not certified within the
> > organiza
On 20 May 2022 10:27:50 CEST, aditya desai wrote:
>Hi,
>One of our applications needs 3000 max_connections to the database.
>Connection pooler like pgbouncer or pgpool is not certified within the
>organization yet. So they are looking for setting up high configuration
>Hardwa
Hi,
One of our applications needs 3000 max_connections to the database.
Connection pooler like pgbouncer or pgpool is not certified within the
organization yet. So they are looking for setting up high configuration
Hardware with CPU and Memory. Can someone advise how much memory and CPU
they will
Hi
út 22. 10. 2019 v 14:28 odesílatel Joao Junior napsal:
> Hi,
> I am not sure if here is the best place to post this.
> I would like to know why max_connections parameter can't be changed
> without a restart. I know that it is a postmaster's context parameter.
Hi,
I am not sure if here is the best place to post this.
I would like to know why max_connections parameter can't be changed
without a restart. I know that it is a postmaster's context parameter.
Which PostgreSQL's subsystems, structures and OS kernel parameters should
be affe
On Tue, Sep 17, 2019 at 4:41 AM Bob Jolliffe wrote:
> Hi
>
> We are trying to diagnose why postgres might be making poor decisions
> regarding query plans. One theory is that it does not assume it has
> the memory suggested in effective_cache_size.
> We do know that max_
Thanks Tom. Will check that.
On Tue, 17 Sep 2019 at 14:13, Tom Lane wrote:
>
> Bob Jolliffe writes:
> > We do know that max_connections is set quite high (600) when we don't
> > really expect more than 100. I wonder does the planner take
> > max_connections
Bob Jolliffe writes:
> We do know that max_connections is set quite high (600) when we don't
> really expect more than 100. I wonder does the planner take
> max_connections x work_mem into account when considering the memory it
> has potentially available?
No. There have be
Hi
We are trying to diagnose why postgres might be making poor decisions
regarding query plans. One theory is that it does not assume it has
the memory suggested in effective_cache_size.
We do know that max_connections is set quite high (600) when we don't
really expect more than 100. I w
From: Daulat Ram [mailto:daulat@exponential.com]
Sent: Wednesday, June 26, 2019 3:14 AM
To: pgsql-performance@lists.postgresql.org
Subject: Max_connections limit
Hello team,
We have migrated our database from Oracle 12c to Postgres 11. I need your
suggestions , we have sessions limit in
On Wed, Jun 26, 2019 at 5:16 AM Hervé Schweitzer (HER) <
herve.schweit...@dbi-services.com> wrote:
> You now that Postgres don’t have any shared_pool as Oracle, and the
> session information ( execution plan, etc..) are only available for the
> current session. Therefore I also highly recommend to
it in Oracle = 3024 . Do we need to set the same
>> connection limit
>> in Postgres as well. How we can decide the max_connections limit for
>> postgres.
>> Are there any differences in managing connections in Oracle and postgres.
>
> I'd say that is way too h
Daulat Ram wrote:
> We have migrated our database from Oracle 12c to Postgres 11. I need your
> suggestions ,
> we have sessions limit in Oracle = 3024 . Do we need to set the same
> connection limit
> in Postgres as well. How we can decide the max_connections limit for postgr
Hello team,
We have migrated our database from Oracle 12c to Postgres 11. I need your
suggestions , we have sessions limit in Oracle = 3024 . Do we need to set the
same connection limit in Postgres as well. How we can decide the
max_connections limit for postgres. Are there any differences in
16 matches
Mail list logo
