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 |
|---|---|---|
| hint in determining effective_io_concurrency | Luca Ferrari | 19:45 |
| Re: hint in determining effective_io_concurrency | Bruce Momjian | 19:52 |
| Re: hint in determining effective_io_concurrency | Luca Ferrari | 19:54 |
| Re: hint in determining effective_io_concurrency | Bruce Momjian | 19:58 |
| Re: hint in determining effective_io_concurrency | Justin Pryzby | 20:15 |
| Re: hint in determining effective_io_concurrency | Luca Ferrari | 20:22 |
| Re: hint in determining effective_io_concurrency | Justin Pryzby | 20:27 |
| Re: hint in determining effective_io_concurrency | Bruce Momjian | 20:51 |
| Thread | Author | Time |
|---|---|---|
| Re: [PATCH] force_parallel_mode and GUC categories | Justin Pryzby | 18:23 |
| Thread | Author | Time |
|---|---|---|
| Re: [PATCH] force_parallel_mode and GUC categories | Michael Paquier | 01:50 |
| Re: [PATCH] force_parallel_mode and GUC categories | Justin Pryzby | 02:57 |
| Does btrfs on Linux have a negative performance impact for PostgreSQL 13? | Simon Connah | 18:27 |
| Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? | Justin Pryzby | 18:45 |
| Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? | Bruce Momjian | 19:00 |
| Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? | Christophe Pettus | 19:02 |
| Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? | Tomas Vondra | 19:52 |
| Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? | Rory Campbell-Lange | 20:03 |
| Thread | Author | Time |
|---|---|---|
| Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? | Simon Connah | 08:29 |
| Thread | Author | Time |
|---|---|---|
| Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? | Marc Millas | 12:47 |
| Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? | Rory Campbell-Lange | 13:43 |
| Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? | Marc Millas | 16:30 |
| Thread | Author | Time |
|---|---|---|
| Order of execution | luis.roberto | 18:52 |
| Re: Order of execution | Jean-Christophe Boggio | 19:49 |
| Thread | Author | Time |
|---|---|---|
| Re: [PATCH] force_parallel_mode and GUC categories | Justin Pryzby | 04:24 |
| Error while calling proc with table type from Application | aditya desai | 09:22 |
| Re: Error while calling proc with table type from Application (npgsql) | Justin Pryzby | 13:02 |
| Log number of tuples returned | Edson Richter | 15:01 |
| Re: Log number of tuples returned | Justin Pryzby | 15:08 |
| RES: Log number of tuples returned | Edson Richter | 15:31 |
| Thread | Author | Time |
|---|---|---|
| Re: Error while calling proc with table type from Application (npgsql) | aditya desai | 13:02 |
| Re: Error while calling proc with table type from Application (npgsql) | aditya desai | 13:22 |
| Re: Error while calling proc with table type from Application (npgsql) | Vijaykumar Jain | 17:43 |
| Thread | Author | Time |
|---|---|---|
| 15x slower PreparedStatement vs raw query | Alex | 19:45 |
| Thread | Author | Time |
|---|---|---|
| Re: 15x slower PreparedStatement vs raw query | Justin Pryzby | 20:18 |
| Thread | Author | Time |
|---|---|---|
| Re: 15x slower PreparedStatement vs raw query | Alex | 09:21 |
| Re: 15x slower PreparedStatement vs raw query | Rick Otten | 12:12 |
| Re: 15x slower PreparedStatement vs raw query | Alex | 13:59 |
| Re: 15x slower PreparedStatement vs raw query | Laurenz Albe | 15:22 |
| Re: 15x slower PreparedStatement vs raw query | Vijaykumar Jain | 15:50 |
| Thread | Author | Time |
|---|---|---|
| Re: 15x slower PreparedStatement vs raw query | David Rowley | 06:57 |
| Re: 15x slower PreparedStatement vs raw query | Justin Pryzby | 06:59 |
| Re: 15x slower PreparedStatement vs raw query | Alex | 15:21 |
| Thread | Author | Time |
|---|---|---|
| Very slow Query compared to Oracle / SQL - Server | Semen Yefimenko | 14:38 |
| Re: Very slow Query compared to Oracle / SQL - Server | luis.roberto | 16:11 |
| Re: Very slow Query compared to Oracle / SQL - Server | Alexey M Boltenkov | 18:15 |
| Re: Very slow Query compared to Oracle / SQL - Server | Alexey M Boltenkov | 18:20 |
| Re: Very slow Query compared to Oracle / SQL - Server | Semen Yefimenko | 18:59 |
| Re: Very slow Query compared to Oracle / SQL - Server | Andreas Joseph Krogh | 19:26 |
| Re: Very slow Query compared to Oracle / SQL - Server | Vijaykumar Jain | 19:48 |
| Re: Very slow Query compared to Oracle / SQL - Server 📎 | Alexey M Boltenkov | 19:58 |
| Re: Very slow Query compared to Oracle / SQL - Server | Justin Pryzby | 20:01 |
| Re: Very slow Query compared to Oracle / SQL - Server | Alexey M Boltenkov | 20:02 |
| Re: Very slow Query compared to Oracle / SQL - Server | Alexey M Boltenkov | 20:17 |
| Re: Very slow Query compared to Oracle / SQL - Server | Imre Samu | 21:16 |
| Thread | Author | Time |
|---|---|---|
| Re: Very slow Query compared to Oracle / SQL - Server | Semen Yefimenko | 08:04 |
| Re: Very slow Query compared to Oracle / SQL - Server | Vijaykumar Jain | 08:44 |
| Re: Very slow Query compared to Oracle / SQL - Server | Semen Yefimenko | 09:02 |
| Re: Very slow Query compared to Oracle / SQL - Server | Vijaykumar Jain | 09:55 |
| Re: Very slow Query compared to Oracle / SQL - Server | Rick Otten | 12:50 |
| Re: Very slow Query compared to Oracle / SQL - Server | Semen Yefimenko | 15:57 |
| Re: Very slow Query compared to Oracle / SQL - Server | Justin Pryzby | 16:15 |
| Re: Very slow Query compared to Oracle / SQL - Server | Tom Lane | 16:28 |
| Re: Very slow Query compared to Oracle / SQL - Server | Peter Geoghegan | 21:28 |
| Re: Very slow Query compared to Oracle / SQL - Server | Peter Geoghegan | 21:43 |
| Re: Very slow Query compared to Oracle / SQL - Server | didier | 22:17 |
| Thread | Author | Time |
|---|---|---|
| Re: Very slow Query compared to Oracle / SQL - Server | Semen Yefimenko | 12:06 |
| Re: [PATCH] force_parallel_mode and GUC categories | Tom Lane | 16:39 |
| Thread | Author | Time |
|---|---|---|
| Re: Very slow Query compared to Oracle / SQL - Server | Semen Yefimenko | 11:14 |
| Thread | Author | Time |
|---|---|---|
| Re: BUG #16968: Planner does not recognize optimization | Eugen Konkov | 13:35 |
| PostgreSQL blocked locks query | Manoj Kumar | 13:54 |
| Re: PostgreSQL blocked locks query | Justin Pryzby | 20:09 |
| Re: BUG #16968: Planner does not recognize optimization | David Rowley | 23:52 |
| Thread | Author | Time |
|---|---|---|
| RE: Re: PostgreSQL blocked locks query | Manoj Kumar | 06:51 |
| Very slow "bloat query" | Marcin Gozdalik | 11:06 |
| Re: Very slow "bloat query" | Gilles Darold | 11:50 |
| Re: Very slow "bloat query" | Imre Samu | 12:07 |
| Re: Very slow "bloat query" | Marcin Gozdalik | 12:11 |
| Re: BUG #16968: Planner does not recognize optimization 📎 | KES | 12:39 |
| Re: Very slow "bloat query" | Tom Lane | 15:04 |
| Re: Very slow "bloat query" | Marcin Gozdalik | 15:15 |
| Re: Very slow "bloat query" | Imre Samu | 15:44 |
| Re: Very slow "bloat query" | Marcin Gozdalik | 15:47 |
| Thread | Author | Time |
|---|---|---|
| Re: BUG #16968: Planner does not recognize optimization 📎 | Eugen Konkov | 14:34 |
| Re: BUG #16968: Planner does not recognize optimization | David Rowley | 14:52 |
| Re: BUG #16968: Planner does not recognize optimization | David Rowley | 14:59 |
| Re: BUG #16968: Planner does not recognize optimization | Eugen Konkov | 16:10 |
| Re: BUG #16968: Planner does not recognize optimization | Eugen Konkov | 16:10 |
| Thread | Author | Time |
|---|---|---|
| Index and statistics not used | rstander | 20:42 |
| Re: Index and statistics not used | David Rowley | 22:31 |
| Thread | Author | Time |
|---|---|---|
| Re: Partition with check constraint with "like" | David Rowley | 01:38 |
| Re: Partition with check constraint with "like" | David Rowley | 01:38 |
| RE: Partition with check constraint with "like" | Michel SALAIS | 05:41 |
| Thread | Author | Time |
|---|---|---|
| transaction blocking on COMMIT | Bob Jolliffe | 11:30 |
| Re: transaction blocking on COMMIT | Vijaykumar Jain | 11:35 |
| Optimising outer joins in the presence of non-nullable references 📎 | Philip Lykke Carlsen | 12:10 |
| Re: transaction blocking on COMMIT | Bob Jolliffe | 13:52 |
| Re: transaction blocking on COMMIT | Vijaykumar Jain | 14:09 |
| Re: Optimising outer joins in the presence of non-nullable references | Tom Lane | 14:11 |
| Re: transaction blocking on COMMIT | Bob Jolliffe | 16:22 |
| Re: transaction blocking on COMMIT | Christophe Pettus | 16:24 |
| Re: transaction blocking on COMMIT | Alexey M Boltenkov | 21:59 |
| Thread | Author | Time |
|---|---|---|
| issue partition scan | Nagaraj Raj | 22:50 |
| Re: issue partition scan | Christophe Pettus | 23:01 |
| Re: issue partition scan | Nagaraj Raj | 23:38 |
| Thread | Author | Time |
|---|---|---|
| Re: issue partition scan | David Rowley | 00:16 |
| Re: issue partition scan | Christophe Pettus | 00:27 |
| Thread | Author | Time |
|---|---|---|
| Count (select 1) subquery as constant | Eugen Konkov | 10:37 |
| Re: transaction blocking on COMMIT | Bob Jolliffe | 13:08 |
| Thread | Author | Time |
|---|---|---|
| Re: AWS forcing PG upgrade from v9.6 a disaster | Dean Gibson (DB Administrator) | 03:07 |
| Re: AWS forcing PG upgrade from v9.6 a disaster | Christophe Pettus | 03:41 |
| Re: AWS forcing PG upgrade from v9.6 a disaster | Dean Gibson (DB Administrator) | 04:23 |
| Re: AWS forcing PG upgrade from v9.6 a disaster | Tom Lane | 04:44 |
| Re: AWS forcing PG upgrade from v9.6 a disaster | Dean Gibson (DB Administrator) | 05:24 |
| Thread | Author | Time |
|---|---|---|
| Re: AWS forcing PG upgrade from v9.6 a disaster | Justin Pryzby | 04:16 |
| Re: AWS forcing PG upgrade from v9.6 a disaster | Dean Gibson (DB Administrator) | 17:44 |
| Thread | Author | Time |
|---|---|---|
| slow query with inline function on AWS RDS with RDS 24x large | Ayub Khan | 08:06 |
| Re: slow query with inline function on AWS RDS with RDS 24x large | Pavel Stehule | 08:22 |
| Re: slow query with inline function on AWS RDS with RDS 24x large | Ayub Khan | 08:32 |
| Re: slow query with inline function on AWS RDS with RDS 24x large | Pavel Stehule | 08:40 |
| Re: slow query with inline function on AWS RDS with RDS 24x large | Ayub Khan | 08:51 |
| PgSQL 12 on WinSrv ~3x faster than on Linux | Taras Savchuk | 11:53 |
| Re: PgSQL 12 on WinSrv ~3x faster than on Linux | David Rowley | 12:42 |
| Re: PgSQL 12 on WinSrv ~3x faster than on Linux | Vijaykumar Jain | 13:14 |
| Re: PgSQL 12 on WinSrv ~3x faster than on Linux | Tom Lane | 13:40 |
| RE: PgSQL 12 on WinSrv ~3x faster than on Linux | Taras Savchuk | 14:01 |
| Thread | Author | Time |
|---|---|---|
| query planner not using index, instead using squential scan | Ayub Khan | 16:42 |
| Re: query planner not using index, instead using squential scan | Tom Lane | 19:29 |
| Re: query planner not using index, instead using squential scan | Vijaykumar Jain | 19:52 |
| Re: query planner not using index, instead using squential scan | Ayub Khan | 21:14 |
| Re: query planner not using index, instead using squential scan | Vijaykumar Jain | 21:18 |
| Thread | Author | Time |
|---|---|---|
| Re: AWS forcing PG upgrade from v9.6 a disaster | Dean Gibson (DB Administrator) | 23:49 |
| Thread | Author | Time |
|---|---|---|
| dexter on AWS RDS auto tune queries | Ayub Khan | 04:51 |
| Re: dexter on AWS RDS auto tune queries | Julien Rouhaud | 04:57 |
| Re: dexter on AWS RDS auto tune queries | Christophe Pettus | 05:00 |
| Re: dexter on AWS RDS auto tune queries | Ayub Khan | 07:49 |
| Re: dexter on AWS RDS auto tune queries | Julien Rouhaud | 07:57 |
| Re: dexter on AWS RDS auto tune queries | Ayub Khan | 10:05 |
| Re: AWS forcing PG upgrade from v9.6 a disaster | Andrew Dunstan | 11:52 |
| Re: AWS forcing PG upgrade from v9.6 a disaster | Dean Gibson (DB Administrator) | 17:27 |
| Thread | Author | Time |
|---|---|---|
| slow query | Ayub Khan | 16:03 |
| Re: slow query | Christophe Pettus | 16:08 |
| Re: slow query | Ayub Khan | 16:32 |
| Re: slow query | Tom Lane | 17:14 |
| Re: slow query | Ayub Khan | 17:43 |
| Thread | Author | Time |
|---|---|---|
| waiting for client write 📎 | Ayub Khan | 14:47 |
| Re: waiting for client write | Magnus Hagander | 14:49 |
| Re: waiting for client write | Ayub Khan | 18:59 |
| Re: slow query | Jeff Janes | 19:57 |
| Re: slow query | Ayub Khan | 20:23 |
| Thread | Author | Time |
|---|---|---|
| Page File Size Reached Critical Threshold PostgreSQL V13 | Haseeb Khan | 00:45 |