pgsql-performance - February 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)

Browse Archives

Prev | Next

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

Browse Archives

Prev | Next