Mailing lists [pgsql-performance]

11 August 2020

• 23:52   Hstore index for full text search Burhan Akbulut

12 August 2020

• 00:55   Re: Hstore index for full text search Michael Lewis
• 01:46   Re: Hstore index for full text search Tom Lane
• 01:57   Re: Hstore index for full text search Michael Lewis
• 01:58   Re: Is there a known bug with SKIP LOCKED and "tuple to be locked was already moved to another partition due to concurrent update"? Jim Jarvie
• 02:30   Re: Hstore index for full text search Tom Lane

15 August 2020

• 00:34   Query takes way longer with LIMIT, and EXPLAIN takes way longer than actual query Ken Tanzer
• 01:04   Re: Query takes way longer with LIMIT, and EXPLAIN takes way longer than actual query Justin Pryzby
• 01:40   Re: Query takes way longer with LIMIT, and EXPLAIN takes way longer than actual query Ken Tanzer
• 03:24   Re: Query takes way longer with LIMIT, and EXPLAIN takes way longer than actual query Jeff Janes
• 03:55   Re: Query takes way longer with LIMIT, and EXPLAIN takes way longer than actual query Justin Pryzby

18 August 2020

• 19:27   Replication lag due to lagging restart_lsn Satyam Shekhar

19 August 2020

• 02:52   CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Jim Jarvie
• 03:08   Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Michael Lewis
• 03:21   Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Jim Jarvie
• 03:38   Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Henrique Montenegro
• 03:39   Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Michael Lewis
• 03:45   Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Michael Lewis
• 09:04   Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Laurenz Albe
• 14:43   Re: Replication lag due to lagging restart_lsn Kyotaro Horiguchi
• 16:15   Re: Replication lag due to lagging restart_lsn Kiran Singh

20 August 2020

• 16:35   Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Jim Jarvie
• 20:30   Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Michael Lewis

21 August 2020

• 00:13   Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Jim Jarvie
• 00:42   Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Michael Lewis
• 01:39   Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Jim Jarvie
• 02:01   Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Michael Lewis
• 02:37   Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED David Rowley
• 07:34   Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Thomas Munro
• 18:24   Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Jim Jarvie

24 August 2020

• 19:39   sizing / capacity planning tipps related to expected request or transactions per second Dirk Krautschick
• 19:49   Re: sizing / capacity planning tipps related to expected request or transactions per second MichaelDBA
• 19:51   Re: sizing / capacity planning tipps related to expected request or transactions per second Pavel Stehule
• 20:58   Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Jeff Janes

26 August 2020

• 09:54   Re: Too few rows expected by Planner on partitioned tables Julian Wolf
• 16:32   Re: Too few rows expected by Planner on partitioned tables Michael Lewis