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: [HACKERS] proposal: schema variables | Peter Eisentraut | 01:56 |
| Re: [HACKERS] proposal: schema variables | Pavel Stehule | 03:11 |
| Thread | Author | Time |
|---|---|---|
| help in analysis of execution plans | Neto pr | 15:16 |
| Re: help in analysis of execution plans | Neto pr | 18:07 |
| Thread | Author | Time |
|---|---|---|
| Re: help in analysis of execution plans | David Rowley | 00:33 |
| Thread | Author | Time |
|---|---|---|
| Time bucketing query performance | Julian Wilson | 23:33 |
| Thread | Author | Time |
|---|---|---|
| Re: Time bucketing query performance | Justin Pryzby | 01:08 |
| Thread | Author | Time |
|---|---|---|
| Sv: Re: Latest advice on SSD? | Andreas Joseph Krogh | 20:00 |
| Thread | Author | Time |
|---|---|---|
| Sv: Sv: Re: Latest advice on SSD? | Andreas Joseph Krogh | 11:23 |
| Re: Sv: Sv: Re: Latest advice on SSD? | Mark Kirkwood | 12:11 |
| Sv: Re: Sv: Sv: Re: Latest advice on SSD? | Andreas Joseph Krogh | 14:00 |
| Sv: Re: Sv: Sv: Re: Latest advice on SSD? | Andreas Joseph Krogh | 14:17 |
| Re: Latest advice on SSD? | Evgeniy Shishkin | 14:48 |
| Thread | Author | Time |
|---|---|---|
| Re: Latest advice on SSD? | Mark Kirkwood | 05:19 |
| Thread | Author | Time |
|---|---|---|
| Help with tuning slow query | Kotapati, Anil | 20:32 |
| Thread | Author | Time |
|---|---|---|
| Re: Help with tuning slow query | Justin Pryzby | 15:57 |
| Thread | Author | Time |
|---|---|---|
| Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! | pavan95 | 05:20 |
| Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! | Justin Pryzby | 06:06 |
| propose web form for submission of performance problems | Justin Pryzby | 23:57 |
| Thread | Author | Time |
|---|---|---|
| add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10)) | Justin Pryzby | 01:00 |
| Re: propose web form for submission of performance problems | Craig James | 01:27 |
| Re: propose web form for submission of performance problems | Justin Pryzby | 01:52 |
| Re: propose web form for submission of performance problems | Thomas Kellerer | 05:45 |
| Thread | Author | Time |
|---|---|---|
| Possible optimisation: push down SORT and LIMIT nodes | Christopher Wilson | 15:46 |
| Re: Possible optimisation: push down SORT and LIMIT nodes | Justin Pryzby | 19:02 |
| Re: Possible optimisation: push down SORT and LIMIT nodes | Justin Pryzby | 19:09 |
| Thread | Author | Time |
|---|---|---|
| Sort is generating rows | Nicolas Seinlet | 11:22 |
| Re: Sort is generating rows | Jeff Janes | 13:10 |
| Re: Sort is generating rows | Nicolas Seinlet | 13:16 |
| Thread | Author | Time |
|---|---|---|
| Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan | Fred Habash | 14:17 |
| Re: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan | Sergei Kornilov | 14:26 |
| Re: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan | Matthew Hall | 14:42 |
| Re: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan | Tom Lane | 14:42 |
| RE: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan | Fd Habash | 17:18 |
| Thread | Author | Time |
|---|---|---|
| Re: Client Server performance & UDS | e-blokos | 09:40 |
| Thread | Author | Time |
|---|---|---|
| pg_upgrade 10.2 | Murthy Nunna | 20:34 |
| Re: pg_upgrade 10.2 | Adrian Klaver | 20:47 |
| RE: pg_upgrade 10.2 | Murthy Nunna | 20:58 |
| Re: pg_upgrade 10.2 | Adrian Klaver | 21:13 |
| RE: pg_upgrade 10.2 | Murthy Nunna | 21:18 |
| Re: pg_upgrade 10.2 | Adrian Klaver | 21:34 |
| RE: pg_upgrade 10.2 | Murthy Nunna | 21:49 |
| Re: pg_upgrade 10.2 | Jerry Sievers | 23:24 |
| RE: pg_upgrade 10.2 | Murthy Nunna | 23:41 |
| Re: pg_upgrade 10.2 | Adrian Klaver | 23:50 |
| Re: pg_upgrade 10.2 | Jerry Sievers | 23:56 |
| Re: pg_upgrade 10.2 | Jerry Sievers | 23:59 |
| Thread | Author | Time |
|---|---|---|
| Re: [PERFORM] Dissuade the use of exclusion constraint index | Adam Brusselback | 15:59 |
| Thread | Author | Time |
|---|---|---|
| Small query plan change, big performance difference | Michael Sacket | 18:02 |
| Re: Small query plan change, big performance difference | Adam Brusselback | 18:24 |
| Re: Small query plan change, big performance difference | Michael Sacket | 18:49 |
| Thread | Author | Time |
|---|---|---|
| Re: [PERFORM] Dissuade the use of exclusion constraint index | Adam Brusselback | 19:50 |
| Thread | Author | Time |
|---|---|---|
| Slow query when pg_trgm is in inner lopp | Sasa Vilic | 13:21 |
| Re: Slow query when pg_trgm is in inner lopp | Matthew Hall | 13:29 |
| Re: Slow query when pg_trgm is in inner lopp | Sasa Vilic | 14:13 |
| Re: Slow query when pg_trgm is in inner lopp | Jeff Janes | 14:53 |
| Re: add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10)) 📎 | Bruce Momjian | 15:13 |
| Re: Slow query when pg_trgm is in inner lopp | Sasa Vilic | 15:38 |
| Thread | Author | Time |
|---|---|---|
| Re: add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10)) | Amit Kapila | 09:23 |
| Thread | Author | Time |
|---|---|---|
| Slow join | Roman Kushnir | 15:55 |
| Re: Slow join | Justin Pryzby | 16:45 |
| Re: Slow join | Roman Kushnir | 19:39 |
| Thread | Author | Time |
|---|---|---|
| Queue table that quickly grows causes query planner to choose poor plan | David Wheeler | 03:45 |
| Re: Slow join | Laurenz Albe | 08:19 |
| Re: Slow join | Roman Kushnir | 09:02 |
| Re: [HACKERS] proposal: schema variables | Gilles Darold | 10:21 |
| Re: [HACKERS] proposal: schema variables | Pavel Stehule | 11:22 |
| Bug in PostgreSQL | Rambabu V | 15:30 |
| Re: Bug in PostgreSQL | Steve Crawford | 15:50 |
| Re: Bug in PostgreSQL | Joseph Curtin | 15:53 |
| Re: [HACKERS] proposal: schema variables | Gilles Darold | 17:15 |
| Re: [HACKERS] proposal: schema variables | Pavel Stehule | 17:17 |
| Re: Queue table that quickly grows causes query planner to choose poor plan | Justin Pryzby | 18:05 |
| Re: Queue table that quickly grows causes query planner to choose poor plan | Tom Lane | 18:27 |
| Thread | Author | Time |
|---|---|---|
| Re: Queue table that quickly grows causes query planner to choose poor plan | David Wheeler | 00:00 |
| Re: Bug in PostgreSQL | Laurenz Albe | 06:55 |
| Re: Bug in PostgreSQL | Andres Freund | 16:13 |
| Thread | Author | Time |
|---|---|---|
| Trigger overhead/performance and alternatives? | AJG | 09:31 |
| Thread | Author | Time |
|---|---|---|
| tcp_keepalives | José Mello Júnior | 13:19 |
| Thread | Author | Time |
|---|---|---|
| Re: tcp_keepalives | Justin Pryzby | 03:56 |
| Thread | Author | Time |
|---|---|---|
| Re: Trigger overhead/performance and alternatives? | Peter Eisentraut | 07:47 |
| Re: Faster str to int conversion (was Table with large number of int columns, very slow COPY FROM) 📎 | Andres Freund | 20:01 |
| Thread | Author | Time |
|---|---|---|
| Re: where can I download the binaries of plpython extension | Mariel Cherkassky | 06:18 |
| Need help with optimising simple query | Nandakumar M | 11:47 |
| Re: Need help with optimising simple query | Tom Lane | 14:23 |
| Re: add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10)) | Bruce Momjian | 15:19 |
| Thread | Author | Time |
|---|---|---|
| Re: Need help with optimising simple query | Nandakumar M | 05:36 |
| Improving Performance of Query ~ Filter by A, Sort by B | Lincoln Swaine-Moore | 15:07 |
| performance statistics monitoring without spamming logs | Patrick Hemmer | 17:54 |
| Re: performance statistics monitoring without spamming logs | Justin Pryzby | 18:38 |
| Thread | Author | Time |
|---|---|---|
| Special bloom index of INT, BIGINT, BIT, VARBIT for bitwise operation | Takao Magoori | 06:02 |
| High concurrency but simple updating causes deadlock | 枫 | 14:16 |
| Re: Improving Performance of Query ~ Filter by A, Sort by B | legrand legrand | 21:41 |
| Re: Improving Performance of Query ~ Filter by A, Sort by B | Lincoln Swaine-Moore | 23:31 |
| Thread | Author | Time |
|---|---|---|
| Re: Improving Performance of Query ~ Filter by A, Sort by B | Tom Lane | 03:10 |
| Suggestion to optimize performance of the PLSQL procedure. 📎 | Dinesh Chandra 12108 | 03:18 |
| Re: High concurrency but simple updating causes deadlock | Roman Konoval | 10:55 |
| Re: performance statistics monitoring without spamming logs | Lukas Fittl | 22:25 |
| Thread | Author | Time |
|---|---|---|
| Re: performance statistics monitoring without spamming logs | Adrien NAYRAT | 07:23 |
| Re: performance statistics monitoring without spamming logs | Adrien NAYRAT | 07:24 |
| Re: performance statistics monitoring without spamming logs | Julien Rouhaud | 07:55 |
| Thread | Author | Time |
|---|---|---|
| Re: Improving Performance of Query ~ Filter by A, Sort by B | Jeff Janes | 03:25 |
| Thread | Author | Time |
|---|---|---|
| Re: Improving Performance of Query ~ Filter by A, Sort by B | Lincoln Swaine-Moore | 21:29 |
| Thread | Author | Time |
|---|---|---|
| Re: Why HDD performance is better than SSD in this case | Neto pr | 01:13 |
| Re: Why HDD performance is better than SSD in this case | Neto pr | 01:16 |
| Re: Why HDD performance is better than SSD in this case | Neto pr | 01:24 |
| Re: Why HDD performance is better than SSD in this case | Fabio Pardi | 07:46 |
| Re: Why HDD performance is better than SSD in this case | Nicolas Charles | 09:33 |
| Re: Why HDD performance is better than SSD in this case | Mark Kirkwood | 09:35 |
| Re: Why HDD performance is better than SSD in this case | George Neuner | 16:44 |
| Re: Why HDD performance is better than SSD in this case | Imre Samu | 17:35 |
| Re: Faster str to int conversion (was Table with large number of int columns, very slow COPY FROM) | Robert Haas | 18:34 |
| Thread | Author | Time |
|---|---|---|
| Re: Faster str to int conversion (was Table with large number of int columns, very slow COPY FROM) | Andres Freund | 20:32 |
| Re: Why HDD performance is better than SSD in this case | Mark Kirkwood | 23:30 |
| Thread | Author | Time |
|---|---|---|
| Re: Why HDD performance is better than SSD in this case | Mark Kirkwood | 00:33 |
| Re: Why HDD performance is better than SSD in this case 📎 | Neto pr | 00:52 |
| Re: Why HDD performance is better than SSD in this case | Mark Kirkwood | 01:49 |
| Re: Faster str to int conversion (was Table with large number of int columns, very slow COPY FROM) | Robert Haas | 12:27 |
| Re: Faster str to int conversion (was Table with large number of int columns, very slow COPY FROM) | Andres Freund | 16:45 |
| Thread | Author | Time |
|---|---|---|
| Re: Why HDD performance is better than SSD in this case | Mark Kirkwood | 00:07 |
| Profile what the production server is doing | Thomas Güttler | 11:18 |
| Re: Profile what the production server is doing | Julien Rouhaud | 11:38 |
| Re: Profile what the production server is doing | Baron Schwartz | 14:01 |
| Re: Profile what the production server is doing | Flo Rance | 15:16 |
| Thread | Author | Time |
|---|---|---|
| Re: Profile what the production server is doing | Thomas Güttler | 09:14 |
| Re: Profile what the production server is doing | Thomas Güttler | 09:17 |
| Re: Profile what the production server is doing | Thomas Güttler | 09:39 |
| Re: Profile what the production server is doing | Flo Rance | 09:49 |
| Re: Profile what the production server is doing | Julien Rouhaud | 10:25 |
| Thread | Author | Time |
|---|---|---|
| Automated bottleneck detection | Thomas Güttler | 11:27 |
| Re: Automated bottleneck detection | MichaelDBA | 12:05 |
| Query with "ILIKE ALL" does not use the index | Nicolas Even | 15:53 |
| Re: Query with "ILIKE ALL" does not use the index | Tom Lane | 16:44 |
| Re: Query with "ILIKE ALL" does not use the index | Matthew Hall | 17:22 |
| Re: Query with "ILIKE ALL" does not use the index | Nicolas Even | 19:17 |
| Re: Query with "ILIKE ALL" does not use the index | Nicolas Even | 19:32 |