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: High availability management tool. | Dorian Hoxha | 07:59 |
| Re: High availability management tool. | Hüseyin Demir | 09:08 |
| Re: High availability management tool. | Adalberto Caccia | 09:23 |
| Thread | Author | Time |
|---|---|---|
| [PATCH] force_parallel_mode and GUC categories 📎 | Justin Pryzby | 01:25 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 08:30 |
| SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS | aditya desai | 10:42 |
| Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. | aditya desai | 11:10 |
| Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS | Amine Tengilimoglu | 17:01 |
| Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS | Justin Pryzby | 17:19 |
| Thread | Author | Time |
|---|---|---|
| PosgtgreSQL hot standby reading WAL from muli-attached volume? | Gunther Schadow | 22:22 |
| 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 |