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: proposal: schema variables | Pavel Stehule | 04:15 |
| Re: proposal: schema variables | Serge Rielau | 05:07 |
| Re: proposal: schema variables | Pavel Stehule | 05:56 |
| Re: Cursor vs Set Operation | Merlin Moncure | 16:28 |
| Re: proposal: schema variables | Mark Dilger | 18:03 |
| Re: proposal: schema variables | Pavel Stehule | 19:19 |
| Re: proposal: schema variables | Gilles Darold | 22:13 |
| Thread | Author | Time |
|---|---|---|
| Unnecessary DISTINCT while primary key in SQL | 刘瑞 | 15:20 |
| Thread | Author | Time |
|---|---|---|
| Re: Unnecessary DISTINCT while primary key in SQL | David Rowley | 00:34 |
| Performance loss upgrading from 9.3 to 9.6 | Adam Torres | 13:18 |
| Re: Performance loss upgrading from 9.3 to 9.6 | Justin Pryzby | 14:21 |
| Re: Index-Advisor Tools | Baron Schwartz | 18:52 |
| Dynamic performance issues 📎 | Arne Roland | 20:05 |
| Re: Performance loss upgrading from 9.3 to 9.6 | Adam Torres | 21:12 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance loss upgrading from 9.3 to 9.6 | Adam Brusselback | 02:59 |
| Re: Performance loss upgrading from 9.3 to 9.6 | Justin Pryzby | 05:11 |
| Slow execution of SET ROLE, SET search_path and RESET ROLE | Ulf Lohbrügge | 10:11 |
| Re: Slow execution of SET ROLE, SET search_path and RESET ROLE | Andres Freund | 15:11 |
| Re: Slow execution of SET ROLE, SET search_path and RESET ROLE | Ulf Lohbrügge | 17:48 |
| Re: Slow execution of SET ROLE, SET search_path and RESET ROLE | Andres Freund | 19:45 |
| Re: Slow execution of SET ROLE, SET search_path and RESET ROLE | Ulf Lohbrügge | 21:25 |
| Re: Slow execution of SET ROLE, SET search_path and RESET ROLE | Scott Marlowe | 21:39 |
| Re: Slow execution of SET ROLE, SET search_path and RESET ROLE | Ulf Lohbrügge | 23:04 |
| Re: Slow execution of SET ROLE, SET search_path and RESET ROLE | Tom Lane | 23:45 |
| Thread | Author | Time |
|---|---|---|
| Re: Slow execution of SET ROLE, SET search_path and RESET ROLE | Ulf Lohbrügge | 09:31 |
| Thread | Author | Time |
|---|---|---|
| DB slowness after upgrade from Postgres 9.1 to 9.4 | p kirti | 10:58 |
| overestimate on empty table | Justin Pryzby | 20:40 |
| Re: overestimate on empty table | Tom Lane | 21:19 |
| Thread | Author | Time |
|---|---|---|
| Re: overestimate on empty table | Justin Pryzby | 17:19 |
| Re: overestimate on empty table | Tom Lane | 17:43 |
| Thread | Author | Time |
|---|---|---|
| Re: DB slowness after upgrade from Postgres 9.1 to 9.4 | Tom Lane | 19:37 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables | Pavel Golub | 12:15 |
| Re: proposal: schema variables | Pavel Stehule | 12:30 |
| Query planner gaining the ability to replanning after start of query execution. | Oliver Mattos | 16:44 |
| Re: Query planner gaining the ability to replanning after start of query execution. | Arne Roland | 20:06 |
| Re: Query planner gaining the ability to replanning after start of query execution. | Oliver Mattos | 21:51 |
| Re: Query planner gaining the ability to replanning after start of query execution. | Arne Roland | 22:48 |
| Re: Query planner gaining the ability to replanning after start of query execution. | Tom Lane | 22:49 |
| Re: Query planner gaining the ability to replanning after start of query execution. | Oliver Mattos | 23:20 |
| Thread | Author | Time |
|---|---|---|
| Re: Query planner gaining the ability to replanning after start of query execution. | legrand legrand | 21:26 |
| 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 |
| Thread | Author | Time |
|---|---|---|
| POWA doesn't show queries executed | Neto pr | 01:52 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| Thread | Author | Time |
|---|---|---|
| Bad plan chosen for union all | Alex Reece | 10:13 |
| Invalid mem alloc request on function | bima p | 18:56 |
| 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 |
| Thread | Author | Time |
|---|---|---|
| CREATE TABLE vs CREATE MATERIALIZED VIEW | Caio Guimarães Figueiredo | 12:07 |