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.
| 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 |
| 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 |
| Thread | Author | Time |
|---|---|---|
| Re: pgsql connection timeone | Vucomir Ianculov | 10:03 |
| Thread | Author | Time |
|---|---|---|
| Re: Chaotic query planning ? | Philippe Ivaldi | 08:24 |
| Thread | Author | Time |
|---|---|---|
| Re: Backup taking long time !!! | David Steele | 15:20 |
| 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 |
| Thread | Author | Time |
|---|---|---|
| Re: PSA: upgrade your extensions | Merlin Moncure | 12:24 |
| Thread | Author | Time |
|---|---|---|
| strange and slow joining of nested views | Titus von Boxberg | 21:23 |
| 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 |
| Thread | Author | Time |
|---|---|---|
| Inaccurate GiST Index Cost Causes DB Contention | PC Drew | 18:48 |
| Thread | Author | Time |
|---|---|---|
| Re: performance contradiction | Feike Steenbergen | 08:25 |
| 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 |
| 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 |
| Thread | Author | Time |
|---|---|---|
| Re: Correct use of cursors for very large result sets in Postgres | Mike Beaton | 07:54 |
| Thread | Author | Time |
|---|---|---|
| Query Performance | Diego Vargas | 21:39 |
| Thread | Author | Time |
|---|---|---|
| Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10) | Wes Vaske (wvaske) | 15:36 |
| Thread | Author | Time |
|---|---|---|
| Speeding up JSON + TSQUERY + GIN | Sven R. Kunze | 13:28 |
| Re: Speeding up JSON + TSQUERY + GIN | Oleg Bartunov | 20:13 |
| 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 |
| Thread | Author | Time |
|---|---|---|
| Re: Speeding up JSON + TSQUERY + GIN | Sven R. Kunze | 08:27 |
| Re: Speeding up JSON + TSQUERY + GIN | Jeff Janes | 16:49 |
| 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 |
| 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 |
| 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 |
| Thread | Author | Time |
|---|---|---|
| Re: Huge difference between ASC and DESC ordering | twoflower | 08:40 |
| 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 |
| 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 |
| Thread | Author | Time |
|---|---|---|
| Optimizing around retained tuples | James Parks | 19:24 |
| 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 |
| 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 |
| 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 |
| Thread | Author | Time |
|---|---|---|
| self join estimate and constraint exclusion | Justin Pryzby | 19:33 |
| 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 |
| 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 |
| Thread | Author | Time |
|---|---|---|
| Delete, foreign key, index usage | Johann Spies | 12:07 |
| 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 |
| 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 |
| Thread | Author | Time |
|---|---|---|
| Re: Filter certain range of IP address. | vinny | 11:33 |
| Re: Understanding PostgreSQL query execution time | vinny | 12:18 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| update from performance question | Armand Pirvu (home) | 21:46 |
| Thread | Author | Time |
|---|---|---|
| Re: update from performance question | Albe Laurenz | 08:06 |
| Re: update from performance question | Armand Pirvu (home) | 23:11 |
| Thread | Author | Time |
|---|---|---|
| Query with no result set, really really slow adding ORBDER BY / LIMIT clause | Marco Renzi | 07:19 |
| Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause | Marco Renzi | 11:16 |
| Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause | vinny | 11:54 |
| Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause | Marco Renzi | 12:16 |
| Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause | Pavel Stehule | 15:57 |
| Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause | Pavel Stehule | 16:05 |
| Thread | Author | Time |
|---|---|---|
| Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause | Marco Renzi | 06:49 |
| Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause | Pavel Stehule | 06:56 |
| Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause | Marco Renzi | 07:05 |
| Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause | Pavel Stehule | 07:12 |
| Thread | Author | Time |
|---|---|---|
| Re: Delete, foreign key, index usage | Johann Spies | 06:48 |
| Re: Delete, foreign key, index usage | Tomas Vondra | 13:17 |
| Thread | Author | Time |
|---|---|---|
| Questionaire: Common WAL write rates on busy servers. | Andres Freund | 04:17 |