Memory settings

Hi team, Can you please suggest what will be the suitable memory settings for Postgresql11 if we have 80gb RAM, 16 CPU's and OS Linux. If we set 25 % of total RAM then shared_buffers value will be 20GB. Will it be useful or we can set it any random vale like 8g or 12gb. According to

Memory settings

Can you please suggest what will be the suitable memory settings for Postgresql11 if we have 80gb RAM, 16 CPU's and OS Linux. If we set 25 % of total RAM then shared_buffers value will be 20GB. Will it be useful or we can set it any random vale like 8g or 12gb. According to

Re: Azure Database for PostgreSQL - how to add pgbouncer or similar?

On 6/29/19 8:33 AM, Alexander Farber wrote: Thank you Adrian - On Sat, Jun 29, 2019 at 3:59 PM Adrian Klaver > wrote: On 6/29/19 12:34 AM, Alexander Farber wrote: Not from within. Supported extensions:

Re: How to get non-existant values as NULL or 0?

On 6/29/19 9:20 AM, Pól Ua Laoínecháin wrote: I'm in a bit of a quandary. I'm trying to figure out how to have non-existent values appear as NULL (or using COALESCE, as 0). I have several tables (DDL and DML shown at the bottom of this post - and there is a fiddle available here:

Re: How to get non-existant values as NULL or 0?

Le sam. 29 juin 2019 à 17:20, Pól Ua Laoínecháin a écrit : > I'm in a bit of a quandary. I'm trying to figure out how to have > non-existent values appear as NULL (or using COALESCE, as 0). Please ignore this question here - I have reposted it to pg-novice where I think it better belongs. TIA

How to get non-existant values as NULL or 0?

I'm in a bit of a quandary. I'm trying to figure out how to have non-existent values appear as NULL (or using COALESCE, as 0). I have several tables (DDL and DML shown at the bottom of this post - and there is a fiddle available here:

Re: Azure Database for PostgreSQL - how to add pgbouncer or similar?

Thank you Adrian - On Sat, Jun 29, 2019 at 3:59 PM Adrian Klaver wrote: > On 6/29/19 12:34 AM, Alexander Farber wrote: > > Not from within. Supported extensions: > > https://docs.microsoft.com/en-us/azure/postgresql/concepts-extensions > > Using search term 'azure postgresql connection pooler',

Re: Azure Database for PostgreSQL - how to add pgbouncer or similar?

On 6/29/19 12:34 AM, Alexander Farber wrote: Good morning, in Microsoft Azure how to add pgbouncer or a similar software enabling multiple simultaneous connections? Not from within. Supported extensions: https://docs.microsoft.com/en-us/azure/postgresql/concepts-extensions Using search

Re: Automatic Failover in PostgreSQL using PAF/repmgr

On Sat, 29 Jun 2019 00:34:13 +0530 Devendra Y wrote: > Dear Experts, > > I have configured Wal replication (standby) in PostgreSQL as Master and > slave. And I have also configured Logical replication (standby) in > PostgreSQL as Master and slave for different application's. > > Now I am

Automatic Failover in PostgreSQL using PAF/repmgr

Dear Experts, I have configured Wal replication (standby) in PostgreSQL as Master and slave. And I have also configured Logical replication (standby) in PostgreSQL as Master and slave for different application's. Now I am trying to integrate the Failover part to Automatic Failover using PAF

Azure Database for PostgreSQL - how to add pgbouncer or similar?

Good morning, in Microsoft Azure how to add pgbouncer or a similar software enabling multiple simultaneous connections? After reading https://docs.microsoft.com/en-us/azure/postgresql/overview I could not find such options... Thank you Alex