Mailing lists [pgsql-performance]

1 June 2021

• 07:16   Re: AWS forcing PG upgrade from v9.6 a disaster Justin Pryzby
• 20:44   Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)

4 June 2021

• 11:06   slow query with inline function on AWS RDS with RDS 24x large Ayub Khan
• 11:22   Re: slow query with inline function on AWS RDS with RDS 24x large Pavel Stehule
• 11:32   Re: slow query with inline function on AWS RDS with RDS 24x large Ayub Khan
• 11:40   Re: slow query with inline function on AWS RDS with RDS 24x large Pavel Stehule
• 11:51   Re: slow query with inline function on AWS RDS with RDS 24x large Ayub Khan
• 14:53   PgSQL 12 on WinSrv ~3x faster than on Linux Taras Savchuk
• 15:42   Re: PgSQL 12 on WinSrv ~3x faster than on Linux David Rowley
• 16:14   Re: PgSQL 12 on WinSrv ~3x faster than on Linux Vijaykumar Jain
• 16:40   Re: PgSQL 12 on WinSrv ~3x faster than on Linux Tom Lane
• 17:01   RE: PgSQL 12 on WinSrv ~3x faster than on Linux Taras Savchuk

5 June 2021

• 19:42   query planner not using index, instead using squential scan Ayub Khan
• 22:29   Re: query planner not using index, instead using squential scan Tom Lane
• 22:52   Re: query planner not using index, instead using squential scan Vijaykumar Jain

6 June 2021

• 00:14   Re: query planner not using index, instead using squential scan Ayub Khan
• 00:18   Re: query planner not using index, instead using squential scan Vijaykumar Jain

7 June 2021

• 02:49   Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 07:51   dexter on AWS RDS auto tune queries Ayub Khan
• 07:57   Re: dexter on AWS RDS auto tune queries Julien Rouhaud
• 08:00   Re: dexter on AWS RDS auto tune queries Christophe Pettus
• 10:49   Re: dexter on AWS RDS auto tune queries Ayub Khan
• 10:57   Re: dexter on AWS RDS auto tune queries Julien Rouhaud
• 13:05   Re: dexter on AWS RDS auto tune queries Ayub Khan
• 14:52   Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan
• 20:27   Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)

8 June 2021

• 19:03   slow query Ayub Khan
• 19:08   Re: slow query Christophe Pettus
• 19:32   Re: slow query Ayub Khan
• 20:14   Re: slow query Tom Lane
• 20:43   Re: slow query Ayub Khan

9 June 2021

• 17:47   waiting for client write Ayub Khan
• 17:49   Re: waiting for client write Magnus Hagander
• 21:59   Re: waiting for client write Ayub Khan
• 22:57   Re: slow query Jeff Janes
• 23:23   Re: slow query Ayub Khan

10 June 2021

• 03:45   Page File Size Reached Critical Threshold PostgreSQL V13  Haseeb Khan
• 04:50   Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 07:28   Re: Page File Size Reached Critical Threshold PostgreSQL V13 Justin Pryzby
• 09:41   Re: Page File Size Reached Critical Threshold PostgreSQL V13 Haseeb Khan
• 11:06   Re: waiting for client write Ayub Khan
• 11:55   Re: Page File Size Reached Critical Threshold PostgreSQL V13 Justin Pryzby
• 13:29   Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan
• 17:33   Re: Page File Size Reached Critical Threshold PostgreSQL V13 Justin Pryzby
• 17:36   Re: AWS forcing PG upgrade from v9.6 a disaster Joshua Drake
• 18:40   Re: waiting for client write Jeff Janes
• 19:07   Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 19:54   Re: AWS forcing PG upgrade from v9.6 a disaster Ranier Vilela
• 19:58   Re: waiting for client write Vijaykumar Jain
• 20:43   Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 21:00   Re: AWS forcing PG upgrade from v9.6 a disaster Tom Lane
• 21:23   Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan
• 22:29   Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)

11 June 2021

• 00:46   Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 19:28   Re: waiting for client write Ayub Khan
• 19:46   Re: waiting for client write Pavan Pusuluri
• 19:52   Re: waiting for client write Ranier Vilela
• 19:59   Re: waiting for client write Ayub Khan
• 20:37   Re: waiting for client write Ranier Vilela
• 20:59   Re: waiting for client write Ayub Khan
• 21:03   Re: waiting for client write Ranier Vilela
• 21:19   Re: waiting for client write Ayub Khan
• 21:25   Re: waiting for client write Ranier Vilela
• 22:45   Re: waiting for client write Ayub Khan

12 June 2021

• 00:58   Re: waiting for client write Jeff Janes
• 01:06   Re: waiting for client write Ayub Khan
• 11:19   Re: waiting for client write Ayub Khan
• 15:03   Re: waiting for client write Ranier Vilela
• 15:04   Re: waiting for client write Vijaykumar Jain
• 15:34   Re: waiting for client write Ayub Khan

13 June 2021

• 17:00   Re: waiting for client write Ayub Khan
• 19:30   Re: waiting for client write Vijaykumar Jain
• 20:00   Re: waiting for client write Ayub Khan

14 June 2021

• 08:02   Re: waiting for client write Ayub Khan
• 13:16   overcommit_ratio setting Yi Sun
• 16:21   pg_dumpall --exclude-database case folding, was Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan
• 16:32   Re: pg_dumpall --exclude-database case folding, was Re: AWS forcing PG upgrade from v9.6 a disaster Tom Lane
• 17:14   Re: overcommit_ratio setting Julien Rouhaud
• 19:18   Re: overcommit_ratio setting Laurenz Albe
• 20:25   Re: Planning performance problem (67626.278ms) Manuel Weitzman
• 22:36   Master - Slave Replication Window Server Haseeb Khan
• 22:41   Re: Master - Slave Replication Window Server Rory Campbell-Lange

15 June 2021

• 03:34   Re: overcommit_ratio setting Yi Sun
• 08:42   Re: Master - Slave Replication Window Server Haseeb Khan
• 09:17   Re: Master - Slave Replication Window Server Haseeb Khan
• 10:07   Re: overcommit_ratio setting Laurenz Albe
• 10:45   Re: overcommit_ratio setting Yi Sun
• 15:05   Re: Master - Slave Replication Window Server Rory Campbell-Lange
• 15:29   Re: Master - Slave Replication Window Server Haseeb Khan
• 18:43   Re: waiting for client write Ayub Khan
• 19:14   Re: Master - Slave Replication Window Server Atul Kumar
• 20:22   Re: waiting for client write Vijaykumar Jain

16 June 2021

• 19:25   PostgreSQL V13 Replication Issue Haseeb Khan
• 19:30   Re: PostgreSQL V13 Replication Issue Dean Gibson (DB Administrator)

17 June 2021

• 03:36   Estimating wal_keep_size Dean Gibson (DB Administrator)
• 04:02   Re: Estimating wal_keep_size Julien Rouhaud
• 04:02   Re: PostgreSQL V13 Replication Issue Michael Paquier

18 June 2021

• 21:13   Re: Estimating wal_keep_size Dean Gibson (DB Administrator)
• 21:27   Re: Estimating wal_keep_size Julien Rouhaud
• 21:40   Re: Estimating wal_keep_size Vijaykumar Jain

20 June 2021

• 03:09   Re: Planning performance problem (67626.278ms) Manuel Weitzman

21 June 2021

• 00:06   Re: Planning performance problem (67626.278ms) Tom Lane
• 02:23   Re: Planning performance problem (67626.278ms) Ranier Vilela
• 02:53   Re: Estimating wal_keep_size Dean Gibson (DB Administrator)
• 03:17   Re: Planning performance problem (67626.278ms) Tom Lane

25 June 2021

• 06:10   Partition column should be part of PK Nagaraj Raj
• 07:22   Re: Partition column should be part of PK Justin Pryzby
• 19:09   slow performance with cursor Ayub Khan
• 19:21   Re: slow performance with cursor Justin Pryzby
• 19:37   Re: slow performance with cursor Ayub Khan
• 21:04   Re: slow performance with cursor Tom Lane

29 June 2021

• 22:26   Re: Planning performance problem (67626.278ms) Manuel Weitzman
• 22:43   Re: Planning performance problem (67626.278ms) Tom Lane

30 June 2021

• 00:35   Re: Planning performance problem (67626.278ms) Manuel Weitzman
• 01:31   Re: Planning performance problem (67626.278ms) Tom Lane
• 23:56   Re: Planning performance problem (67626.278ms) Manuel Weitzman