Mailing lists [pgsql-performance]

2 May 2021

• 22:45   15x slower PreparedStatement vs raw query Alex

3 May 2021

• 23:18   Re: 15x slower PreparedStatement vs raw query Justin Pryzby

4 May 2021

• 12:21   Re: 15x slower PreparedStatement vs raw query Alex
• 15:12   Re: 15x slower PreparedStatement vs raw query Rick Otten
• 16:59   Re: 15x slower PreparedStatement vs raw query Alex
• 18:22   Re: 15x slower PreparedStatement vs raw query Laurenz Albe
• 18:50   Re: 15x slower PreparedStatement vs raw query Vijaykumar Jain

5 May 2021

• 09:57   Re: 15x slower PreparedStatement vs raw query David Rowley
• 09:59   Re: 15x slower PreparedStatement vs raw query Justin Pryzby
• 18:21   Re: 15x slower PreparedStatement vs raw query Alex

6 May 2021

• 17:38   Very slow Query compared to Oracle / SQL - Server Semen Yefimenko
• 19:11   Re: Very slow Query compared to Oracle / SQL - Server luis.roberto@siscobra.com.br
• 21:15   Re: Very slow Query compared to Oracle / SQL - Server Alexey M Boltenkov
• 21:20   Re: Very slow Query compared to Oracle / SQL - Server Alexey M Boltenkov
• 21:59   Re: Very slow Query compared to Oracle / SQL - Server Semen Yefimenko
• 22:26   Re: Very slow Query compared to Oracle / SQL - Server Andreas Joseph Krogh
• 22:48   Re: Very slow Query compared to Oracle / SQL - Server Vijaykumar Jain
• 23:01   Re: Very slow Query compared to Oracle / SQL - Server Justin Pryzby
• 23:02   Re: Very slow Query compared to Oracle / SQL - Server Alexey M Boltenkov
• 23:17   Re: Very slow Query compared to Oracle / SQL - Server Alexey M Boltenkov

7 May 2021

• 00:16   Re: Very slow Query compared to Oracle / SQL - Server Imre Samu
• 11:04   Re: Very slow Query compared to Oracle / SQL - Server Semen Yefimenko
• 11:44   Re: Very slow Query compared to Oracle / SQL - Server Vijaykumar Jain
• 12:02   Re: Very slow Query compared to Oracle / SQL - Server Semen Yefimenko
• 12:55   Re: Very slow Query compared to Oracle / SQL - Server Vijaykumar Jain
• 15:50   Re: Very slow Query compared to Oracle / SQL - Server Rick Otten
• 18:57   Re: Very slow Query compared to Oracle / SQL - Server Semen Yefimenko
• 19:28   Re: Very slow Query compared to Oracle / SQL - Server Tom Lane

8 May 2021

• 00:28   Re: Very slow Query compared to Oracle / SQL - Server Peter Geoghegan
• 00:43   Re: Very slow Query compared to Oracle / SQL - Server Peter Geoghegan
• 01:17   Re: Very slow Query compared to Oracle / SQL - Server didier
• 15:06   Re: Very slow Query compared to Oracle / SQL - Server Semen Yefimenko

10 May 2021

• 14:14   Re: Very slow Query compared to Oracle / SQL - Server Semen Yefimenko

13 May 2021

• 16:54   PostgreSQL blocked locks query Manoj Kumar
• 23:09   Re: PostgreSQL blocked locks query Justin Pryzby

14 May 2021

• 09:51   RE: Re: PostgreSQL blocked locks query Manoj Kumar
• 14:06   Very slow "bloat query" Marcin Gozdalik
• 14:50   Re: Very slow "bloat query" Gilles Darold
• 15:07   Re: Very slow "bloat query" Imre Samu
• 15:11   Re: Very slow "bloat query" Marcin Gozdalik
• 18:04   Re: Very slow "bloat query" Tom Lane
• 18:15   Re: Very slow "bloat query" Marcin Gozdalik
• 18:44   Re: Very slow "bloat query" Imre Samu
• 18:47   Re: Very slow "bloat query" Marcin Gozdalik

17 May 2021

• 23:42   Index and statistics not used 

18 May 2021

• 01:31   Re: Index and statistics not used David Rowley

21 May 2021

• 03:32   Partition with check constraint with "like" Nagaraj Raj
• 04:22   Re: Partition with check constraint with "like" David Rowley
• 05:36   Re: Partition with check constraint with "like" Nagaraj Raj
• 05:38   Re: Partition with check constraint with "like" Justin Pryzby
• 06:24   Re: Partition with check constraint with "like" Michael Lewis
• 10:02   Re: Partition with check constraint with "like" Nagaraj Raj
• 11:23   Re: Partition with check constraint with "like" David Rowley
• 15:41   logical replication Marc Millas
• 16:21   Re: logical replication Andrew Dunstan
• 16:44   Re: logical replication Marc Millas
• 19:38   Re: Partition with check constraint with "like" Nagaraj Raj
• 22:08   Re: Partition with check constraint with "like" Vijaykumar Jain
• 22:26   Re: Partition with check constraint with "like" Nagaraj Raj

22 May 2021

• 00:00   RE: Partition with check constraint with "like" Michel SALAIS
• 01:59   Re: Partition with check constraint with "like" Nagaraj Raj
• 02:28   Re: Partition with check constraint with "like" Nagaraj Raj
• 04:38   Re: Partition with check constraint with "like" David Rowley
• 04:38   Re: Partition with check constraint with "like" David Rowley
• 08:41   RE: Partition with check constraint with "like" Michel SALAIS

24 May 2021

• 14:30   transaction blocking on COMMIT Bob Jolliffe
• 14:35   Re: transaction blocking on COMMIT Vijaykumar Jain
• 15:10   Optimising outer joins in the presence of non-nullable references Philip Lykke Carlsen
• 16:52   Re: transaction blocking on COMMIT Bob Jolliffe
• 17:09   Re: transaction blocking on COMMIT Vijaykumar Jain
• 17:11   Re: Optimising outer joins in the presence of non-nullable references Tom Lane
• 19:22   Re: transaction blocking on COMMIT Bob Jolliffe
• 19:24   Re: transaction blocking on COMMIT Christophe Pettus

25 May 2021

• 00:59   Re: transaction blocking on COMMIT Alexey M Boltenkov

26 May 2021

• 01:50   issue partition scan Nagaraj Raj
• 02:01   Re: issue partition scan Christophe Pettus
• 02:38   Re: issue partition scan Nagaraj Raj
• 03:16   Re: issue partition scan David Rowley
• 03:27   Re: issue partition scan Christophe Pettus

27 May 2021

• 13:37   Count (select 1) subquery as constant Eugen Konkov
• 16:08   Re: transaction blocking on COMMIT Bob Jolliffe

28 May 2021

• 21:48   AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 22:08   Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan
• 22:18   Re: AWS forcing PG upgrade from v9.6 a disaster Campbell, Lance
• 22:38   Re: AWS forcing PG upgrade from v9.6 a disaster MichaelDBA
• 22:39   Re: AWS forcing PG upgrade from v9.6 a disaster Ryan Bair
• 23:11   Re: AWS forcing PG upgrade from v9.6 a disaster Michael Lewis
• 23:23   Re: AWS forcing PG upgrade from v9.6 a disaster Jan Wieck
• 23:33   Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 23:37   Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 23:38   Re: AWS forcing PG upgrade from v9.6 a disaster Pavel Stehule

29 May 2021

• 00:15   Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan
• 01:09   Re: AWS forcing PG upgrade from v9.6 a disaster Bob Lunney
• 01:13   Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 05:27   Re: AWS forcing PG upgrade from v9.6 a disaster Jan Wieck
• 05:41   Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan
• 05:43   Re: AWS forcing PG upgrade from v9.6 a disaster Christophe Pettus
• 07:08   Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 08:24   Re: AWS forcing PG upgrade from v9.6 a disaster Alexey M Boltenkov
• 14:39   Re: AWS forcing PG upgrade from v9.6 a disaster Jan Wieck
• 22:59   Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 23:17   Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 23:35   Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan

30 May 2021

• 01:47   Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)

31 May 2021

• 06:07   Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 06:41   Re: AWS forcing PG upgrade from v9.6 a disaster Christophe Pettus
• 07:23   Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 07:44   Re: AWS forcing PG upgrade from v9.6 a disaster Tom Lane
• 08:24   Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)