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 |
|---|---|---|
| Substantial different index use between 9.5 and 9.6 | Bill Measday | 23:38 |
| Re: Substantial different index use between 9.5 and 9.6 | Tom Lane | 23:48 |
| Thread | Author | Time |
|---|---|---|
| Re: Substantial different index use between 9.5 and 9.6 | Bill Measday | 00:26 |
| Re: Substantial different index use between 9.5 and 9.6 | Daniel Blanch Bataller | 15:41 |
| Thread | Author | Time |
|---|---|---|
| Re: Substantial different index use between 9.5 and 9.6 | Bill Measday | 20:42 |
| Thread | Author | Time |
|---|---|---|
| Re: performance issue with bitmap index scans on huge amounts of big jsonb documents | Jeff Janes | 02:28 |
| Re: performance issue with bitmap index scans on huge amounts of big jsonb documents | Marc-Olaf Jaschke | 14:51 |
| Thread | Author | Time |
|---|---|---|
| Slow query question | Andrey Povazhnyi | 14:35 |
| Re: Slow query question | Tom Lane | 15:33 |
| Thread | Author | Time |
|---|---|---|
| Re: Slow query question | Andrey Povazhnyi | 09:51 |
| Thread | Author | Time |
|---|---|---|
| Querying with multicolumn index | Eric Jiang | 17:00 |
| Re: performance issue with bitmap index scans on huge amounts of big jsonb documents | Merlin Moncure | 17:03 |
| Re: Querying with multicolumn index | Andreas Joseph Krogh | 17:56 |
| Re: Querying with multicolumn index | Eric Jiang | 18:58 |
| Re: Querying with multicolumn index | Tom Lane | 23:51 |
| Thread | Author | Time |
|---|---|---|
| Re: Querying with multicolumn index | Daniel Blanch Bataller | 08:06 |
| Re: Querying with multicolumn index | Eric Jiang | 20:15 |
| Re: Querying with multicolumn index | Tomas Vondra | 20:34 |
| Thread | Author | Time |
|---|---|---|
| Re: Querying with multicolumn index | Tom Lane | 00:49 |
| Re: Querying with multicolumn index | Tom Lane | 00:51 |
| Re: Querying with multicolumn index | Eric Jiang | 02:08 |
| Re: Querying with multicolumn index 📎 | Daniel Blanch Bataller | 06:04 |
| Thread | Author | Time |
|---|---|---|
| Isolation of tx logs on VMware | ProPAAS DBA | 20:16 |
| Re: Isolation of tx logs on VMware | Joshua D. Drake | 20:22 |
| Re: Querying with multicolumn index | Daniel Blanch Bataller | 21:14 |
| Thread | Author | Time |
|---|---|---|
| Ordering on GIN Index | Rory | 02:18 |
| Thread | Author | Time |
|---|---|---|
| Size of Temporary tablespace is increasing very much in postgresql 9.1. | Dinesh Chandra 12108 | 10:28 |
| Thread | Author | Time |
|---|---|---|
| Re: Size of Temporary tablespace is increasing very much in postgresql 9.1. | Mark Kirkwood | 01:57 |
| bad performance | Gabliver Faluker | 22:25 |
| Re: bad performance | Tom Lane | 23:04 |
| Thread | Author | Time |
|---|---|---|
| Re: Size of Temporary tablespace is increasing very much in postgresql 9.1. | Dinesh Chandra 12108 | 09:19 |
| Thread | Author | Time |
|---|---|---|
| How to vacuum entire database excluding some tables in PostgreSQL9.1. | Dinesh Chandra 12108 | 17:49 |
| Re: How to vacuum entire database excluding some tables in PostgreSQL9.1. | ProPAAS DBA | 18:16 |
| Thread | Author | Time |
|---|---|---|
| Re: bad performance | Jeremy Harris | 13:33 |
| Thread | Author | Time |
|---|---|---|
| Invalid page header in block 25561983 of relation pg_tblspc | Dinesh Chandra 12108 | 09:24 |
| Re: Invalid page header in block 25561983 of relation pg_tblspc | Michael Paquier | 11:01 |
| why we do not create indexes on master | Valerii Valeev | 15:22 |
| Re: why we do not create indexes on master | Andreas Kretschmer | 16:04 |
| Re: why we do not create indexes on master | David G. Johnston | 16:19 |
| Re: why we do not create indexes on master | Valerii Valeev | 17:38 |
| Re: why we do not create indexes on master | ProPAAS DBA | 17:43 |
| Re: why we do not create indexes on master | David G. Johnston | 17:48 |
| Slow query after 9.3 to 9.6 migration | Flávio Henrique | 23:50 |
| Fwd: [pgsql-performance] Daily digest v1.4804 (8 messages) | Valerii Valeev | 23:57 |
| Thread | Author | Time |
|---|---|---|
| Re: why we do not create indexes on master | Valerii Valeev | 00:02 |
| Re: Slow query after 9.3 to 9.6 migration | Gerardo Herzig | 02:52 |
| Re: Slow query after 9.3 to 9.6 migration | Daniel Blanch Bataller | 13:11 |
| Thread | Author | Time |
|---|---|---|
| Re: copy vs. C function | rajmhn | 11:35 |