pgsql-performance since 2017-11-15 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

Nov. 15, 2017

Thread Author Time
query performance issue 📎 Samir Magar 09:33
Re: query performance issue Pavel Stehule 09:43
Re: query performance issue 📎 Samir Magar 12:54
Re: query performance issue Pavel Stehule 13:12
Re: query performance issue Justin Pryzby 14:16
Re: Query planner gaining the ability to replanning after start of query execution. Gunter 19:57
Re: query performance issue Gunther 19:58
Re: query performance issue Pavel Stehule 20:07
CREATE STATISTICS and join selectivity Justin Pryzby 20:19
Re: CREATE STATISTICS and join selectivity David Rowley 23:47

Nov. 18, 2017

Thread Author Time
POWA doesn't show queries executed Neto pr 01:52

Nov. 20, 2017

Thread Author Time
PostgreSQL 9.6 wals management Mariel Cherkassky 09:02
Re: PostgreSQL 9.6 wals management Michael Paquier 12:28
Re: PostgreSQL 9.6 wals management Mariel Cherkassky 12:56
Migration to pglister - Before Stephen Frost 14:33
Migration to PGLister - After Stephen Frost 15:03
Re: [ADMIN] Migration to pglister - Before Achilleas Mantzios 15:30
Re: [ADMIN] Migration to pglister - Before Stephen Frost 15:34
insert and query performance on big string table with pg_trgm Matthew Hall 22:54

Nov. 21, 2017

Thread Author Time
Re: insert and query performance on big string table with pg_trgm Jeff Janes 01:42
Re: [PERFORM] POWA doesn't show queries executed phb07 08:00
Re: insert and query performance on big string table with pg_trgm Matthew Hall 08:05
Using GROUPING SETS with more than one set disables predicate pushdown? Zakhar Shapurau 11:04
pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Henrik Cednert (Filmlance) 14:28
Re: Using GROUPING SETS with more than one set disables predicate pushdown? Tom Lane 14:49
Re: [PERFORM] POWA doesn't show queries executed Marco Nietz 15:29
RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Igor Neyman 16:25
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Henrik Cednert (Filmlance) 16:27
RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Igor Neyman 16:34
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Henrik Cednert (Filmlance) 16:37
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Shaul Dar 16:44
RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Igor Neyman 16:44
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Henrik Cednert (Filmlance) 16:48
RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Igor Neyman 16:57
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Tom Lane 17:01
Re: Using GROUPING SETS with more than one set disables predicate pushdown? Andres Freund 18:16
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Robert Haas 18:39
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Tom Lane 18:46
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Henrik Cednert (Filmlance) 18:53
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Henrik Cednert (Filmlance) 18:59
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Tom Lane 21:01

Nov. 22, 2017

Thread Author Time
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Henrik Cednert (Filmlance) 03:48
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Henrik Cednert (Filmlance) 06:18
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Matthew Hall 10:32
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Henrik Cednert (Filmlance) 12:17
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Henrik Cednert (Filmlance) 13:06
Query became very slow after 9.6 -> 10 upgrade Dmitry Shalashov 14:13
RE: Query became very slow after 9.6 -> 10 upgrade Alex Ignatov 14:24
Re: Query became very slow after 9.6 -> 10 upgrade Dmitry Shalashov 14:29
Bad estimates Artur Zając 14:29
RE: Query became very slow after 9.6 -> 10 upgrade Alex Ignatov 14:44
Re: Bad estimates Don Seiler 14:49
Re: Query became very slow after 9.6 -> 10 upgrade Dmitry Shalashov 14:51
Re: Bad estimates (DEFAULT_UNK_SEL) Justin Pryzby 14:57
Re: Bad estimates Tom Lane 15:01
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

Browse Archives

Prev | Next