Mailing lists [pgsql-performance]

3 March 2020

• 01:31   Re: Many DataFileRead - IO waits Ben Snaidero
• 01:39   Re: Many DataFileRead - IO waits Ben Snaidero
• 02:09   Re: Many DataFileRead - IO waits legrand legrand

8 March 2020

• 19:05   pg12 partitions show bad performance vs pg96 Mariel Cherkassky
• 19:14   Re: pg12 partitions show bad performance vs pg96 Mariel Cherkassky

9 March 2020

• 05:47   Re: pg12 partitions show bad performance vs pg96 David Rowley
• 06:10   Re: pg12 partitions show bad performance vs pg96 Justin Pryzby
• 13:15   Re: pg12 partitions show bad performance vs pg96 Mariel Cherkassky
• 13:31   Re: pg12 partitions show bad performance vs pg96 Mariel Cherkassky
• 15:12   Re: pg12 partitions show bad performance vs pg96 Justin Pryzby
• 16:08   Re: pg12 partitions show bad performance vs pg96 Mariel Cherkassky
• 16:16   Re: pg12 partitions show bad performance vs pg96 Mariel Cherkassky

10 March 2020

• 00:43   Re: pg12 partitions show bad performance vs pg96 David Rowley

11 March 2020

• 22:31   Slow ext'd query via client native implementation vs. libpq & simple psql Richard Michael

12 March 2020

• 00:59   Re: Slow ext'd query via client native implementation vs. libpq &simple psql Justin Pryzby
• 01:54   Re: Slow ext'd query via client native implementation vs. libpq & simple psql Tom Lane
• 23:43   Re: Slow ext'd query via client native implementation vs. libpq &simple psql Justin Pryzby

21 March 2020

• 15:02   Slow planning time when public schema included (12 vs. 9.4) Anders Steinlein
• 16:37   Re: Slow planning time when public schema included (12 vs. 9.4) Andreas Kretschmer
• 17:26   Re: Slow planning time when public schema included (12 vs. 9.4) Tom Lane
• 18:45   Re: Slow planning time when public schema included (12 vs. 9.4) Anders Steinlein
• 18:59   Re: Slow planning time when public schema included (12 vs. 9.4) Anders Steinlein
• 22:35   Re: Slow planning time when public schema included (12 vs. 9.4) Tom Lane

22 March 2020

• 00:13   Re: Slow planning time when public schema included (12 vs. 9.4) Anders Steinlein
• 01:55   Re: Slow planning time when public schema included (12 vs. 9.4) Tom Lane
• 20:22   JOIN on partitions is very slow daya airody
• 21:08   Re: JOIN on partitions is very slow Michael Lewis

23 March 2020

• 04:22   Partitions to improve write/update speed for tables with indexes? Arya F
• 04:29   Re: Partitions to improve write/update speed for tables with indexes? Justin Pryzby
• 06:45   Partition Pruning (Hash Partitions) Support for DELETEs in PostgreSQL11 and 12 Ronnie S
• 07:10   Re: Partition Pruning (Hash Partitions) Support for DELETEs inPostgreSQL 11 and 12 Justin Pryzby
• 10:40   Re: JOIN on partitions is very slow daya airody
• 17:18   Re: Partition Pruning (Hash Partitions) Support for DELETEs inPostgreSQL 11 and 12 Ronnie S
• 19:16   Re: JOIN on partitions is very slow Michael Lewis
• 19:33   Re: JOIN on partitions is very slow Thomas Kellerer

24 March 2020

• 21:10   Random function Luis Roberto Weck
• 21:33   Re: Random function Tom Lane
• 21:33   Re: Random function David G. Johnston

25 March 2020

• 01:55   Re: Slow planning time when public schema included (12 vs. 9.4) Anders Steinlein

27 March 2020

• 17:13   Best way to delete big amount of records from big table Ekaterina Amez
• 17:41   Re: Best way to delete big amount of records from big table Michael Lewis
• 17:46   Re: Best way to delete big amount of records from big table Laurenz Albe
• 17:55   Re: Best way to delete big amount of records from big table Ekaterina Amez
• 17:56   Re: Best way to delete big amount of records from big table Ekaterina Amez
• 18:03   Re: Best way to delete big amount of records from big table Rick Otten
• 18:09   Re: Best way to delete big amount of records from big table Justin Pryzby
• 18:15   Re: Best way to delete big amount of records from big table Ekaterina Amez
• 18:24   Re: JOIN on partitions is very slow daya airody

28 March 2020

• 07:32   Re: Best way to delete big amount of records from big table Laurenz Albe

30 March 2020

• 09:47   Increasing work_mem slows down query, why? Silvio Moioli
• 09:56   Re: Increasing work_mem slows down query, why? Pavel Stehule
• 11:12   Re: Increasing work_mem slows down query, why? Silvio Moioli
• 13:12   Re: Increasing work_mem slows down query, why? Pavel Stehule
• 16:09   Re: Increasing work_mem slows down query, why? Silvio Moioli
• 16:33   Re: Increasing work_mem slows down query, why? Pavel Stehule
• 16:40   Re: Increasing work_mem slows down query, why? Pavel Stehule
• 19:02   Re: Increasing work_mem slows down query, why? Tom Lane
• 19:18   Re: Increasing work_mem slows down query, why? Pavel Stehule
• 19:36   Re: Increasing work_mem slows down query, why? Tom Lane
• 19:49   Re: Increasing work_mem slows down query, why? Pavel Stehule