Mailing lists [pgsql-performance]

1 June 2020

• 15:09   Configuration sugnathi hai
• 16:24   Re: Configuration Filip Rembiałkowski

2 June 2020

• 20:33   Re: When to use PARTITION BY HASH? Justin Pryzby

3 June 2020

• 10:45   Re: When to use PARTITION BY HASH? Oleksandr Shulgin
• 18:09   Re: When to use PARTITION BY HASH? Justin Pryzby
• 23:04   increased max_parallel_workers_per_gather results in fewer workers? Philip Semanchuk

4 June 2020

• 00:15   Re: increased max_parallel_workers_per_gather results in fewerworkers? Justin Pryzby
• 01:23   Re: increased max_parallel_workers_per_gather results in fewerworkers? Philip Semanchuk
• 01:36   Re: increased max_parallel_workers_per_gather results in fewerworkers? Justin Pryzby
• 09:28   Re: increased max_parallel_workers_per_gather results in fewerworkers? Sebastian Dressler
• 09:41   Re: increased max_parallel_workers_per_gather results in fewerworkers? Luis Carril
• 11:56   Re: increased max_parallel_workers_per_gather results in fewerworkers? Tomas Vondra
• 12:30   Re: increased max_parallel_workers_per_gather results in fewer workers? Magnus Hagander
• 19:41   Re: increased max_parallel_workers_per_gather results in fewerworkers? Philip Semanchuk
• 20:45   Re: increased max_parallel_workers_per_gather results in fewerworkers? Sebastian Dressler
• 21:37   Re: increased max_parallel_workers_per_gather results in fewerworkers? Philip Semanchuk
• 22:03   Re: increased max_parallel_workers_per_gather results in fewer workers? Sebastian Dressler

5 June 2020

• 00:29   Re: increased max_parallel_workers_per_gather results in fewerworkers? Philip Semanchuk
• 13:07   Postgresql server gets stuck at low load Krzysztof Olszewski
• 14:16   Re: Postgresql server gets stuck at low load luis.roberto@siscobra.com.br
• 14:37   Re: Postgresql server gets stuck at low load Pavel Stehule
• 14:48   Re: When to use PARTITION BY HASH? Imre Samu

6 June 2020

• 05:12   Re: Date vs Timestamp without timezone Partition Key Cedric Leong
• 05:16   Re: Date vs Timestamp without timezone Partition Key David Rowley
• 05:49   Re: Date vs Timestamp without timezone Partition Key Cedric Leong
• 06:13   Re: Date vs Timestamp without timezone Partition Key David Rowley
• 06:56   Re: Date vs Timestamp without timezone Partition Key Cedric Leong

7 June 2020

• 14:41   Re: When to use PARTITION BY HASH? MichaelDBA

8 June 2020

• 00:23   Re: When to use PARTITION BY HASH? David Rowley
• 12:50   Re: When to use PARTITION BY HASH? Michaeldba@sqlexec.com

9 June 2020

• 14:52   Re: Postgresql server gets stuck at low load Krzysztof Olszewski
• 14:54   Re: Postgresql server gets stuck at low load Krzysztof Olszewski
• 15:01   Re: Postgresql server gets stuck at low load Avinash Kumar
• 15:05   Re: Postgresql server gets stuck at low load Krzysztof Olszewski
• 15:09   Re: Postgresql server gets stuck at low load Justin Pryzby

10 June 2020

• 22:28   Windows slowness? Mikkel Lauritsen
• 23:35   Re: Windows slowness? mountain the blue

11 June 2020

• 00:08   Re: Windows slowness? David Rowley
• 08:05   Re: Windows slowness? Mikkel Lauritsen

12 June 2020

• 18:21   view reading information_schema is slow in PostgreSQL 12 regrog
• 22:00   Re: view reading information_schema is slow in PostgreSQL 12 Imre Samu

13 June 2020

• 06:11   Re: view reading information_schema is slow in PostgreSQL 12 Tom Lane
• 06:15   Re: view reading information_schema is slow in PostgreSQL 12 David Rowley
• 06:55   Re: view reading information_schema is slow in PostgreSQL 12 David Rowley
• 07:07   Re: view reading information_schema is slow in PostgreSQL 12 Tom Lane
• 07:34   Re: view reading information_schema is slow in PostgreSQL 12 Justin Pryzby
• 08:13   Re: view reading information_schema is slow in PostgreSQL 12 Pavel Stehule
• 08:15   Re: view reading information_schema is slow in PostgreSQL 12 Pavel Stehule
• 08:23   Re: view reading information_schema is slow in PostgreSQL 12 Pavel Stehule
• 10:52   Re: view reading information_schema is slow in PostgreSQL 12 David Rowley
• 11:22   Re: view reading information_schema is slow in PostgreSQL 12 David Rowley
• 20:06   Re: view reading information_schema is slow in PostgreSQL 12 Tom Lane

15 June 2020

• 01:45   Performance issue Nagaraj Raj
• 02:55   Re: Performance issue David Rowley
• 03:05   Re: Performance issue Justin Pryzby
• 21:21   Re: view reading information_schema is slow in PostgreSQL 12 Michael Lewis

16 June 2020

• 12:23   Re: view reading information_schema is slow in PostgreSQL 12 regrog
• 23:35   simple query running for ever Nagaraj Raj
• 23:43   Re: simple query running for ever Michael Lewis
• 23:46   Re: simple query running for ever Justin Pryzby
• 23:57   Re: simple query running for ever Nagaraj Raj

17 June 2020

• 00:13   Re: simple query running for ever Nagaraj Raj
• 00:15   Re: simple query running for ever Nagaraj Raj
• 01:05   Re: simple query running for ever Justin Pryzby
• 01:10   Re: simple query running for ever Andreas Joseph Krogh
• 01:33   Re: simple query running for ever Justin Pryzby
• 12:23   Re: simple query running for ever Laurenz Albe

19 June 2020

• 18:12   Unclamped row estimates whith OR-ed subplans Benjamin Coutu
• 18:55   Re: Unclamped row estimates whith OR-ed subplans Laurenz Albe
• 19:04   Re: Unclamped row estimates whith OR-ed subplans Tom Lane
• 19:14   Re: Unclamped row estimates whith OR-ed subplans David G. Johnston
• 20:33   Re: Unclamped row estimates whith OR-ed subplans Benjamin Coutu
• 21:16   Re: Unclamped row estimates whith OR-ed subplans Tom Lane
• 21:37   Re: Unclamped row estimates whith OR-ed subplans Michael Lewis
• 22:49   PostgreSQL 12.3 slow index scan chosen Kenneth Marshall
• 23:11   Re: PostgreSQL 12.3 slow index scan chosen Tom Lane
• 23:33   Re: Unclamped row estimates whith OR-ed subplans Benjamin Coutu
• 23:49   Re: PostgreSQL 12.3 slow index scan chosen Kenneth Marshall
• 23:59   Re: PostgreSQL 12.3 slow index scan chosen Tom Lane

20 June 2020

• 00:23   Re: PostgreSQL 12.3 slow index scan chosen Kenneth Marshall
• 01:10   Re: PostgreSQL 12.3 slow index scan chosen Tom Lane
• 01:25   Re: PostgreSQL 12.3 slow index scan chosen Kenneth Marshall
• 01:30   Re: PostgreSQL 12.3 slow index scan chosen Tom Lane
• 01:37   Re: PostgreSQL 12.3 slow index scan chosen Kenneth Marshall
• 02:07   Re: PostgreSQL 12.3 slow index scan chosen Tom Lane
• 21:22   Re: PostgreSQL 12.3 slow index scan chosen Tom Lane
• 22:55   Re: PostgreSQL 12.3 slow index scan chosen Kenneth Marshall

22 June 2020

• 22:27   Re: PostgreSQL 12.3 slow index scan chosen Alvaro Herrera
• 22:29   Re: PostgreSQL 12.3 slow index scan chosen Kenneth Marshall
• 22:39   Re: PostgreSQL 12.3 slow index scan chosen Tom Lane

29 June 2020

• 12:26   Recommended value for pg_test_fsync Nikhil Shetty

30 June 2020

• 08:02   Re: Recommended value for pg_test_fsync Nikhil Shetty
• 18:24   Re: Recommended value for pg_test_fsync Bruce Momjian
• 19:10   Is there a known bug with SKIP LOCKED and "tuple to be locked was already moved to another partition due to concurrent update"? Gunther Schadow
• 19:21   Re: Recommended value for pg_test_fsync Jeff Janes
• 20:26   Re: Recommended value for pg_test_fsync Jeff Janes