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

March 20, 2017

Thread Author Time
Auto generate number in Postgres-9.1. Dinesh Chandra 12108 13:38
Re: Auto generate number in Postgres-9.1. Josh Berkus 13:43
Re: Auto generate number in Postgres-9.1. Andreas Karlsson 13:48
Re: Auto generate number in Postgres-9.1. John Gorman 13:50
Re: Auto generate number in Postgres-9.1. Dinesh Chandra 12108 14:08
Re: Auto generate number in Postgres-9.1. Andreas Karlsson 15:40

March 21, 2017

Thread Author Time
Optimizing around retained tuples James Parks 19:24

March 22, 2017

Thread Author Time
Re: Optimizing around retained tuples Claudio Freire 01:56
Re: Optimizing around retained tuples Claudio Freire 01:58
Re: Please help with a slow query: there are millions of records, what can we do? Pat Maddox 15:07

March 24, 2017

Thread Author Time
Postgres not using all RAM (Huge Page activated on a 96GB RAM system) Pietro Pugni 09:58
Re: Postgres not using all RAM (Huge Page activated on a 96GB RAM system) Andrew Kerber 14:00
Re: Optimizing around retained tuples Brad DeJong 16:00
Re: Postgres not using all RAM (Huge Page activated on a 96GB RAM system) Scott Marlowe 19:47
Re: Postgres not using all RAM (Huge Page activated on a 96GB RAM system) Álvaro Hernández Tortosa 20:16

March 25, 2017

Thread Author Time
Re: Postgres not using all RAM (Huge Page activated on a 96GB RAM system) Shaun Thomas 01:27
Re: Postgres not using all RAM (Huge Page activated on a 96GB RAM system) trafdev 01:56

March 26, 2017

Thread Author Time
self join estimate and constraint exclusion Justin Pryzby 19:33

March 27, 2017

Thread Author Time
Re: Performance issue after upgrading from 9.4 to 9.6 Merlin Moncure 13:21
Re: Postgres not using all RAM (Huge Page activated on a 96GB RAM system) Merlin Moncure 13:27
Best design for performance Riaan Stander 23:43

March 28, 2017

Thread Author Time
Re: Best design for performance Claudio Freire 00:42
Re: Best design for performance Riaan Stander 01:17
Re: Best design for performance Claudio Freire 02:22
Re: Best design for performance Riaan Stander 12:41
Re: Best design for performance Claudio Freire 17:15
Re: Best design for performance Riaan Stander 22:51

April 4, 2017

Thread Author Time
Delete, foreign key, index usage Johann Spies 12:07

April 5, 2017

Thread Author Time
Re: Delete, foreign key, index usage Johann Spies 10:40
Re: Delete, foreign key, index usage Rick Otten 11:15
How to send content of log file in official mailid. Dinesh Chandra 12108 16:53
Table not using tsvector gin index and performance much worse than when it uses it. rverghese 22:51
Re: Table not using tsvector gin index and performance much worse than when it uses it. Tom Lane 23:19
Re: Table not using tsvector gin index and performance much worse than when it uses it. rverghese 23:54

April 6, 2017

Thread Author Time
Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it. Sfiligoi, Igor 00:09
Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it. rverghese 00:26
Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it. Tom Lane 01:08
Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it. rverghese 01:10

April 7, 2017

Thread Author Time
Filter certain range of IP address. Dinesh Chandra 12108 14:13
Re: Filter certain range of IP address. vinny 14:22
Understanding PostgreSQL query execution time Haider Ali 14:56
Re: Understanding PostgreSQL query execution time [email protected] 15:03
Re: Understanding PostgreSQL query execution time Gerardo Herzig 15:15
Re: Filter certain range of IP address. Dinesh Chandra 12108 15:18
Re: Filter certain range of IP address. David G. Johnston 15:29
Re: Filter certain range of IP address. Rick Otten 15:56
Re: Filter certain range of IP address. Dinesh Chandra 12108 16:09
Re: Filter certain range of IP address. 📎 Moreno Andreo 16:20

April 10, 2017

Thread Author Time
Re: Filter certain range of IP address. vinny 11:33
Re: Understanding PostgreSQL query execution time vinny 12:18

April 13, 2017

Thread Author Time
Hi Daulat Ram 06:25
Re: Hi Glyn Astill 08:21
Postgresql, and ODBC handles Reza Taheri 19:30
Impact of track_activity_query_size on high traffic OLTP system Jeremy Finzel 20:45
Re: Impact of track_activity_query_size on high traffic OLTP system Rick Otten 21:17

April 14, 2017

Thread Author Time
Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow Hans Braxmeier 23:30
Re: Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow Tom Lane 23:40

April 15, 2017

Thread Author Time
self join estimate and constraint exclusion Justin Pryzby 00:23
Restoring Postgres Dump is very slow with Ubuntu 16.04 Hans Braxmeier 08:11
Re: Restoring Postgres Dump is very slow with Ubuntu 16.04 Andreas Kretschmer 13:59

April 17, 2017

Thread Author Time
Create a materialized view in PostgreSQL which can be access by all the user account Dinesh Chandra 12108 17:00
Re: Create a materialized view in PostgreSQL which can be access by all the user account David G. Johnston 17:12

April 18, 2017

Thread Author Time
Insert Concurrency ROBERT PRICE 02:55
Re: Insert Concurrency David Rowley 05:41
Re: Insert Concurrency Daniel Blanch Bataller 05:45
Re: Insert Concurrency Claudio Freire 15:29
Re: Insert Concurrency Scott Marlowe 15:41
Re: Insert Concurrency David McKelvie 15:49
Re: Insert Concurrency ROBERT PRICE 16:29

Browse Archives

Prev | Next