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: Searching in varchar column having 100M records | mayank rupareliya | 14:13 |
| Re: Searching in varchar column having 100M records | Michael Lewis | 17:33 |
| Re: Searching in varchar column having 100M records | Tomas Vondra | 18:39 |
| Re: Searching in varchar column having 100M records | mgbii bax | 20:51 |
| Speeding up query pulling comments from pg_catalog | Ken Tanzer | 23:03 |
| Thread | Author | Time |
|---|---|---|
| Re: Speeding up query pulling comments from pg_catalog | Tom Lane | 14:46 |
| Re: Speeding up query pulling comments from pg_catalog | Ken Tanzer | 19:08 |
| Re: Speeding up query pulling comments from pg_catalog | Tom Lane | 19:25 |
| Thread | Author | Time |
|---|---|---|
| benchmarking effective_io_concurrency | Fabio Pardi | 06:41 |
| Re: benchmarking effective_io_concurrency | Rick Otten | 12:06 |
| Re: benchmarking effective_io_concurrency | Fabio Pardi | 12:28 |
| Re: Speeding up query pulling comments from pg_catalog | Ken Tanzer | 17:53 |
| Re: benchmarking effective_io_concurrency | Merlin Moncure | 18:32 |
| Re: Speeding up query pulling comments from pg_catalog | Tom Lane | 19:57 |
| Thread | Author | Time |
|---|---|---|
| zabbix on postgresql - very slow delete of events | Kristian Ejvind | 08:07 |
| Re: zabbix on postgresql - very slow delete of events | Kenneth Marshall | 12:58 |
| Re: zabbix on postgresql - very slow delete of events | Kristian Ejvind | 13:41 |
| Re: zabbix on postgresql - very slow delete of events | Kenneth Marshall | 14:33 |
| Thread | Author | Time |
|---|---|---|
| Re: zabbix on postgresql - very slow delete of events | Kristian Ejvind | 08:11 |
| Re: zabbix on postgresql - very slow delete of events | Maxim Boguk | 13:54 |
| Re: zabbix on postgresql - very slow delete of events | Maxim Boguk | 14:05 |
| Re: zabbix on postgresql - very slow delete of events | Kristian Ejvind | 15:12 |
| Re: zabbix on postgresql - very slow delete of events | Maxim Boguk | 17:16 |
| Thread | Author | Time |
|---|---|---|
| Standard uuid vs. custom data type uuid_v1 | Ancoron Luciferis | 09:26 |
| Thread | Author | Time |
|---|---|---|
| Re: Standard uuid vs. custom data type uuid_v1 | Tomas Vondra | 13:47 |
| Thread | Author | Time |
|---|---|---|
| High concurrency same row (inventory) | Jean Baro | 06:17 |
| Re: Standard uuid vs. custom data type uuid_v1 | Ancoron Luciferis | 08:13 |
| Re: High concurrency same row (inventory) | Rick Otten | 12:35 |
| Re: High concurrency same row (inventory) | Jayadevan M | 12:53 |
| Re: High concurrency same row (inventory) | MichaelDBA | 12:55 |
| Partial join 📎 | Arne Roland | 16:43 |
| Re: High concurrency same row (inventory) | Jean Baro | 18:09 |
| Re: High concurrency same row (inventory) | Michael Lewis | 18:12 |
| Thread | Author | Time |
|---|---|---|
| Re: High concurrency same row (inventory) | Jean Baro | 00:04 |
| Re: High concurrency same row (inventory) | Jean Baro | 00:06 |
| Re: High concurrency same row (inventory) | Jean Baro | 00:26 |
| Re: High concurrency same row (inventory) | MichaelDBA | 01:13 |
| Re: High concurrency same row (inventory) | Jean Baro | 01:23 |
| Thread | Author | Time |
|---|---|---|
| A question regarding streaming replication | Mariel Cherkassky | 09:28 |
| Re: A question regarding streaming replication | Fabio Pardi | 09:41 |
| Re: A question regarding streaming replication | Holger Jakobs | 09:45 |
| Oracle to postgres migration via ora2pg (blob data) | Daulat Ram | 11:31 |
| SV: Oracle to postgres migration via ora2pg (blob data) | Niels Jespersen | 11:45 |
| Re: Oracle to postgres migration via ora2pg (blob data) | Amol Tarte | 16:02 |
| Re: Oracle to postgres migration via ora2pg (blob data) | Gilles Darold | 21:05 |
| Thread | Author | Time |
|---|---|---|
| PSQL performance - TPS | Shital A | 03:10 |
| Re: PSQL performance - TPS | Gavin Flower | 05:15 |
| Re: PSQL performance - TPS | Shital A | 05:18 |
| Partial join 📎 | Arne Roland | 08:07 |
| Re: Partial join | Richard Guo | 11:14 |
| Re: Partial join | Arne Roland | 11:46 |
| Re: Partial join | Tom Lane | 14:14 |
| Re: Partial join | Arne Roland | 16:29 |
| Re: PSQL performance - TPS | Andres Freund | 17:21 |
| Re: PSQL performance - TPS | Purav Chovatia | 18:06 |
| Re: PSQL performance - TPS | Andres Freund | 18:14 |
| Re: PSQL performance - TPS | Rick Otten | 18:27 |
| Thread | Author | Time |
|---|---|---|
| Re: PSQL performance - TPS | Shital A | 04:59 |
| Re: Partial join | Richard Guo | 09:33 |
| Re: Partial join | Richard Guo | 10:00 |
| Re: PSQL performance - TPS | Imre Samu | 11:04 |
| Strange runtime partition pruning behaviour with 11.4 | Thomas Kellerer | 13:58 |
| Thread | Author | Time |
|---|---|---|
| Re: Strange runtime partition pruning behaviour with 11.4 | MichaelDBA | 13:16 |
| Re: Strange runtime partition pruning behaviour with 11.4 | Andreas Kretschmer | 13:42 |
| Re: Strange runtime partition pruning behaviour with 11.4 | Thomas Kellerer | 14:06 |
| Re: Strange runtime partition pruning behaviour with 11.4 | Andreas Kretschmer | 15:18 |
| Re: Strange runtime partition pruning behaviour with 11.4 | Tom Lane | 16:05 |
| Re: Strange runtime partition pruning behaviour with 11.4 | MichaelDBA | 16:49 |
| Thread | Author | Time |
|---|---|---|
| Re: Strange runtime partition pruning behaviour with 11.4 | Thomas Kellerer | 07:29 |
| improving windows functions performance | Mariel Cherkassky | 20:47 |
| Re: improving windows functions performance | Andreas Kretschmer | 21:15 |
| Thread | Author | Time |
|---|---|---|
| Postgres not using correct indices for views. | Thomas Rosenstein | 12:02 |
| Re: Postgres not using correct indices for views. | Tom Lane | 16:05 |
| Re: Postgres not using correct indices for views. | Thomas Rosenstein | 20:04 |
| Re: Postgres not using correct indices for views. | Thomas Rosenstein | 20:30 |
| Re: Postgres not using correct indices for views. | Tom Lane | 22:45 |
| Thread | Author | Time |
|---|---|---|
| Bitmap heap scan performance 📎 | Rob Emery | 08:41 |
| Re: Bitmap heap scan performance | Jeff Janes | 12:30 |
| Re: Postgres not using correct indices for views. | Tom Lane | 15:16 |
| Thread | Author | Time |
|---|---|---|
| Re: [HACKERS] proposal: schema variables 📎 | Pavel Stehule | 07:10 |
| Re: Postgres not using correct indices for views. | Thomas Rosenstein | 10:05 |
| Re: Postgres not using correct indices for views. | Michaeldba@sqlexec.com | 11:11 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgres not using correct indices for views. | Tom Lane | 20:31 |
| Thread | Author | Time |
|---|---|---|
| Planner performance in partitions | Piotr Włodarczyk | 12:37 |
| Re: Bitmap heap scan performance | Rob Emery | 13:00 |
| Re: Bitmap heap scan performance | Jeremy Finzel | 13:29 |
| Re: Planner performance in partitions | Michael Lewis | 19:05 |
| Re: Planner performance in partitions | MichaelDBA | 19:24 |
| ODP: Planner performance in partitions | Piotr Włodarczyk | 20:03 |
| Re: Planner performance in partitions | Michael Lewis | 20:25 |
| Last event per user | Luís Roberto Weck | 20:57 |
| Re: Last event per user | Michael Lewis | 21:56 |
| Re: Planner performance in partitions | David Rowley | 22:25 |
| Re: Last event per user | Luís Roberto Weck | 22:28 |
| Re: Last event per user | Michael Lewis | 22:35 |
| Re: Planner performance in partitions | Michael Lewis | 22:37 |
| Re: | Luís Roberto Weck | 22:43 |
| Re: | Michael Lewis | 22:53 |
| Re: Last event per user | Luís Roberto Weck | 23:03 |
| Re: Last event per user | Michael Lewis | 23:09 |
| Thread | Author | Time |
|---|---|---|
| ODP: Planner performance in partitions | Piotr Włodarczyk | 06:29 |
| Re: Strange runtime partition pruning behaviour with 11.4 | Sverre Boschman | 07:02 |
| ORA-24345: A Truncation or null fetch error occurred -ora2pg | Daulat Ram | 08:23 |
| Re: zabbix on postgresql - very slow delete of events | Kristian Ejvind | 11:08 |
| Re: Last event per user | Luís Roberto Weck | 11:34 |
| performance bottlenecks on lock transactionid 📎 | 王若楠 | 14:15 |
| Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg | Luca Ferrari | 15:02 |
| RE: ORA-24345: A Truncation or null fetch error occurred -ora2pg | Daulat Ram | 17:34 |
| Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg | Adrian Klaver | 17:57 |
| Thread | Author | Time |
|---|---|---|
| Re: performance bottlenecks on lock transactionid | Laurenz Albe | 07:31 |
| re:Re: performance bottlenecks on lock transactionid | 王若楠 | 07:57 |
| RE: ORA-24345: A Truncation or null fetch error occurred -ora2pg | Daulat Ram | 09:39 |
| Re: Re: performance bottlenecks on lock transactionid | Laurenz Albe | 10:25 |
| Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg | Adrian Klaver | 14:13 |
| Continuous Performance Test | Jean Baro | 16:18 |
| Continuous Performance Test | Jean Baro | 17:56 |
| Re: Continuous Performance Test | Nasby, Jim | 20:57 |
| Re: [UNVERIFIED SENDER] Re: Continuous Performance Test | Nasby, Jim | 20:59 |
| Thread | Author | Time |
|---|---|---|
| Re: [UNVERIFIED SENDER] Re: Continuous Performance Test | Jean Baro | 01:33 |
| Thread | Author | Time |
|---|---|---|
| UPGRADE TO PG11 CAUSED DEGREDATION IN PERFORMANCE | Mariel Cherkassky | 06:56 |
| Re: UPGRADE TO PG11 CAUSED DEGREDATION IN PERFORMANCE | Pavel Stehule | 08:41 |
| Thread | Author | Time |
|---|---|---|
| pg11 list partitions vs hash partitions | Mariel Cherkassky | 12:32 |
| Re: Partial join | Arne Roland | 15:17 |
| Thread | Author | Time |
|---|---|---|
| Erratically behaving query needs optimization | Barbu Paul - Gheorghe | 13:54 |
| Re: Erratically behaving query needs optimization | Luís Roberto Weck | 14:58 |
| Re: Erratically behaving query needs optimization | MichaelDBA | 15:07 |
| Extremely slow HashAggregate in simple UNION query | Felix Geisendörfer | 15:11 |
| Re: Extremely slow HashAggregate in simple UNION query | Michael Lewis | 16:19 |
| Re: Extremely slow HashAggregate in simple UNION query | Pavel Stehule | 16:57 |
| Re: Extremely slow HashAggregate in simple UNION query | Andres Freund | 17:32 |
| Re: Extremely slow HashAggregate in simple UNION query | Felix Geisendörfer | 17:55 |
| Re: Extremely slow HashAggregate in simple UNION query | Andres Freund | 18:27 |
| Thread | Author | Time |
|---|---|---|
| Re: Erratically behaving query needs optimization | Barbu Paul - Gheorghe | 07:30 |
| Re: Erratically behaving query needs optimization | Luís Roberto Weck | 11:30 |
| Re: Extremely slow HashAggregate in simple UNION query 📎 | Jeff Janes | 18:26 |
| Thread | Author | Time |
|---|---|---|
| Re: Out of Memory errors are frustrating as heck! | Gunther | 13:17 |
| Re: Out of Memory errors are frustrating as heck! | Gunther | 14:19 |
| Re: Out of Memory errors are frustrating as heck! | Tom Lane | 14:20 |
| Thread | Author | Time |
|---|---|---|
| pg_basebackup is taking an unusually long time with Postgres 11.3 | andy andy | 03:24 |
| Re: Out of Memory errors are frustrating as heck! | Gunther | 15:40 |
| Re: Extremely slow HashAggregate in simple UNION query | Jeff Janes | 19:16 |
| Re: Extremely slow HashAggregate in simple UNION query | Tom Lane | 19:41 |
| Re: Extremely slow HashAggregate in simple UNION query | Andres Freund | 19:54 |
| Thread | Author | Time |
|---|---|---|
| Re: Erratically behaving query needs optimization | Jeff Janes | 14:50 |
| Thread | Author | Time |
|---|---|---|
| Re: Erratically behaving query needs optimization | Barbu Paul - Gheorghe | 08:25 |
| Re: Erratically behaving query needs optimization | Justin Pryzby | 11:51 |
| Thread | Author | Time |
|---|---|---|
| Re: Erratically behaving query needs optimization | Jeff Janes | 21:57 |
| Thread | Author | Time |
|---|---|---|
| Re: Erratically behaving query needs optimization | Barbu Paul - Gheorghe | 12:41 |
| Re: UPGRADE TO PG11 CAUSED DEGREDATION IN PERFORMANCE | Merlin Moncure | 17:34 |
| Incorrect choice of Nested Loop for a skewed distribution | Oleg Kharin | 17:47 |
| Thread | Author | Time |
|---|---|---|
| Upsert performance considerations (~1 mil/hour) | Fredrik Blomqvist | 17:29 |
| Re: Upsert performance considerations (~1 mil/hour) | Jeff Janes | 19:58 |
| Re: Upsert performance considerations (~1 mil/hour) | Fredrik Blomqvist | 21:18 |
| Thread | Author | Time |
|---|---|---|
| Re: Incorrect choice of Nested Loop for a skewed distribution | Justin Pryzby | 00:18 |
| Thread | Author | Time |
|---|---|---|
| Re: Incorrect choice of Nested Loop for a skewed distribution 📎 | Oleg Kharin | 05:02 |
| Thread | Author | Time |
|---|---|---|
| select distinct runs slow on pg 10.6 | yash mehta | 08:30 |
| Re: select distinct runs slow on pg 10.6 | yash mehta | 08:38 |
| Re: select distinct runs slow on pg 10.6 | Flo Rance | 10:00 |
| Re: select distinct runs slow on pg 10.6 | yash mehta | 10:29 |
| Re: select distinct runs slow on pg 10.6 | Justin Pryzby | 10:39 |
| Re: select distinct runs slow on pg 10.6 | Flo Rance | 13:16 |
| Re: select distinct runs slow on pg 10.6 | Michael Lewis | 15:39 |
| Thread | Author | Time |
|---|---|---|
| Re: select distinct runs slow on pg 10.6 | yash mehta | 04:53 |
| Re: select distinct runs slow on pg 10.6 | Rick Otten | 11:56 |
| Thread | Author | Time |
|---|---|---|
| Re: select distinct runs slow on pg 10.6 | Merlin Moncure | 15:54 |
| Re: select distinct runs slow on pg 10.6 | Dinesh Somani | 16:38 |
| Re: select distinct runs slow on pg 10.6 | Rick Otten | 17:57 |
| Thread | Author | Time |
|---|---|---|
| Re: select distinct runs slow on pg 10.6 | Merlin Moncure | 14:19 |
| Re: select distinct runs slow on pg 10.6 | Dinesh Somani | 16:25 |
| Thread | Author | Time |
|---|---|---|
| Query execution time Vs Cost | Amarendra Konda | 11:08 |
| Re: Query execution time Vs Cost | Justin Pryzby | 23:06 |
| Thread | Author | Time |
|---|---|---|
| Re: Query execution time Vs Cost | Amarendra Konda | 04:24 |
| Thread | Author | Time |
|---|---|---|
| does max_connections affect the query planner | Bob Jolliffe | 08:40 |
| Re: does max_connections affect the query planner | Tom Lane | 14:13 |
| Re: does max_connections affect the query planner | Bob Jolliffe | 14:15 |
| Re: does max_connections affect the query planner | Jeff Janes | 14:25 |
| Thread | Author | Time |
|---|---|---|
| Question regarding fast-hashing in PGSQL | Stephen Conley | 16:41 |
| Re: Question regarding fast-hashing in PGSQL | Adam Brusselback | 16:49 |
| Re: Question regarding fast-hashing in PGSQL | Stephen Conley | 16:56 |
| pg12 - migrate tables to partitions structure | Mariel Cherkassky | 18:02 |
| Re: pg12 - migrate tables to partitions structure | Michael Lewis | 19:09 |
| Re: pg12 - migrate tables to partitions structure | Mariel Cherkassky | 19:29 |
| Re: pg12 - migrate tables to partitions structure | Michael Lewis | 20:08 |
| Re: pg12 - migrate tables to partitions structure | Mariel Cherkassky | 20:13 |
| Re: Question regarding fast-hashing in PGSQL | Tom Lane | 20:39 |
| Re: pg12 - migrate tables to partitions structure | Michael Lewis | 20:56 |