Mailing lists [pgsql-performance]

1 February

• 12:23   Weird performance differences between cloud vendors Dirk Krautschick
• 14:07   Re: Weird performance differences between cloud vendors Laurenz Albe
• 14:50   huge SubtransSLRU and SubtransBuffer wait_event James Pang (chaolpan)
• 15:41   Re: huge SubtransSLRU and SubtransBuffer wait_event Laurenz Albe
• 16:40   Memory growth using many named prepared statements, in spite of using DISCARD ALL afterwards. Daniel Blanch Bataller
• 16:51   Re: Memory growth using many named prepared statements, in spite of using DISCARD ALL afterwards. Heikki Linnakangas
• 18:34   RE: huge SubtransSLRU and SubtransBuffer wait_event James Pang (chaolpan)

2 February

• 09:47   RE: huge SubtransSLRU and SubtransBuffer wait_event James Pang (chaolpan)
• 10:45   Re: Memory growth using many named prepared statements, in spite of using DISCARD ALL afterwards. Daniel Blanch Bataller
• 11:12   Re: huge SubtransSLRU and SubtransBuffer wait_event Alvaro Herrera
• 12:26   Re: huge SubtransSLRU and SubtransBuffer wait_event Lars Aksel Opsahl
• 13:04   Re: huge SubtransSLRU and SubtransBuffer wait_event Nikolay Samokhvalov
• 13:31   Re: huge SubtransSLRU and SubtransBuffer wait_event Laurenz Albe

6 February

• 09:59   RE: huge SubtransSLRU and SubtransBuffer wait_event James Pang (chaolpan)

9 February

• 17:14   Simple JOIN on heavy table not using expected index kimaidou
• 17:19   Re: Simple JOIN on heavy table not using expected index Burçin Yazıcı
• 18:07   Re: Simple JOIN on heavy table not using expected index kimaidou
• 18:12   Re: Simple JOIN on heavy table not using expected index Tom Lane
• 18:44   Re: Simple JOIN on heavy table not using expected index kimaidou

15 February

• 17:37   PostgreSQL doesn't use index-only scan if there is an expression in index Pavel Kulakov
• 18:01   Re: PostgreSQL doesn't use index-only scan if there is an expression in index Laurenz Albe

19 February

• 19:14   "not related" code blocks for removal of dead rows when using vacuum and this kills the performance Lars Aksel Opsahl
• 20:46   Re: "not related" code blocks for removal of dead rows when using vacuum and this kills the performance Laurenz Albe
• 21:36   Re: "not related" code blocks for removal of dead rows when using vacuum and this kills the performance Lars Aksel Opsahl

20 February

• 08:46   Re: "not related" code blocks for removal of dead rows when using vacuum and this kills the performance Lars Aksel Opsahl
• 10:29   Re: "not related" code blocks for removal of dead rows when using vacuum and this kills the performance Laurenz Albe
• 13:46   Re: "not related" code blocks for removal of dead rows when using vacuum and this kills the performance Lars Aksel Opsahl

23 February

• 10:20   sql statement not using all primary key values and poor performance James Pang
• 10:25   Re: sql statement not using all primary key values and poor performance James Pang
• 12:17   Re: sql statement not using all primary key values and poor performance Laurenz Albe
• 13:21   Re: sql statement not using all primary key values and poor performance James Pang
• 14:48   Re: sql statement not using all primary key values and poor performance Laurenz Albe

26 February

• 09:01   Re: FW: huge SubtransSLRU and SubtransBuffer wait_event James Pang

27 February

• 03:25   Optimizing count(), but Explain estimates wildly off Chema
• 07:36   Re: Optimizing count(), but Explain estimates wildly off Vitalii Tymchyshyn
• 10:40   Re: Optimizing count(), but Explain estimates wildly off Laurenz Albe
• 16:11   Re: Optimizing count(), but Explain estimates wildly off Alvaro Herrera
• 16:54   extend statistics help reduce index scan a lot of shared buffer hits. James Pang
• 16:58   Fwd: extend statistics help reduce index scan a lot of shared buffer hits. James Pang

28 February

• 17:53   Re: Fwd: extend statistics help reduce index scan a lot of shared buffer hits. Tomas Vondra

29 February

• 17:27   generic plan generate poor performance James Pang
• 17:38   Re: generic plan generate poor performance Pavel Stehule
• 19:42   Table Partitioning and Indexes Performance Questions David Kelly
• 20:32   Re: Table Partitioning and Indexes Performance Questions Laurenz Albe
• 21:11   Re: Table Partitioning and Indexes Performance Questions Anupam b