pgsql-performance since 2019-08-09 00:00

Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next

Aug. 9, 2019

Thread Author Time
Bitmap heap scan performance 📎 Rob Emery 08:41
Re: Bitmap heap scan performance Jeff Janes 12:30
Re: Postgres not using correct indices for views. Tom Lane 15:16

Aug. 10, 2019

Thread Author Time
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 07:10
Re: Postgres not using correct indices for views. Thomas Rosenstein 10:05
Re: Postgres not using correct indices for views. [email protected] 11:11

Aug. 11, 2019

Thread Author Time
Re: Postgres not using correct indices for views. Tom Lane 20:31

Aug. 12, 2019

Thread Author Time
Planner performance in partitions Piotr Włodarczyk 12:37
Re: Bitmap heap scan performance Rob Emery 13:00
Re: Bitmap heap scan performance Jeremy Finzel 13:29
Re: Planner performance in partitions Michael Lewis 19:05
Re: Planner performance in partitions MichaelDBA 19:24
ODP: Planner performance in partitions Piotr Włodarczyk 20:03
Re: Planner performance in partitions Michael Lewis 20:25
Last event per user Luís Roberto Weck 20:57
Re: Last event per user Michael Lewis 21:56
Re: Planner performance in partitions David Rowley 22:25
Re: Last event per user Luís Roberto Weck 22:28
Re: Last event per user Michael Lewis 22:35
Re: Planner performance in partitions Michael Lewis 22:37
Re: Luís Roberto Weck 22:43
Re: Michael Lewis 22:53
Re: Last event per user Luís Roberto Weck 23:03
Re: Last event per user Michael Lewis 23:09

Aug. 13, 2019

Thread Author Time
ODP: Planner performance in partitions Piotr Włodarczyk 06:29
Re: Strange runtime partition pruning behaviour with 11.4 Sverre Boschman 07:02
ORA-24345: A Truncation or null fetch error occurred -ora2pg Daulat Ram 08:23
Re: zabbix on postgresql - very slow delete of events Kristian Ejvind 11:08
Re: Last event per user Luís Roberto Weck 11:34
performance bottlenecks on lock transactionid 📎 王若楠 14:15
Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg Luca Ferrari 15:02
RE: ORA-24345: A Truncation or null fetch error occurred -ora2pg Daulat Ram 17:34
Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg Adrian Klaver 17:57

Aug. 14, 2019

Thread Author Time
Re: performance bottlenecks on lock transactionid Laurenz Albe 07:31
re:Re: performance bottlenecks on lock transactionid 王若楠 07:57
RE: ORA-24345: A Truncation or null fetch error occurred -ora2pg Daulat Ram 09:39
Re: Re: performance bottlenecks on lock transactionid Laurenz Albe 10:25
Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg Adrian Klaver 14:13
Continuous Performance Test Jean Baro 16:18
Continuous Performance Test Jean Baro 17:56
Re: Continuous Performance Test Nasby, Jim 20:57
Re: [UNVERIFIED SENDER] Re: Continuous Performance Test Nasby, Jim 20:59

Aug. 16, 2019

Thread Author Time
Re: [UNVERIFIED SENDER] Re: Continuous Performance Test Jean Baro 01:33

Aug. 18, 2019

Thread Author Time
UPGRADE TO PG11 CAUSED DEGREDATION IN PERFORMANCE Mariel Cherkassky 06:56
Re: UPGRADE TO PG11 CAUSED DEGREDATION IN PERFORMANCE Pavel Stehule 08:41

Aug. 19, 2019

Thread Author Time
pg11 list partitions vs hash partitions Mariel Cherkassky 12:32
Re: Partial join Arne Roland 15:17

Aug. 20, 2019

Thread Author Time
Erratically behaving query needs optimization Barbu Paul - Gheorghe 13:54
Re: Erratically behaving query needs optimization Luís Roberto Weck 14:58
Re: Erratically behaving query needs optimization MichaelDBA 15:07
Extremely slow HashAggregate in simple UNION query Felix Geisendörfer 15:11
Re: Extremely slow HashAggregate in simple UNION query Michael Lewis 16:19
Re: Extremely slow HashAggregate in simple UNION query Pavel Stehule 16:57
Re: Extremely slow HashAggregate in simple UNION query Andres Freund 17:32
Re: Extremely slow HashAggregate in simple UNION query Felix Geisendörfer 17:55
Re: Extremely slow HashAggregate in simple UNION query Andres Freund 18:27

Aug. 21, 2019

Thread Author Time
Re: Erratically behaving query needs optimization Barbu Paul - Gheorghe 07:30
Re: Erratically behaving query needs optimization Luís Roberto Weck 11:30
Re: Extremely slow HashAggregate in simple UNION query 📎 Jeff Janes 18:26

Aug. 22, 2019

Thread Author Time
Re: Extremely slow HashAggregate in simple UNION query Pavel Stehule 05:08
Re: Extremely slow HashAggregate in simple UNION query Felix Geisendörfer 09:06
Re: Erratically behaving query needs optimization Barbu Paul - Gheorghe 11:51
Re: Erratically behaving query needs optimization Luís Roberto Weck 12:10
Re: Erratically behaving query needs optimization Barbu Paul - Gheorghe 12:22
Extremely slow count (simple query, with index) Marco Colli 12:44
Re: Erratically behaving query needs optimization Barbu Paul - Gheorghe 12:49
Re: Extremely slow count (simple query, with index) Justin Pryzby 13:19
Re: Extremely slow count (simple query, with index) Ravikumar Reddy 13:25
Re: Extremely slow count (simple query, with index) MichaelDBA 13:25
Re: Extremely slow count (simple query, with index) Michael Lewis 17:37
Re: Erratically behaving query needs optimization legrand legrand 17:43
Re: Extremely slow count (simple query, with index) Marco Colli 17:54
Re: Extremely slow count (simple query, with index) Justin Pryzby 18:04

Aug. 23, 2019

Thread Author Time
Re: Out of Memory errors are frustrating as heck! Gunther 13:17
Re: Out of Memory errors are frustrating as heck! Gunther 14:19
Re: Out of Memory errors are frustrating as heck! Tom Lane 14:20

Aug. 24, 2019

Thread Author Time
pg_basebackup is taking an unusually long time with Postgres 11.3 andy andy 03:24
Re: Out of Memory errors are frustrating as heck! Gunther 15:40
Re: Extremely slow HashAggregate in simple UNION query Jeff Janes 19:16
Re: Extremely slow HashAggregate in simple UNION query Tom Lane 19:41
Re: Extremely slow HashAggregate in simple UNION query Andres Freund 19:54

Aug. 25, 2019

Thread Author Time
Re: Erratically behaving query needs optimization Jeff Janes 14:50

Aug. 26, 2019

Thread Author Time
Re: Erratically behaving query needs optimization Barbu Paul - Gheorghe 08:25
Re: Erratically behaving query needs optimization Justin Pryzby 11:51

Sept. 2, 2019

Thread Author Time
Re: Erratically behaving query needs optimization Jeff Janes 21:57

Sept. 3, 2019

Thread Author Time
Re: Erratically behaving query needs optimization Barbu Paul - Gheorghe 12:41
Re: UPGRADE TO PG11 CAUSED DEGREDATION IN PERFORMANCE Merlin Moncure 17:34
Incorrect choice of Nested Loop for a skewed distribution Oleg Kharin 17:47

Sept. 4, 2019

Thread Author Time
Upsert performance considerations (~1 mil/hour) Fredrik Blomqvist 17:29
Re: Upsert performance considerations (~1 mil/hour) Jeff Janes 19:58
Re: Upsert performance considerations (~1 mil/hour) Fredrik Blomqvist 21:18

Sept. 5, 2019

Thread Author Time
Re: Incorrect choice of Nested Loop for a skewed distribution Justin Pryzby 00:18

Sept. 6, 2019

Thread Author Time
Re: Incorrect choice of Nested Loop for a skewed distribution 📎 Oleg Kharin 05:02

Sept. 9, 2019

Thread Author Time
select distinct runs slow on pg 10.6 yash mehta 08:30
Re: select distinct runs slow on pg 10.6 yash mehta 08:38
Re: select distinct runs slow on pg 10.6 Flo Rance 10:00
Re: select distinct runs slow on pg 10.6 yash mehta 10:29
Re: select distinct runs slow on pg 10.6 Justin Pryzby 10:39
Re: select distinct runs slow on pg 10.6 Flo Rance 13:16
Re: select distinct runs slow on pg 10.6 Michael Lewis 15:39

Sept. 10, 2019

Thread Author Time
Re: select distinct runs slow on pg 10.6 yash mehta 04:53
Re: select distinct runs slow on pg 10.6 Rick Otten 11:56

Sept. 11, 2019

Thread Author Time
Re: select distinct runs slow on pg 10.6 Merlin Moncure 15:54
Re: select distinct runs slow on pg 10.6 Dinesh Somani 16:38
Re: select distinct runs slow on pg 10.6 Rick Otten 17:57

Sept. 12, 2019

Thread Author Time
Re: select distinct runs slow on pg 10.6 Merlin Moncure 14:19
Re: select distinct runs slow on pg 10.6 Dinesh Somani 16:25

Sept. 13, 2019

Thread Author Time
Query execution time Vs Cost Amarendra Konda 11:08
Re: Query execution time Vs Cost Justin Pryzby 23:06

Sept. 14, 2019

Thread Author Time
Re: Query execution time Vs Cost Amarendra Konda 04:24

Sept. 17, 2019

Thread Author Time
does max_connections affect the query planner Bob Jolliffe 08:40
Re: does max_connections affect the query planner Tom Lane 14:13
Re: does max_connections affect the query planner Bob Jolliffe 14:15
Re: does max_connections affect the query planner Jeff Janes 14:25

Sept. 18, 2019

Thread Author Time
Question regarding fast-hashing in PGSQL Stephen Conley 16:41
Re: Question regarding fast-hashing in PGSQL Adam Brusselback 16:49
Re: Question regarding fast-hashing in PGSQL Stephen Conley 16:56
pg12 - migrate tables to partitions structure Mariel Cherkassky 18:02
Re: pg12 - migrate tables to partitions structure Michael Lewis 19:09
Re: pg12 - migrate tables to partitions structure Mariel Cherkassky 19:29
Re: pg12 - migrate tables to partitions structure Michael Lewis 20:08
Re: pg12 - migrate tables to partitions structure Mariel Cherkassky 20:13
Re: Question regarding fast-hashing in PGSQL Tom Lane 20:39
Re: pg12 - migrate tables to partitions structure Michael Lewis 20:56

Sept. 19, 2019

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

Sept. 20, 2019

Thread Author Time
Re: Slow query on a one-tuple table MichaelDBA 13:09

Sept. 23, 2019

Thread Author Time
pg12 partitions question Mariel Cherkassky 10:59
Re: pg12 partitions question Mariel Cherkassky 11:02
Slow query on V12. Luís Roberto Weck 18:42
Re: Slow query on V12. nikhil raj 18:43
Re: Slow query on V12. Luís Roberto Weck 19:03
Re: Slow query on V12. Luís Roberto Weck 19:12
Re: Slow query on V12. Tom Lane 19:44
Re: Slow query on V12. Luís Roberto Weck 20:23

Sept. 24, 2019

Thread Author Time
Monitor Postgres database status on Docker Daulat Ram 09:17
RE: Monitor Postgres database status on Docker Fan Liu 09:31
RE: Monitor Postgres database status on Docker Daulat Ram 10:05

Sept. 25, 2019

Thread Author Time
sequence depends on many tables Mariel Cherkassky 12:39
Re: sequence depends on many tables Laurenz Albe 19:19
Re: sequence depends on many tables Mariel Cherkassky 19:20
Re: sequence depends on many tables Laurenz Albe 19:23
Re: Bloom index cost model seems to be wrong Alvaro Herrera 20:12

Sept. 26, 2019

Thread Author Time
Re: Bloom index cost model seems to be wrong Michael Paquier 07:00
Analyze on slave promoted. Joao Junior 07:54
Re: Analyze on slave promoted. Pavel Stehule 08:31
Slow pg_publication_tables with many schemas and tables Edilmar Alves 20:37
Re: Slow pg_publication_tables with many schemas and tables Tom Lane 23:11

Sept. 27, 2019

Thread Author Time
RE: Monitor Postgres database status on Docker Daulat Ram 05:25
Autovacuum is cleaning very less dead tuples Amarendra Konda 05:40
Re: Autovacuum is cleaning very less dead tuples Laurenz Albe 05:55
Re: Analyze on slave promoted. Vik Fearing 10:41
Re: Monitor Postgres database status on Docker Olivier Gautherot 12:36
Re: Slow pg_publication_tables with many schemas and tables Edilmar Alves 14:25

Sept. 29, 2019

Thread Author Time
Re: sequence depends on many tables Mariel Cherkassky 06:05
distinct on extract returns composite type Mariel Cherkassky 09:46
Re: distinct on extract returns composite type Félix GERZAGUET 10:34
Re: sequence depends on many tables Tom Lane 15:32

Sept. 30, 2019

Thread Author Time
Re: distinct on extract returns composite type Mariel Cherkassky 13:42
Re: distinct on extract returns composite type Tom Lane 13:48
Re: distinct on extract returns composite type Mariel Cherkassky 13:51

Oct. 1, 2019

Thread Author Time
Slow PostgreSQL 10.6 query Behrang Saeedzadeh 12:37
Re: Slow PostgreSQL 10.6 query Tom Lane 13:27
Re: Slow PostgreSQL 10.6 query Behrang Saeedzadeh 13:42

Oct. 2, 2019

Thread Author Time
pg12 - partition by column that might have null values Mariel Cherkassky 06:17
Re: pg12 - partition by column that might have null values Laurenz Albe 07:29
Re: pg12 - partition by column that might have null values Mariel Cherkassky 07:37
RE: pg12 - partition by column that might have null values Mike Sofen 12:08
Re: pg12 - partition by column that might have null values Mariel Cherkassky 13:44
RE: pg12 - partition by column that might have null values Mike Sofen 23:14

Oct. 3, 2019

Thread Author Time
Re: pg12 - partition by column that might have null values Mariel Cherkassky 07:30
Re: pg12 - partition by column that might have null values Michael Lewis 17:55
Some observations on very slow pg_restore operations Ogden Brash 20:30
Re: Some observations on very slow pg_restore operations MichaelDBA 21:48
Re: Some observations on very slow pg_restore operations Ogden Brash 23:19

Oct. 4, 2019

Thread Author Time
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 04:12
Re: Some observations on very slow pg_restore operations Justin Pryzby 06:03
Query went slow all of sudden. ON V 11.3 nikhil raj 10:22

Browse Archives

Prev | Next