pgsql-performance since 2017-01-04 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

Jan. 4, 2017

Thread Author Time
Re: Unable to connect to server Andreas Kretschmer 09:12
Re: Unable to connect to server Vucomir Ianculov 11:03
Re: Unable to connect to server Andreas Kretschmer 11:12
Re: Slow query after 9.3 to 9.6 migration Kevin Grittner 14:25

Jan. 5, 2017

Thread Author Time
Re: Slow query after 9.3 to 9.6 migration Merlin Moncure 14:40
Re: Slow query after 9.3 to 9.6 migration Flávio Henrique 16:51
Re: Slow query after 9.3 to 9.6 migration Kevin Grittner 17:10
Re: Slow query after 9.3 to 9.6 migration Daniel Blanch Bataller 17:51
Re: Slow query after 9.3 to 9.6 migration Merlin Moncure 19:01
Re: Slow query after 9.3 to 9.6 migration Filipe Oliveira 21:14

Jan. 6, 2017

Thread Author Time
Re: Slow query after 9.3 to 9.6 migration Michael Paquier 12:51
Re: Slow query after 9.3 to 9.6 migration Filipe Oliveira 18:25
Sort-of replication for reporting purposes Ivan Voras 19:24
Re: Sort-of replication for reporting purposes Scott Marlowe 19:30
Re: Sort-of replication for reporting purposes Ivan Voras 19:33
Re: Sort-of replication for reporting purposes Rick Otten 19:33
Re: Sort-of replication for reporting purposes Stephen Frost 19:43

Jan. 12, 2017

Thread Author Time
How can I find the source of postgresql per-connection memory leaks? Eric Jensen 17:08
Re: How can I find the source of postgresql per-connection memory leaks? Joshua D. Drake 17:18
Re: Sort-of replication for reporting purposes ProPAAS DBA 17:48

Jan. 13, 2017

Thread Author Time
Re: Sort-of replication for reporting purposes Stuart Bishop 11:00
Re: Sort-of replication for reporting purposes Ivan Voras 11:17
Re: Sort-of replication for reporting purposes 📎 Phillip Couto 11:47
Re: Sort-of replication for reporting purposes Stuart Bishop 11:48

Jan. 16, 2017

Thread Author Time
out of range error while restore using pgdump Samir Magar 09:20
Re: out of range error while restore using pgdump Tom Lane 15:30

Jan. 18, 2017

Thread Author Time
optimizing immutable vs. stable function calls? Karl Czajkowski 22:36
Re: optimizing immutable vs. stable function calls? Tom Lane 22:54
Re: optimizing immutable vs. stable function calls? Karl Czajkowski 23:06
Re: optimizing immutable vs. stable function calls? David G. Johnston 23:06
Re: optimizing immutable vs. stable function calls? Tom Lane 23:23
Re: optimizing immutable vs. stable function calls? Tom Lane 23:25

Jan. 19, 2017

Thread Author Time
Re: optimizing immutable vs. stable function calls? David G. Johnston 00:09
Re: optimizing immutable vs. stable function calls? Karl Czajkowski 02:45
Optimization inner join Clailson 10:08
Re: Optimization inner join Phillip Couto 12:34
Re: Optimization inner join Clailson 13:04
Re: Optimization inner join Phillip Couto 13:18
Re: Optimization inner join Gustavo Rezende Montesino 13:23
Re: Optimization inner join Vitalii Tymchyshyn 13:30
Re: Optimization inner join Phillip Couto 13:46
Re: Optimization inner join Tom Lane 14:13
Re: Optimization inner join Phillip Couto 14:15
Chaotic query planning ? Philippe Ivaldi 14:37
Re: Optimization inner join Gustavo Rezende Montesino 14:45
Re: Chaotic query planning ? Albe Laurenz 16:05

Jan. 20, 2017

Thread Author Time
Backup taking long time !!! Dinesh Chandra 12108 11:24
Re: Backup taking long time !!! Madusudanan.B.N 11:34
Re: Backup taking long time !!! Dinesh Chandra 12108 11:43
Re: Backup taking long time !!! Pavel Stehule 11:48
Re: Backup taking long time !!! Madusudanan.B.N 11:52
Re: Backup taking long time !!! Dinesh Chandra 12108 11:53
Re: Backup taking long time !!! Pavel Stehule 11:55
Re: Backup taking long time !!! Stephen Frost 12:22
Re: Backup taking long time !!! Vladimir Borodin 12:57
Re: Backup taking long time !!! Stephen Frost 13:40
Re: Backup taking long time !!! Vladimir Borodin 14:45
Re: Backup taking long time !!! Stephen Frost 15:06
Re: Backup taking long time !!! Vladimir Borodin 16:44
Re: Backup taking long time !!! Stephen Frost 16:59

Jan. 22, 2017

Thread Author Time
Re: Backup taking long time !!! julyanto SUTANDANG 13:20
Re: Backup taking long time !!! julyanto SUTANDANG 13:36
Re: Backup taking long time !!! Stephen Frost 14:55
Re: Backup taking long time !!! Stephen Frost 14:57
Re: Backup taking long time !!! julyanto SUTANDANG 16:04
Re: Backup taking long time !!! Stephen Frost 16:37
Re: Backup taking long time !!! julyanto SUTANDANG 17:03
Re: Backup taking long time !!! Stephen Frost 17:32
Re: Backup taking long time !!! julyanto SUTANDANG 17:56

Jan. 23, 2017

Thread Author Time
Re: Backup taking long time !!! Vladimir Borodin 06:44
Re: Backup taking long time !!! Stephen Frost 06:48
Re: Backup taking long time !!! Torsten Zuehlsdorff 08:31
Re: optimizing immutable vs. stable function calls? Jim Nasby 15:10
Re: Backup taking long time !!! Jim Nasby 15:16
Re: Backup taking long time !!! Stephen Frost 15:27
Re: Backup taking long time !!! Jim Nasby 15:28
Re: Backup taking long time !!! Jim Nasby 15:31
performance contradiction Gabriel Dodan 16:55
Re: Backup taking long time !!! Jeff Janes 17:12
Re: Backup taking long time !!! Stephen Frost 17:20
Re: Backup taking long time !!! Stephen Frost 17:23
Re: Backup taking long time !!! Jeff Janes 17:32
Re: Backup taking long time !!! Simon Riggs 17:43
Re: Backup taking long time !!! Stephen Frost 17:47
Re: Backup taking long time !!! Stephen Frost 17:49

Jan. 24, 2017

Thread Author Time
Re: Backup taking long time !!! julyanto SUTANDANG 00:08
Re: optimizing immutable vs. stable function calls? Merlin Moncure 00:08
Re: Backup taking long time !!! Jeff Janes 15:55
Re: Backup taking long time !!! Rick Otten 16:15
Re: Backup taking long time !!! Stephen Frost 16:39

Jan. 25, 2017

Thread Author Time
pgsql connection timeone Vucomir Ianculov 09:23
Re: pgsql connection timeone Vucomir Ianculov 09:44
Re: pgsql connection timeone Tom Lane 13:15

Jan. 28, 2017

Thread Author Time
Re: pgsql connection timeone Vucomir Ianculov 10:03

Jan. 30, 2017

Thread Author Time
Re: Chaotic query planning ? Philippe Ivaldi 08:24

Jan. 31, 2017

Thread Author Time
Re: Backup taking long time !!! David Steele 15:20

Feb. 1, 2017

Thread Author Time
PSA: upgrade your extensions Merlin Moncure 12:38
Re: pgsql connection timeone Vucomir Ianculov 12:51
Re: PSA: upgrade your extensions Daniel Blanch Bataller 15:18
Re: pgsql connection timeone Vitalii Tymchyshyn 17:11
Re: PSA: upgrade your extensions Jeff Janes 19:48

Feb. 2, 2017

Thread Author Time
Re: PSA: upgrade your extensions Merlin Moncure 12:24

Feb. 3, 2017

Thread Author Time
strange and slow joining of nested views Titus von Boxberg 21:23

Feb. 4, 2017

Thread Author Time
Re: strange and slow joining of nested views Tom Lane 05:16
Re: pgsql connection timeone Vucomir Ianculov 16:45
Re: pgsql connection timeone Vitalii Tymchyshyn 18:38
Re: strange and slow joining of nested views Titus von Boxberg 20:20

Feb. 9, 2017

Thread Author Time
Inaccurate GiST Index Cost Causes DB Contention PC Drew 18:48

Feb. 15, 2017

Thread Author Time
Re: performance contradiction Feike Steenbergen 08:25

Feb. 17, 2017

Thread Author Time
Correct use of cursors for very large result sets in Postgres Mike Beaton 07:59
Re: Correct use of cursors for very large result sets in Postgres Mike Beaton 12:04
Re: Correct use of cursors for very large result sets in Postgres Tom Lane 16:39
Re: pgsql connection timeone Vucomir Ianculov 16:52
Number of characters in column preventing index usage Hustler DBA 22:19
Re: Number of characters in column preventing index usage David G. Johnston 22:42
Re: Number of characters in column preventing index usage Tomas Vondra 22:49
Re: Number of characters in column preventing index usage Alvaro Herrera 22:51
Re: Number of characters in column preventing index usage Tomas Vondra 22:52
Re: Number of characters in column preventing index usage Hustler DBA 23:16
Re: Number of characters in column preventing index usage David G. Johnston 23:19

Feb. 18, 2017

Thread Author Time
Re: Number of characters in column preventing index usage Tom Lane 00:04
Re: Number of characters in column preventing index usage Hustler DBA 00:16
Re: Correct use of cursors for very large result sets in Postgres Mike Beaton 07:57
Re: Correct use of cursors for very large result sets in Postgres Mike Beaton 08:46
Re: Correct use of cursors for very large result sets in Postgres Tom Lane 17:43

Feb. 19, 2017

Thread Author Time
Re: Correct use of cursors for very large result sets in Postgres Mike Beaton 07:54

Feb. 20, 2017

Thread Author Time
Query Performance Diego Vargas 21:39

Feb. 21, 2017

Thread Author Time
Re: Correct use of cursors for very large result sets in Postgres Mike Beaton 12:36
Re: Correct use of cursors for very large result sets in Postgres Tom Lane 13:32
Re: Correct use of cursors for very large result sets in Postgres Mike Beaton 13:49
Suggestions for a HBA controller (6 x SSDs + madam RAID10) Pietro Pugni 13:49
Re: Correct use of cursors for very large result sets in Postgres John Gorman 14:06
Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10) Merlin Moncure 15:04
Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10) Wes Vaske (wvaske) 19:40
Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10) Merlin Moncure 20:01
Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10) Scott Marlowe 20:09
Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10) Wes Vaske (wvaske) 21:50
Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10) Pietro Pugni 23:18
Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10) Pietro Pugni 23:44
Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10) Pietro Pugni 23:46

Feb. 22, 2017

Thread Author Time
Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10) Wes Vaske (wvaske) 15:36

Feb. 23, 2017

Thread Author Time
Re: Correct use of cursors for very large result sets in Postgres Vitalii Tymchyshyn 03:13
Re: Correct use of cursors for very large result sets in Postgres John Gorman 12:47
Query performance changes significantly depending on limit value Rowan Seymour 13:11
Re: Query performance changes significantly depending on limit value Pavel Stehule 13:32
Re: Query performance changes significantly depending on limit value Rowan Seymour 14:02
Re: Query performance changes significantly depending on limit value Pavel Stehule 15:35
How to log quires which are taking time in PostgreSQL 9.1. Dinesh Chandra 12108 16:21
Re: How to log quires which are taking time in PostgreSQL 9.1. ProPAAS DBA 16:30
Re: How to log quires which are taking time in PostgreSQL 9.1. Dinesh Chandra 12108 16:44
Re: Query performance changes significantly depending on limit value Rowan Seymour 16:45
Re: How to log quires which are taking time in PostgreSQL 9.1. Luis Fernando Simone 16:59
Re: Query performance changes significantly depending on limit value Pavel Stehule 17:13
Re: How to log quires which are taking time in PostgreSQL 9.1. Dinesh Chandra 12108 17:21

Feb. 26, 2017

Thread Author Time
Speeding up JSON + TSQUERY + GIN Sven R. Kunze 13:28
Re: Speeding up JSON + TSQUERY + GIN Oleg Bartunov 20:13

Feb. 27, 2017

Thread Author Time
How Can I check PostgreSQL backup is successfully or not ? Dinesh Chandra 12108 09:35
Re: How Can I check PostgreSQL backup is successfully or not ? Rick Otten 10:36
Re: How Can I check PostgreSQL backup is successfully or not ? John Gorman 13:29
Re: How Can I check PostgreSQL backup is successfully or not ? vinny 14:00
Re: How Can I check PostgreSQL backup is successfully or not ? Dinesh Chandra 12108 14:10
Re: Speeding up JSON + TSQUERY + GIN Sven R. Kunze 14:46
Re: Speeding up JSON + TSQUERY + GIN Jeff Janes 18:22

Feb. 28, 2017

Thread Author Time
Re: Speeding up JSON + TSQUERY + GIN Sven R. Kunze 08:27
Re: Speeding up JSON + TSQUERY + GIN Jeff Janes 16:49

March 1, 2017

Thread Author Time
Re: Speeding up JSON + TSQUERY + GIN Sven R. Kunze 14:02
Re: Speeding up JSON + TSQUERY + GIN Jeff Janes 17:04
anti-join with small table via text/varchar cannot estimate rows correctly Stefan Andreatta 22:00
Re: anti-join with small table via text/varchar cannot estimate rows correctly David G. Johnston 22:12

March 2, 2017

Thread Author Time
Re: anti-join with small table via text/varchar cannot estimate rows correctly Jeff Janes 00:24
Re: anti-join with small table via text/varchar cannot estimate rows correctly David G. Johnston 00:28
Re: anti-join with small table via text/varchar cannot estimate rows correctly Tom Lane 01:06
Re: anti-join with small table via text/varchar cannot estimate rows correctly Stefan Andreatta 05:14
Re: How Can I check PostgreSQL backup is successfully or not ? Dinesh Chandra 12108 12:05
Re: How Can I check PostgreSQL backup is successfully or not ? Rick Otten 13:14
Re: How Can I check PostgreSQL backup is successfully or not ? Dinesh Chandra 12108 13:19
Re: How Can I check PostgreSQL backup is successfully or not ? [email protected] 16:26
Re: How Can I check PostgreSQL backup is successfully or not ? Dinesh Chandra 12108 16:32
Re: How Can I check PostgreSQL backup is successfully or not ? Gustavo Vargas 16:50
Re: Speeding up JSON + TSQUERY + GIN Sven R. Kunze 21:19
Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10) Pietro Pugni 21:51

March 3, 2017

Thread Author Time
Performance issue in PostgreSQL server... Dinesh Chandra 12108 10:29
Re: Performance issue in PostgreSQL server... Nur Agus 12:23
Re: Performance issue in PostgreSQL server... Dinesh Chandra 12108 12:44
Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10) Merlin Moncure 15:03
Re: Performance issue in PostgreSQL server... Tom Lane 15:19

March 6, 2017

Thread Author Time
Re: Performance issue in PostgreSQL server... Jeff Janes 04:23
Re: Speeding up JSON + TSQUERY + GIN Jeff Janes 04:25
Re: Performance issue in PostgreSQL server... Justin Pryzby 05:24
Re: Performance issue in PostgreSQL server... Dinesh Chandra 12108 12:17
Performance issue after upgrading from 9.4 to 9.6 Piotr Gasidło 13:20
Huge difference between ASC and DESC ordering twoflower 14:22
Re: Huge difference between ASC and DESC ordering Jeff Janes 16:19
Re: Huge difference between ASC and DESC ordering twoflower 16:46
Re: Huge difference between ASC and DESC ordering Jeff Janes 17:11
Re: Speeding up JSON + TSQUERY + GIN Sven R. Kunze 21:10

March 7, 2017

Thread Author Time
Re: Huge difference between ASC and DESC ordering twoflower 08:40

March 8, 2017

Thread Author Time
Please help with a slow query: there are millions of records, what can we do? Pat Maddox 02:26
Re: Please help with a slow query: there are millions of records, what can we do? Albe Laurenz 10:05
Re: Please help with a slow query: there are millions of records, what can we do? Jeff Janes 18:00

Browse Archives

Prev | Next