pgsql-performance since 2017-11-22 15:05

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

Nov. 22, 2017

Thread Author Time
RE: Bad estimates Alex Ignatov 15:05
Re: Query became very slow after 9.6 -> 10 upgrade Tomas Vondra 15:07
Re: Bad estimates Laurenz Albe 15:09
Re: Query became very slow after 9.6 -> 10 upgrade Tom Lane 15:19
RE: Bad estimates Artur Zając 16:52
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Andres Freund 16:56
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Matthew Hall 19:52
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Henrik Cednert (Filmlance) 20:06
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Patrick KUI-LI 21:07
Re: Query became very slow after 9.6 -> 10 upgrade Dmitry Shalashov 21:34
Re: Query became very slow after 9.6 -> 10 upgrade 📎 Tom Lane 23:07

Nov. 23, 2017

Thread Author Time
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Henrik Cednert (Filmlance) 09:26
Re: Query became very slow after 9.6 -> 10 upgrade Dmitry Shalashov 14:58
Re: Query became very slow after 9.6 -> 10 upgrade Tom Lane 17:00
pgpool + repmgr - who should be responsible for failover Mariel Cherkassky 18:14

Nov. 24, 2017

Thread Author Time
Issue with postgres login Daulat Ram 03:27
Re: Issue with postgres login Bob Strecansky 03:37
RE: Re: Issue with postgres login Daulat Ram 04:04
Re: Re: Issue with postgres login Bob Strecansky 04:07
RE: Re: Re: Issue with postgres login Daulat Ram 04:23
Re: Re: Re: Issue with postgres login Bob Strecansky 04:25
RE: Re: Re: Re: Issue with postgres login Daulat Ram 06:49
Re: Query became very slow after 9.6 -> 10 upgrade Dmitry Shalashov 15:44
Re: Query became very slow after 9.6 -> 10 upgrade Tom Lane 16:39

Nov. 25, 2017

Thread Author Time
Re: insert and query performance on big string table with pg_trgm Jeff Janes 06:35
Re: insert and query performance on big string table with pg_trgm Gábor SZŰCS 09:19
Re: Query became very slow after 9.6 -> 10 upgrade Dmitry Shalashov 11:54
Re: Query became very slow after 9.6 -> 10 upgrade Michael Paquier 12:13
Re: Query became very slow after 9.6 -> 10 upgrade Dmitry Shalashov 15:39
Re: Query became very slow after 9.6 -> 10 upgrade Tom Lane 15:42
Re: Query became very slow after 9.6 -> 10 upgrade Dmitry Shalashov 18:59

Nov. 27, 2017

Thread Author Time
Half billion records in one table? RDS Jean Baro 17:58
Re: Half billion records in one table? RDS Laurenz Albe 18:18
Setting effective_io_concurrency in VM? Don Seiler 18:23
Re: Setting effective_io_concurrency in VM? Scott Marlowe 18:40
Re: Setting effective_io_concurrency in VM? Fernando Hevia 21:06
Re: Setting effective_io_concurrency in VM? Andrew Kerber 21:44
Re: Setting effective_io_concurrency in VM? Don Seiler 22:03
Re: Setting effective_io_concurrency in VM? Jeff Janes 23:18
Re: Setting effective_io_concurrency in VM? Andres Freund 23:57

Nov. 28, 2017

Thread Author Time
Bad plan chosen for union all Alex Reece 10:13
Invalid mem alloc request on function bima p 18:56

Nov. 29, 2017

Thread Author Time
Re: Bad plan chosen for union all Alex Reece 03:39
Re: Bad plan chosen for union all Tom Lane 04:43
Re: Bad plan chosen for union all Alex Reece 05:31
ODBC--call failed :: Bindings were not allocated properly Dinesh Chandra 12108 14:47

Nov. 30, 2017

Thread Author Time
CREATE TABLE vs CREATE MATERIALIZED VIEW Caio Guimarães Figueiredo 12:07

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

Jan. 2, 2018

Thread Author Time
Restoring a table is ten times slower on Ubuntu 14.04 than on Ubuntu 16.04 Hans Braxmeier 13:27
Re: Restoring a table is ten times slower on Ubuntu 14.04 than on Ubuntu 16.04 Vasilis Ventirozos 13:30
primary key hash index Rick Otten 14:02
Re: primary key hash index Magnus Hagander 14:09

Jan. 4, 2018

Thread Author Time
Re: primary key hash index Jeff Janes 20:01

Jan. 5, 2018

Thread Author Time
GEQO and join_collapse_limit correlation 📎 Juan José Santamaría Flecha 14:30
Re: GEQO and join_collapse_limit correlation Tom Lane 16:16
Re: GEQO and join_collapse_limit correlation Juan José Santamaría Flecha 20:17
Re: GEQO and join_collapse_limit correlation Tom Lane 20:29

Jan. 6, 2018

Thread Author Time
Re: GEQO and join_collapse_limit correlation Juan José Santamaría Flecha 11:31

Jan. 8, 2018

Thread Author Time
seeing lag in postgresql replication Rambabu V 09:21
Re: seeing lag in postgresql replication Mariel Cherkassky 10:31

Jan. 9, 2018

Thread Author Time
Need Help on wal_compression Rambabu V 06:53
Re: Updating a large table Timokhin Maxim 12:18
Re: Updating a large table Sergei Kornilov 12:53
Re: Updating a large table Timokhin Maxim 16:31
Re: Need Help on wal_compression Claudio Freire 16:53
Re: Batch insert heavily affecting query performance. Claudio Freire 19:45
Re: Need Help on wal_compression Scott Marlowe 20:39
Performance of a Query 📎 Kumar, Virendra 21:18
View preformance oracle to postgresql Reddygari, Pavan 21:32

Browse Archives

Prev | Next