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: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS | aditya desai | 05:09 |
| Substitute for synonym in Oracle after migration to postgres | aditya desai | 07:52 |
| Re: Substitute for synonym in Oracle after migration to postgres | Laurenz Albe | 08:19 |
| Re: Substitute for synonym in Oracle after migration to postgres | hubert depesz lubaczewski | 10:41 |
| select count(*) is slow | aditya desai | 13:14 |
| Re: Substitute for synonym in Oracle after migration to postgres | aditya desai | 13:19 |
| Re: select count(*) is slow | Tom Lane | 13:25 |
| Re: select count(*) is slow | aditya desai | 13:30 |
| Re: select count(*) is slow | Andrew Dunstan | 15:44 |
| Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS | Andrew Dunstan | 15:49 |
| Thread | Author | Time |
|---|---|---|
| Re: select count(*) is slow | aditya desai | 08:09 |
| Thread | Author | Time |
|---|---|---|
| procedure using CURSOR to insert is extremely slow | Szalontai Zoltán | 11:24 |
| str_aggr function not wokring | aditya desai | 11:31 |
| Re: procedure using CURSOR to insert is extremely slow | Hervé Schweitzer (HER) | 11:40 |
| RE: str_aggr function not wokring | Patrick FICHE | 11:41 |
| RE: procedure using CURSOR to insert is extremely slow | Szalontai Zoltán | 11:58 |
| Re: procedure using CURSOR to insert is extremely slow | Milos Babic | 12:31 |
| Re: str_aggr function not wokring | aditya desai | 12:55 |
| Re: str_aggr function not wokring | aditya desai | 12:58 |
| RE: procedure using CURSOR to insert is extremely slow | Szalontai Zoltán | 13:56 |
| RE: procedure using CURSOR to insert is extremely slow | Mike Sofen | 16:52 |
| Re: procedure using CURSOR to insert is extremely slow | Milos Babic | 18:21 |
| RE: procedure using CURSOR to insert is extremely slow | Szalontai Zoltán | 19:45 |
| INSERTS waiting with wait_event is "transactionid" | Nagaraj Raj | 20:14 |
| Re: [PATCH] force_parallel_mode and GUC categories 📎 | Justin Pryzby | 21:38 |
| 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 | 03:17 |
| Re: INSERTS waiting with wait_event is "transactionid" | Laurenz Albe | 09:15 |
| Re: [PATCH] force_parallel_mode and GUC categories | Bruce Momjian | 11:39 |
| Re: INSERTS waiting with wait_event is "transactionid" | Nagaraj Raj | 18:22 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 06:58 |
| Thread | Author | Time |
|---|---|---|
| Re: [PATCH] force_parallel_mode and GUC categories | Michael Paquier | 05:01 |
| Re: [PATCH] force_parallel_mode and GUC categories | Bharath Rupireddy | 05:28 |
| Re: [PATCH] force_parallel_mode and GUC categories | Tom Lane | 05:40 |
| LWLocks by LockManager slowing large DB | Paul Friedman | 19:37 |
| Re: LWLocks by LockManager slowing large DB | Andres Freund | 21:57 |
| RE: LWLocks by LockManager slowing large DB | Paul Friedman | 22:15 |
| Re: LWLocks by LockManager slowing large DB | Andres Freund | 22:22 |
| RE: LWLocks by LockManager slowing large DB | Paul Friedman | 22:56 |
| Re: LWLocks by LockManager slowing large DB | Andres Freund | 23:03 |
| Re: LWLocks by LockManager slowing large DB | Nikolay Samokhvalov | 23:33 |
| Thread | Author | Time |
|---|---|---|
| Re: [PATCH] force_parallel_mode and GUC categories | Michael Paquier | 07:34 |
| Re: [PATCH] force_parallel_mode and GUC categories 📎 | Justin Pryzby | 12:31 |
| Re: [PATCH] force_parallel_mode and GUC categories | Tom Lane | 14:12 |
| RE: LWLocks by LockManager slowing large DB 📎 | Paul Friedman | 16:33 |
| RE: LWLocks by LockManager slowing large DB | Paul Friedman | 16:36 |
| Re: LWLocks by LockManager slowing large DB | Andres Freund | 18:16 |
| RE: LWLocks by LockManager slowing large DB | Paul Friedman | 18:47 |
| Re: LWLocks by LockManager slowing large DB | Andres Freund | 20:48 |
| Re: LWLocks by LockManager slowing large DB | Alvaro Herrera | 20:54 |
| Re: LWLocks by LockManager slowing large DB | Tom Lane | 22:29 |
| RE: LWLocks by LockManager slowing large DB | Paul Friedman | 22:45 |
| Re: LWLocks by LockManager slowing large DB 📎 | Tom Lane | 23:16 |
| Thread | Author | Time |
|---|---|---|
| Re: LWLocks by LockManager slowing large DB | Andres Freund | 01:01 |
| Re: LWLocks by LockManager slowing large DB | Tom Lane | 03:04 |
| Re: LWLocks by LockManager slowing large DB | Andres Freund | 03:48 |
| Re: [PATCH] force_parallel_mode and GUC categories | Michael Paquier | 04:54 |
| Re: [PATCH] force_parallel_mode and GUC categories | Michael Paquier | 06:57 |
| Re: LWLocks by LockManager slowing large DB | Alvaro Herrera | 13:20 |
| Why is there a tenfold difference between Postgres's alleged query execution time and packet transmission time? | Rollo Konig-Brock | 23:10 |
| Thread | Author | Time |
|---|---|---|
| Strange behavior once statistics are there | Daniel Westermann (DWE) | 13:17 |
| Is there a way to change current time? | 13:45 | |
| Re: Is there a way to change current time? | Bruce Momjian | 13:58 |
| Re: Is there a way to change current time? | Justin Pryzby | 14:01 |
| Re: Is there a way to change current time? | Tom Lane | 14:13 |
| Re: Is there a way to change current time? | Pavel Stehule | 14:14 |
| Re: Is there a way to change current time? | Eugene Pazhitnov | 14:37 |
| Re: Strange behavior once statistics are there | Tom Lane | 15:00 |
| Re: Disabling options lowers the estimated cost of a query 📎 | Arne Roland | 18:13 |
| Thread | Author | Time |
|---|---|---|
| Re: Disabling options lowers the estimated cost of a query 📎 | Tomas Vondra | 04:52 |
| Re: Strange behavior once statistics are there | Daniel Westermann (DWE) | 06:14 |
| OLEDB for PostgreSQL | mustafa.pekgoz | 10:32 |
| Re: OLEDB for PostgreSQL | Google FezaCakir | 12:31 |
| Re: Disabling options lowers the estimated cost of a query | Tom Lane | 12:58 |
| Re: Disabling options lowers the estimated cost of a query | Tom Lane | 13:09 |
| Re: Why is there a tenfold difference between Postgres's alleged query execution time and packet transmission time? | Tom Lane | 13:27 |
| Re: OLEDB for PostgreSQL | Thomas Kellerer | 14:25 |
| Re: Disabling options lowers the estimated cost of a query 📎 | Tomas Vondra | 17:59 |
| BUG #16968: Planner does not recognize optimization | PG Bug reporting form | 19:18 |
| Re: BUG #16968: Planner does not recognize optimization 📎 | Eugen Konkov | 19:27 |
| Re: OLEDB for PostgreSQL | Jonah H. Harris | 21:42 |
| Re: OLEDB for PostgreSQL | Kenneth Marshall | 21:52 |
| Thread | Author | Time |
|---|---|---|
| Most proper partitioning form on an integer column | Il Mimo di Creta | 18:07 |
| Re: Most proper partitioning form on an integer column | Justin Pryzby | 19:28 |
| Thread | Author | Time |
|---|---|---|
| Re: OLEDB for PostgreSQL | aditya desai | 13:10 |
| Thread | Author | Time |
|---|---|---|
| Re: Planning performance problem (67626.278ms) | Jeremy Schneider | 21:00 |
| Thread | Author | Time |
|---|---|---|
| Re: OLEDB for PostgreSQL | Pavan Pusuluri | 01:45 |
| Re: Planning performance problem (67626.278ms) | David Rowley | 14:14 |
| Re: Planning performance problem (67626.278ms) | Tom Lane | 14:37 |
| 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 |