Home > mailing lists

Mailing lists [pgsql-performance]

3 September 2019

00:57 Re: Erratically behaving query needs optimization Jeff Janes
15:41 Re: Erratically behaving query needs optimization Barbu Paul - Gheorghe
20:34 Re: UPGRADE TO PG11 CAUSED DEGREDATION IN PERFORMANCE Merlin Moncure
20:47 Incorrect choice of Nested Loop for a skewed distribution Oleg Kharin

4 September 2019

20:29 Upsert performance considerations (~1 mil/hour) Fredrik Blomqvist
22:58 Re: Upsert performance considerations (~1 mil/hour) Jeff Janes

5 September 2019

00:18 Re: Upsert performance considerations (~1 mil/hour) Fredrik Blomqvist
03:18 Re: Incorrect choice of Nested Loop for a skewed distribution Justin Pryzby

6 September 2019

08:02 Re: Incorrect choice of Nested Loop for a skewed distribution Oleg Kharin

9 September 2019

11:30 select distinct runs slow on pg 10.6 yash mehta
11:38 Re: select distinct runs slow on pg 10.6 yash mehta
13:00 Re: select distinct runs slow on pg 10.6 Flo Rance
13:29 Re: select distinct runs slow on pg 10.6 yash mehta
13:39 Re: select distinct runs slow on pg 10.6 Justin Pryzby
16:16 Re: select distinct runs slow on pg 10.6 Flo Rance
18:39 Re: select distinct runs slow on pg 10.6 Michael Lewis

10 September 2019

07:53 Re: select distinct runs slow on pg 10.6 yash mehta
14:56 Re: select distinct runs slow on pg 10.6 Rick Otten

11 September 2019

18:54 Re: select distinct runs slow on pg 10.6 Merlin Moncure
19:38 Re: select distinct runs slow on pg 10.6 Dinesh Somani
20:57 Re: select distinct runs slow on pg 10.6 Rick Otten

12 September 2019

17:19 Re: select distinct runs slow on pg 10.6 Merlin Moncure
19:25 Re: select distinct runs slow on pg 10.6 Dinesh Somani

13 September 2019

14:08 Query execution time Vs Cost Amarendra Konda

14 September 2019

02:06 Re: Query execution time Vs Cost Justin Pryzby
07:24 Re: Query execution time Vs Cost Amarendra Konda

17 September 2019

11:40 does max_connections affect the query planner Bob Jolliffe
17:13 Re: does max_connections affect the query planner Tom Lane
17:15 Re: does max_connections affect the query planner Bob Jolliffe
17:25 Re: does max_connections affect the query planner Jeff Janes

18 September 2019

19:41 Question regarding fast-hashing in PGSQL Stephen Conley
19:49 Re: Question regarding fast-hashing in PGSQL Adam Brusselback
19:56 Re: Question regarding fast-hashing in PGSQL Stephen Conley
21:02 pg12 - migrate tables to partitions structure Mariel Cherkassky
22:09 Re: pg12 - migrate tables to partitions structure Michael Lewis
22:29 Re: pg12 - migrate tables to partitions structure Mariel Cherkassky
23:08 Re: pg12 - migrate tables to partitions structure Michael Lewis
23:13 Re: pg12 - migrate tables to partitions structure Mariel Cherkassky
23:39 Re: Question regarding fast-hashing in PGSQL Tom Lane
23:56 Re: pg12 - migrate tables to partitions structure Michael Lewis

19 September 2019

13:09 Surprising benchmark count(1) vs. count(*) Thomas Kellerer
13:22 Re: Surprising benchmark count(1) vs. count(*) Laurenz Albe
14:22 Re: Surprising benchmark count(1) vs. count(*) Thomas Kellerer
17:11 Re: Surprising benchmark count(1) vs. count(*) Tom Lane
18:50 comparing output of internal pg tables of referenced tables Mariel Cherkassky
18:59 Delete huge Table under XFS Joao Junior
19:28 Re: comparing output of internal pg tables of referenced tables Tom Lane
19:50 Re: Delete huge Table under XFS Andreas Kretschmer
19:55 Slow query on a one-tuple table Luís Roberto Weck
20:00 Re: Delete huge Table under XFS Joao Junior
20:21 Re: Slow query on a one-tuple table Michael Lewis
20:27 Re: Delete huge Table under XFS Christoph Berg
21:30 Re: Slow query on a one-tuple table Luís Roberto Weck
21:34 RE: Slow query on a one-tuple table Igor Neyman
22:59 Re: Slow query on a one-tuple table Luís Roberto Weck
23:11 RE: Slow query on a one-tuple table Igor Neyman
23:24 Re: Slow query on a one-tuple table Luís Roberto Weck
23:38 Re: Surprising benchmark count(1) vs. count(*) Adam Brusselback
23:41 Re: Slow query on a one-tuple table Luís Roberto Weck

20 September 2019

00:36 Re: Surprising benchmark count(1) vs. count(*) Tom Lane
01:27 Re: Slow query on a one-tuple table Luís Roberto Weck
01:32 Re: Slow query on a one-tuple table Michael Lewis
01:46 Re: Slow query on a one-tuple table Luís Roberto Weck
01:57 Re: Slow query on a one-tuple table Tom Lane
16:09 Re: Slow query on a one-tuple table MichaelDBA

23 September 2019

13:59 pg12 partitions question Mariel Cherkassky
14:02 Re: pg12 partitions question Mariel Cherkassky
21:42 Slow query on V12. Luís Roberto Weck
21:43 Re: Slow query on V12. nikhil raj
22:03 Re: Slow query on V12. Luís Roberto Weck
22:12 Re: Slow query on V12. Luís Roberto Weck
22:44 Re: Slow query on V12. Tom Lane
23:23 Re: Slow query on V12. Luís Roberto Weck

25 September 2019

15:39 sequence depends on many tables Mariel Cherkassky
22:19 Re: sequence depends on many tables Laurenz Albe
22:20 Re: sequence depends on many tables Mariel Cherkassky
22:23 Re: sequence depends on many tables Laurenz Albe

26 September 2019

10:54 Analyze on slave promoted. Joao Junior
11:31 Re: Analyze on slave promoted. Pavel Stehule
23:37 Slow pg_publication_tables with many schemas and tables Edilmar Alves

27 September 2019

02:11 Re: Slow pg_publication_tables with many schemas and tables Tom Lane
08:40 Autovacuum is cleaning very less dead tuples Amarendra Konda
08:55 Re: Autovacuum is cleaning very less dead tuples Laurenz Albe
13:41 Re: Analyze on slave promoted. Vik Fearing
17:25 Re: Slow pg_publication_tables with many schemas and tables Edilmar Alves

29 September 2019

09:05 Re: sequence depends on many tables Mariel Cherkassky
12:46 distinct on extract returns composite type Mariel Cherkassky
13:34 Re: distinct on extract returns composite type Félix GERZAGUET
18:32 Re: sequence depends on many tables Tom Lane

30 September 2019

16:42 Re: distinct on extract returns composite type Mariel Cherkassky
16:48 Re: distinct on extract returns composite type Tom Lane
16:51 Re: distinct on extract returns composite type Mariel Cherkassky