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 |
|---|---|---|
| PostgreSQLv14 TPC-H performance GCC vs Clang | arjun shetty | 17:13 |
| Re: PostgreSQLv14 TPC-H performance GCC vs Clang | Imre Samu | 19:29 |
| Thread | Author | Time |
|---|---|---|
| JIT llvm11 package | ANASTACIO Tiago | 20:56 |
| Thread | Author | Time |
|---|---|---|
| Re: PostgreSQLv14 TPC-H performance GCC vs Clang | arjun shetty | 12:07 |
| Re: PostgreSQLv14 TPC-H performance GCC vs Clang | Tomas Vondra | 17:29 |
| Thread | Author | Time |
|---|---|---|
| EXISTS by itself vs SELECT EXISTS much slower in query. 📎 | Jimmy A | 22:27 |
| Thread | Author | Time |
|---|---|---|
| Re: EXISTS by itself vs SELECT EXISTS much slower in query. | Vasya Boytsov | 09:22 |
| Re: EXISTS by itself vs SELECT EXISTS much slower in query. | Tom Lane | 20:35 |
| Thread | Author | Time |
|---|---|---|
| Re: EXISTS by itself vs SELECT EXISTS much slower in query. | Jimmy A | 01:08 |
| Thread | Author | Time |
|---|---|---|
| performance of analytical query | Jiří Fejfar | 19:20 |
| Thread | Author | Time |
|---|---|---|
| Re: performance of analytical query | Justin Pryzby | 02:41 |
| Re: Lock contention high | Ashkil Dighin | 14:12 |
| Re: performance of analytical query | Michael Lewis | 17:55 |
| Re: performance of analytical query | Justin Pryzby | 18:33 |
| Re: performance of analytical query | Jiří Fejfar | 20:12 |
| Thread | Author | Time |
|---|---|---|
| postgresql13-llvm jit-13.5-1PGDG.rhel8.x86_64 | Mladen Gogala | 04:21 |
| Re: postgresql13-llvm jit-13.5-1PGDG.rhel8.x86_64 | Pavel Stehule | 05:04 |
| Re: postgresql13-llvm jit-13.5-1PGDG.rhel8.x86_64 | Mladen Gogala | 13:56 |
| Re: postgresql13-llvm jit-13.5-1PGDG.rhel8.x86_64 | Rick Otten | 14:17 |
| Re: Lock contention high | Tom Lane | 15:25 |
| Thread | Author | Time |
|---|---|---|
| Need help identifying a periodic performance issue. | Robert Creager | 04:43 |
| Re: Need help identifying a periodic performance issue. | Justin Pryzby | 05:29 |
| Re: Need help identifying a periodic performance issue. | Thomas Munro | 05:50 |
| PostgreSQLv14 TPC-H performance GCC vs Clang | arjun shetty | 10:10 |
| Re: Need help identifying a periodic performance issue. | Robert Creager | 17:40 |
| Re: Need help identifying a periodic performance issue. | Robert Creager | 22:40 |
| Re: Need help identifying a periodic performance issue. | Thomas Munro | 22:51 |
| Re: Need help identifying a periodic performance issue. | Thomas Munro | 22:52 |
| Thread | Author | Time |
|---|---|---|
| Re: Lock contention high | arjun shetty | 06:43 |
| Re: Need help identifying a periodic performance issue. | Robert Creager | 17:51 |
| Re: Need help identifying a periodic performance issue. | Robert Creager | 17:55 |
| Re: Need help identifying a periodic performance issue. | Justin Pryzby | 19:00 |
| Re: Need help identifying a periodic performance issue. | Tom Lane | 19:28 |
| Re: Need help identifying a periodic performance issue. | Robert Creager | 19:51 |
| Re: Need help identifying a periodic performance issue. | Thomas Munro | 21:01 |
| Re: Need help identifying a periodic performance issue. | Robert Creager | 21:54 |
| Re: Need help identifying a periodic performance issue. | Justin Pryzby | 23:18 |
| Thread | Author | Time |
|---|---|---|
| Re: Need help identifying a periodic performance issue. | Robert Creager | 00:18 |
| Re: Need help identifying a periodic performance issue. | Thomas Munro | 03:39 |
| Re: Need help identifying a periodic performance issue. | Justin Pryzby | 05:42 |
| Re: Need help identifying a periodic performance issue. | Robert Creager | 17:03 |
| Re: Need help identifying a periodic performance issue. | Thomas Munro | 21:08 |
| Re: Need help identifying a periodic performance issue. | Tom Lane | 21:42 |
| Re: Need help identifying a periodic performance issue. | Robert Creager | 22:28 |
| Re: Need help identifying a periodic performance issue. | Robert Creager | 22:30 |
| Thread | Author | Time |
|---|---|---|
| Re: Need help identifying a periodic performance issue. | Robert Creager | 18:47 |
| Thread | Author | Time |
|---|---|---|
| Re: performance of analytical query | Justin Pryzby | 19:42 |
| Thread | Author | Time |
|---|---|---|
| Out of memory error | aditya desai | 05:27 |
| Re: Out of memory error | Tom Lane | 05:52 |
| Re: Out of memory error | aditya desai | 06:25 |
| Re: Out of memory error | Thomas Kellerer | 06:31 |
| Re: Out of memory error | aditya desai | 06:36 |
| Re: Out of memory error | Michael Lewis | 06:45 |
| Re: Out of memory error | aditya desai | 07:31 |
| Re: Out of memory error | aditya desai | 07:35 |
| Postgres process count GCC vs Clang is Different on autovaccum=on | hpc researcher_mspk | 12:05 |
| Re: Out of memory error | Thomas Kellerer | 12:10 |
| Re: Out of memory error | Thomas Kellerer | 12:12 |
| Re: Postgres process count GCC vs Clang is Different on autovaccum=on | Tomas Vondra | 12:22 |
| Re: Out of memory error | aditya desai | 14:32 |
| Re: Need help identifying a periodic performance issue. | Robert Creager | 21:13 |
| Re: Need help identifying a periodic performance issue. | Robert Creager | 22:44 |
| Re: Need help identifying a periodic performance issue. | Justin Pryzby | 23:15 |
| Thread | Author | Time |
|---|---|---|
| pg_dump backup verification | Daulat | 09:11 |
| AW: [External] pg_dump backup verification | Dirk Krautschick | 09:21 |
| Re: pg_dump backup verification | Justin Pryzby | 17:09 |
| Thread | Author | Time |
|---|---|---|
| Re: Lock contention high | arjun shetty | 12:39 |
| Re: Need help identifying a periodic performance issue. 📎 | Robert Creager | 23:04 |
| Thread | Author | Time |
|---|---|---|
| pg_trgm word_similarity query does not use index for input strings longer than 8 characters | pgsql-performance | 21:38 |