pgsql-performance - December 2017

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
Jump to day: 1 2 3 4 5 6 7 8 9 11 12 13 15 16 17 19 20 22 23 24 25 27 28 30

Dec. 1, 2017

Thread Author Time
Delete tables difference involves seq scan Danylo Hlynskyi 13:03
Re: Delete tables difference involves seq scan Danylo Hlynskyi 13:17
Re: Delete tables difference involves seq scan Danylo Hlynskyi 14:52
Bad plan for ltree predicate <@ Roman Konoval 17:20
Bitmap scan is undercosted? Vitaliy Garnashevich 17:40
Re: Bitmap scan is undercosted? Justin Pryzby 18:34
Re: Bad plan for ltree predicate <@ Tom Lane 21:33
Re: Bitmap scan is undercosted? Vitaliy Garnashevich 23:08
Re: Bitmap scan is undercosted? Justin Pryzby 23:11
Re: Bitmap scan is undercosted? Vitaliy Garnashevich 23:54

Dec. 2, 2017

Thread Author Time
Re: Bitmap scan is undercosted? Justin Pryzby 02:06
Re: Bad plan for ltree predicate <@ Roman Konoval 02:34
Re: Bitmap scan is undercosted? Jeff Janes 05:51
Re: Bitmap scan is undercosted? Justin Pryzby 06:41
Re: Bitmap scan is undercosted? Vitaliy Garnashevich 07:08
Re: Bitmap scan is undercosted? Jeff Janes 21:17
Re: Bitmap scan is undercosted? Tom Lane 23:44

Dec. 3, 2017

Thread Author Time
Re: Bitmap scan is undercosted? Jeff Janes 01:27
Re: Bitmap scan is undercosted? - boolean correlation Justin Pryzby 04:04
Re: Bitmap scan is undercosted? Vitaliy Garnashevich 21:15
Re: Bitmap scan is undercosted? Vitaliy Garnashevich 21:22
Re: Bitmap scan is undercosted? Vitaliy Garnashevich 22:11
Re: Bitmap scan is undercosted? 📎 Tom Lane 23:08
Re: Bitmap scan is undercosted? - boolean correlation Jeff Janes 23:21
Re: Bitmap scan is undercosted? - boolean correlation Tom Lane 23:31

Dec. 4, 2017

Thread Author Time
Re: Bitmap scan is undercosted? - boolean correlation Jeff Janes 00:27

Dec. 5, 2017

Thread Author Time
vacuum after truncate Mariel Cherkassky 14:03
Re: vacuum after truncate Laurenz Albe 14:40
Extremely slow DELETE with cascade foreign keys Rodrigo Rosenfeld Rosas 16:21
Re: Extremely slow DELETE with cascade foreign keys Tom Lane 16:27
Re: Extremely slow DELETE with cascade foreign keys Alvaro Herrera 16:43
Re: Extremely slow DELETE with cascade foreign keys Rodrigo Rosenfeld Rosas 17:00
Re: Extremely slow DELETE with cascade foreign keys Rodrigo Rosenfeld Rosas 17:22
Re: Extremely slow DELETE with cascade foreign keys Tom Lane 17:25
Re: Extremely slow DELETE with cascade foreign keys Rodrigo Rosenfeld Rosas 17:27
Re: Extremely slow DELETE with cascade foreign keys Alvaro Herrera 17:49
Different plan chosen when in lateral subquery Alex Reece 18:04
Re: Different plan chosen when in lateral subquery Alex Reece 18:08
Re: Extremely slow DELETE with cascade foreign keys Rodrigo Rosenfeld Rosas 18:15
Re: Different plan chosen when in lateral subquery Alex Reece 18:16
Re: Extremely slow DELETE with cascade foreign keys Rodrigo Rosenfeld Rosas 18:17
Re: Bitmap scan is undercosted? - boolean correlation Tom Lane 18:50

Dec. 6, 2017

Thread Author Time
Re: Half billion records in one table? RDS Aaron Werman 01:59
Re: insert and query performance on big string table with pg_trgm Matthew Hall 06:15
Re: Bitmap scan is undercosted? 📎 Vitaliy Garnashevich 07:06
Re: insert and query performance on big string table with pg_trgm Sergei Kornilov 07:23
Re: Different plan chosen when in lateral subquery Laurenz Albe 08:20
Re: Bitmap scan is undercosted? - overestimated correlation and cost_index Justin Pryzby 21:46

Dec. 7, 2017

Thread Author Time
Re: Bitmap scan is undercosted? Vitaliy Garnashevich 00:17
Re: insert and query performance on big string table with pg_trgm Matthew Hall 02:04
Re: Bitmap scan is undercosted? Jeff Janes 03:48
Re: Bitmap scan is undercosted? - boolean correlation 📎 Jeff Janes 04:51
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Gunther 12:46
Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE Ulf Lohbrügge 12:54
Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE Tom Lane 16:01
Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE Ulf Lohbrügge 16:15
Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE Tom Lane 16:38
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Laurenz Albe 17:31
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Claudio Freire 17:56

Dec. 8, 2017

Thread Author Time
Learning EXPLAIN Flávio Henrique 01:12
Table with large number of int columns, very slow COPY FROM Alex Tokarev 04:21
Re: Setting effective_io_concurrency in VM? Mark Kirkwood 04:51
Re: Table with large number of int columns, very slow COPY FROM Andreas Kretschmer 07:20
Re: Learning EXPLAIN Guillaume Lelarge 13:20
Re: Learning EXPLAIN Flavio Henrique Araque Gurgel 13:32
Re: Learning EXPLAIN Gustavo Velasquez 16:44
Re: Table with large number of int columns, very slow COPY FROM Andres Freund 18:17
Faster str to int conversion (was Table with large number of int columns, very slow COPY FROM) 📎 Andres Freund 21:44

Dec. 9, 2017

Thread Author Time
Re: Learning EXPLAIN Sam Gendler 04:47
Re: Learning EXPLAIN Sam Gendler 04:52

Dec. 11, 2017

Thread Author Time
Prepared Transactions Riaan Stander 00:39
Re: Prepared Transactions Sergei Kornilov 08:14
Re: Prepared Transactions jwhiting 12:13

Dec. 12, 2017

Thread Author Time
Re: Bitmap scan is undercosted? Jeff Janes 07:29
Re: Bitmap scan is undercosted? - overestimated correlation and cost_index Jeff Janes 09:29
PostgreSQL database size is not reasonable Mariel Cherkassky 15:15
Re: PostgreSQL database size is not reasonable David G. Johnston 15:21
RE: PostgreSQL database size is not reasonable Craig McIlwee 15:44
Re: PostgreSQL database size is not reasonable Tom Lane 15:49
Re: PostgreSQL database size is not reasonable Mariel Cherkassky 16:22
Re: PostgreSQL database size is not reasonable Tom Lane 17:59

Dec. 13, 2017

Thread Author Time
CPU 100% usage caused by unknown postgres process.. Dinesh Chandra 12108 10:12
Re: CPU 100% usage caused by unknown postgres process.. Laurenz Albe 10:36
Re: CPU 100% usage caused by unknown postgres process.. Justin Pryzby 12:19
Re: CPU 100% usage caused by unknown postgres process.. Tomas Vondra 15:22

Dec. 15, 2017

Thread Author Time
Re: Bitmap scan is undercosted? - overestimated correlation and cost_index Justin Pryzby 20:54

Dec. 16, 2017

Thread Author Time
Re: Bitmap scan is undercosted? - overestimated correlation and cost_index Justin Pryzby 19:18

Dec. 17, 2017

Thread Author Time
Re: Bitmap scan is undercosted? - overestimated correlation and cost_index Justin Pryzby 02:37

Dec. 19, 2017

Thread Author Time
WHERE IN for JOIN subquery? Dave Johansen 00:00
Re: WHERE IN for JOIN subquery? David G. Johnston 00:10
Re: WHERE IN for JOIN subquery? Dave Johansen 00:29
Autoanalyze CPU usage Habib Nahas 16:47
Re: Autoanalyze CPU usage Justin Pryzby 17:09
Re: Autoanalyze CPU usage Tomas Vondra 22:03
Re: Autoanalyze CPU usage Habib Nahas 22:53
Re: Autoanalyze CPU usage Habib Nahas 22:53
Re: Autoanalyze CPU usage Justin Pryzby 22:55

Dec. 20, 2017

Thread Author Time
Re: Autoanalyze CPU usage Michaeldba@sqlexec.com 01:10
Re: Autoanalyze CPU usage Laurenz Albe 07:15
Re: Autoanalyze CPU usage Nikolay Samokhvalov 08:24
Re: Autoanalyze CPU usage Habib Nahas 14:38

Dec. 22, 2017

Thread Author Time
Updating a large table Timokhin Maxim 16:46

Dec. 23, 2017

Thread Author Time
Re: Updating a large table salah jubeh 11:31
Re: Updating a large table Tomas Vondra 20:58

Dec. 24, 2017

Thread Author Time
Batch insert heavily affecting query performance. Jean Baro 19:51
Re: Batch insert heavily affecting query performance. MichaelDBA@sqlexec.com 23:52

Dec. 25, 2017

Thread Author Time
Re: Batch insert heavily affecting query performance. Jean Baro 00:09
Re: Batch insert heavily affecting query performance. MichaelDBA 01:30
Re: Batch insert heavily affecting query performance. Danylo Hlynskyi 02:59
Re: Batch insert heavily affecting query performance. Jean Baro 03:10

Dec. 27, 2017

Thread Author Time
Re: Batch insert heavily affecting query performance. Jean Baro 15:13
Re: Batch insert heavily affecting query performance. Rick Otten 15:38
RE: Batch insert heavily affecting query performance. Mike Sofen 15:58
Re: Batch insert heavily affecting query performance. Jeremy Finzel 16:02
Re: Batch insert heavily affecting query performance. Jean Baro 16:23
Re: Batch insert heavily affecting query performance. Jeff Janes 16:23
Re: Batch insert heavily affecting query performance. Jean Baro 16:34
RE: Batch insert heavily affecting query performance. Jean Baro 16:36
Re: Batch insert heavily affecting query performance. Jean Baro 16:37
Re: Batch insert heavily affecting query performance. Jean Baro 17:02
Re: Batch insert heavily affecting query performance. Alvaro Hernandez 17:09
RE: Batch insert heavily affecting query performance. Mike Sofen 17:10
Re: Batch insert heavily affecting query performance. David Miller 17:15

Dec. 28, 2017

Thread Author Time
Table performance with millions of rows Robert Blayzor 00:54
Re: Table performance with millions of rows (partitioning) Justin Pryzby 01:20
Re: Table performance with millions of rows (partitioning) Robert Blayzor 01:27
Re: Table performance with millions of rows (partitioning) pinker 02:22

Dec. 30, 2017

Thread Author Time
partitioning an existing table Robert Blayzor 04:37
Re: partitioning an existing table Justin Pryzby 05:38
analyze stats: child vs parent Justin Pryzby 05:56
Re: partitioning an existing table Robert Blayzor 14:19
Re: partitioning an existing table - efficient pg_dump Justin Pryzby 18:42

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 11 12 13 15 16 17 19 20 22 23 24 25 27 28 30