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 📎 | Pavel Stehule | 08:30 |
| Re: Guideline To Resolve LWLock:SubtransControlLock | Jeremy Schneider | 15:16 |
| query gets very slow when :jsonb ?& operator is used | davidjesse091 | 23:51 |
| Thread | Author | Time |
|---|---|---|
| Re: query gets very slow when :jsonb ?& operator is used | Jeff Janes | 01:39 |
| Re: Performance difference in accessing differrent columns in a Postgres Table | Dinesh Kumar | 03:28 |
| Multi-second pauses blocking even trivial activity | Patrick Molgaard | 11:56 |
| Re: [HACKERS] proposal: schema variables | Fabien COELHO | 12:34 |
| Re: [HACKERS] proposal: schema variables | Pavel Stehule | 14:28 |
| Re: Multi-second pauses blocking even trivial activity | Jeff Janes | 14:32 |
| GIN Index has O(N^2) complexity for array overlap operator? | Felix Geisendörfer | 15:56 |
| Partial index plan/cardinality costing 📎 | James Coleman | 16:17 |
| Performance of INSERT into temporary tables using psqlODBC driver | padusuma | 17:04 |
| Re: Multi-second pauses blocking even trivial activity | Patrick Molgaard | 18:03 |
| Re: Multi-second pauses blocking even trivial activity | Andreas Kretschmer | 18:12 |
| Re: Multi-second pauses blocking even trivial activity | Joshua D. Drake | 18:22 |
| Re: Multi-second pauses blocking even trivial activity | Jeff Janes | 19:20 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance of INSERT into temporary tables using psqlODBC driver | Tim Cross | 00:05 |
| Re: Multi-second pauses blocking even trivial activity | Patrick Molgaard | 00:32 |
| Re: Multi-second pauses blocking even trivial activity | Patrick Molgaard | 00:34 |
| link to Slow_Query_Questions from wiki/Main Page | Justin Pryzby | 01:29 |
| Re: Performance of INSERT into temporary tables using psqlODBC driver | padusuma | 05:41 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance of INSERT into temporary tables using psqlODBC driver | Sergei Kornilov | 07:45 |
| Re: Performance of INSERT into temporary tables using psqlODBC driver | padusuma | 09:39 |
| Re: Performance of INSERT into temporary tables using psqlODBC driver | Tim Cross | 22:26 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance of INSERT into temporary tables using psqlODBC driver | padusuma | 04:47 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance of INSERT into temporary tables using psqlODBC driver | padusuma | 12:57 |
| Select count(*) on a 2B Rows Tables Takes ~20 Hours | Fd Habash | 17:33 |
| Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours | Justin Pryzby | 18:05 |
| Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours | Tom Lane | 18:12 |
| RE: Select count(*) on a 2B Rows Tables Takes ~20 Hours | Fd Habash | 19:35 |
| Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours | Andres Freund | 19:43 |
| How Do You Associate a Query With its Invoking Procedure? | Fd Habash | 19:49 |
| Re: Performance of INSERT into temporary tables using psqlODBC driver | Tim Cross | 22:41 |
| Thread | Author | Time |
|---|---|---|
| Re: How Do You Associate a Query With its Invoking Procedure? | Fred Habash | 15:38 |
| Re: How Do You Associate a Query With its Invoking Procedure? | David G. Johnston | 16:33 |
| Re: How Do You Associate a Query With its Invoking Procedure? | Rick Otten | 17:14 |
| Re: How Do You Associate a Query With its Invoking Procedure? | Roman Konoval | 18:18 |
| Re: [HACKERS] proposal: schema variables 📎 | Pavel Stehule | 21:31 |
| Thread | Author | Time |
|---|---|---|
| Re: How Do You Associate a Query With its Invoking Procedure? | Patrick Molgaard | 09:24 |
| Re: [HACKERS] proposal: schema variables 📎 | Pavel Stehule | 16:06 |
| Re: Performance of INSERT into temporary tables using psqlODBC driver | padusuma | 17:00 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance of INSERT into temporary tables using psqlODBC driver | Tim Cross | 02:19 |
| Re: Performance of INSERT into temporary tables using psqlODBC driver | padusuma | 05:29 |
| Advice on machine specs for growth | Rory Campbell-Lange | 12:23 |
| Re: How Do You Associate a Query With its Invoking Procedure? | Fred Habash | 21:53 |
| Thread | Author | Time |
|---|---|---|
| Big image tables maintenance | still Learner | 12:38 |
| Re: Big image tables maintenance | Ron | 13:45 |
| Re: Big image tables maintenance | Stephen Frost | 13:58 |
| Re: Big image tables maintenance | Scott Ribe | 13:59 |
| Re: Big image tables maintenance | Stephen Frost | 14:01 |
| Re: Big image tables maintenance | Stephen Frost | 14:03 |
| Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours | Fred Habash | 16:22 |
| Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours | Laurenz Albe | 19:04 |
| Re: Big image tables maintenance | still Learner | 19:12 |
| Re: Big image tables maintenance | Stephen Frost | 19:34 |
| Re: [HACKERS] proposal: schema variables 📎 | Pavel Stehule | 19:46 |
| Thread | Author | Time |
|---|---|---|
| LEFT JOIN LATERAL optimisation at plan time | Nicolas Paris | 07:06 |
| Performance problems with Thai language 📎 | Andrey Zhidenkov | 07:31 |
| pg_pub_decrypt: 10x performance hit with gpg v2 | Felix A. Kater | 14:28 |
| Re: LEFT JOIN LATERAL optimisation at plan time | Tom Lane | 22:21 |
| Thread | Author | Time |
|---|---|---|
| Re: To keep indexes in memory, is large enough effective_cache_size enough? | Wei Shan | 03:19 |
| Re: To keep indexes in memory, is large enough effective_cache_size enough? | David Rowley | 05:17 |
| Re: [HACKERS] proposal: schema variables 📎 | Pavel Stehule | 09:08 |
| Thread | Author | Time |
|---|---|---|
| Why could different data in a table be processed with different performance? | Vladimir Ryabtsev | 00:07 |
| Re: Why could different data in a table be processed with different performance? | Justin Pryzby | 00:42 |
| Re: Why could different data in a table be processed with different performance? | Vladimir Ryabtsev | 01:54 |
| Re: Why could different data in a table be processed with different performance? | Justin Pryzby | 02:29 |
| Re: Why could different data in a table be processed with different performance? | Laurenz Albe | 03:17 |
| Re: Why could different data in a table be processed with different performance? | Vladimir Ryabtsev | 06:28 |
| Re: Why could different data in a table be processed with different performance? | Fabio Pardi | 13:08 |
| Re: Why could different data in a table be processed with different performance? | Fabio Pardi | 13:12 |
| Re: Multi-second pauses blocking even trivial activity | Patrick Molgaard | 19:07 |
| Re: [HACKERS] proposal: schema variables | Arthur Zakirov | 19:46 |
| Thread | Author | Time |
|---|---|---|
| Re: [HACKERS] proposal: schema variables | Pavel Stehule | 03:35 |
| Re: [HACKERS] proposal: schema variables 📎 | Pavel Stehule | 06:00 |
| Re: Why could different data in a table be processed with different performance? | Vladimir Ryabtsev | 09:19 |
| Re: Why could different data in a table be processed with different performance? | Vladimir Ryabtsev | 10:32 |
| Re: Multi-second pauses blocking even trivial activity | Andreas Kretschmer | 10:58 |
| Re: Why could different data in a table be processed with different performance? | didier | 14:49 |
| Thread | Author | Time |
|---|---|---|
| Re: Why could different data in a table be processed with different performance? | Vladimir Ryabtsev | 07:44 |
| Re: Why could different data in a table be processed with different performance? | Fabio Pardi | 14:47 |
| Explain is slow with tables having many columns | legrand legrand | 19:22 |
| Re: Explain is slow with tables having many columns | Justin Pryzby | 19:30 |
| Re: Explain is slow with tables having many columns | legrand legrand | 19:43 |
| Re: Explain is slow with tables having many columns | Andres Freund | 19:50 |
| Re: Explain is slow with tables having many columns | Andres Freund | 19:51 |
| Re: Why could different data in a table be processed with different performance? | Vladimir Ryabtsev | 22:28 |
| Re: Why could different data in a table be processed with different performance? | Justin Pryzby | 23:34 |
| Thread | Author | Time |
|---|---|---|
| Re: Why the sql is not executed in parallel mode | pinker | 16:47 |
| Re: Why could different data in a table be processed with different performance? | Vladimir Ryabtsev | 17:15 |
| reference regarding write load during different stages of checkpoint | Justin Pryzby | 20:05 |
| Thread | Author | Time |
|---|---|---|
| Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes | Justin Pryzby | 00:12 |
| Re: To keep indexes in memory, is large enough effective_cache_size enough? | Sam R. | 04:45 |
| Re: Why could different data in a table be processed with different performance? | Vladimir Ryabtsev | 09:16 |
| Re: Why could different data in a table be processed with different performance? | Vladimir Ryabtsev | 09:56 |
| Re: To keep indexes in memory, is large enough effective_cache_size enough? | David Rowley | 10:32 |
| Re: Why could different data in a table be processed with different performance? | Fabio Pardi | 14:15 |
| Re: Why could different data in a table be processed with different performance? | Vladimir Ryabtsev | 19:51 |
| Thread | Author | Time |
|---|---|---|
| Re: [HACKERS] proposal: schema variables 📎 | Pavel Stehule | 08:34 |
| Re: [HACKERS] proposal: schema variables 📎 | Pavel Stehule | 22:19 |
| Thread | Author | Time |
|---|---|---|
| psql: fe_sendauth: no password supplied | Daulat Ram | 23:36 |
| Re: psql: fe_sendauth: no password supplied | Justin Pryzby | 23:49 |
| Thread | Author | Time |
|---|---|---|
| Re: Why could different data in a table be processed with different performance? | Fabio Pardi | 07:35 |
| Thread | Author | Time |
|---|---|---|
| Re: [HACKERS] proposal: schema variables | Thomas Munro | 23:01 |
| Thread | Author | Time |
|---|---|---|
| Re: [HACKERS] proposal: schema variables 📎 | Pavel Stehule | 01:34 |
| Re: dsa_allocate() faliure | Thomas Munro | 02:16 |
| Thread | Author | Time |
|---|---|---|
| Why the index is not used ? | ROS Didier | 09:57 |
| Re: Why the index is not used ? | Pavel Stehule | 10:13 |
| Re: Why the index is not used ? | Vladimir Ryabtsev | 16:51 |
| Thread | Author | Time |
|---|---|---|
| Re: Why the index is not used ? | Paul McGarry | 02:20 |
| RE: Why the index is not used ? | ROS Didier | 13:13 |
| RE: Why the index is not used ? | ROS Didier | 13:20 |
| Re: Why the index is not used ? | Francisco Olarte | 15:58 |
| Re: [HACKERS] proposal: schema variables 📎 | Pavel Stehule | 17:13 |
| RE: Why the index is not used ? | ROS Didier | 18:32 |
| RE: Why the index is not used ? | Kumar, Virendra | 18:41 |
| Re: Why the index is not used ? | Vladimir Ryabtsev | 18:48 |
| Re: Why the index is not used ? | Vladimir Ryabtsev | 19:32 |
| Re: Why the index is not used ? | Tomas Vondra | 20:07 |
| Re: Why the index is not used ? | Paul McGarry | 22:10 |
| Thread | Author | Time |
|---|---|---|
| RE: Why the index is not used ? | ROS Didier | 06:29 |
| RE: Why the index is not used ? | ROS Didier | 08:32 |
| Re: Why the index is not used ? | Jean-Paul Argudo | 08:44 |
| RE: Why the index is not used ? | ROS Didier | 11:47 |
| RE: Why the index is not used ? | ROS Didier | 12:02 |
| RE: Why the index is not used ? | ROS Didier | 12:07 |
| RE: Why the index is not used ? | Phil Endecott | 13:14 |
| RE: Why the index is not used ? | ROS Didier | 14:10 |
| RE: Why the index is not used ? | ROS Didier | 14:29 |
| RE: Why the index is not used ? | ROS Didier | 15:32 |
| Re: Why the index is not used ? | Tomas Vondra | 20:00 |
| Re: Why the index is not used ? | Paul McGarry | 21:34 |
| Re: Partial index plan/cardinality costing | James Coleman | 22:05 |
| Thread | Author | Time |
|---|---|---|
| Re: Partial index plan/cardinality costing | Justin Pryzby | 00:49 |
| understand query on partition table | Mariel Cherkassky | 09:19 |
| Re: understand query on partition table 📎 | Samed YILDIRIM | 13:12 |
| Thread | Author | Time |
|---|---|---|
| Re: Why could different data in a table be processed with different performance? | Vladimir Ryabtsev | 10:59 |
| Thread | Author | Time |
|---|---|---|
| does work_mem is used on temp tables? | Mariel Cherkassky | 06:56 |
| Re: does work_mem is used on temp tables? | Andrew Gierth | 07:41 |
| Re: does work_mem is used on temp tables? | Mariel Cherkassky | 07:58 |
| Thread | Author | Time |
|---|---|---|
| One big table or split data? Writing data. From disk point of view. With a good storage (GBs/s, writing speed) | Sam R. | 16:27 |
| Thread | Author | Time |
|---|---|---|
| Import csv in PostgreSQL | Dinesh Chandra 12108 | 05:42 |
| Re: Import csv in PostgreSQL | Gabi D | 06:09 |
| Thread | Author | Time |
|---|---|---|
| Re: One big table or split data? Writing data. From disk point of view. With a good storage (GBs/s, writing speed) | Sam R. | 03:47 |
| Thread | Author | Time |
|---|---|---|
| Gained %20 performance after disabling bitmapscan | Yavuz Selim Sertoglu | 07:19 |
| Re: Gained %20 performance after disabling bitmapscan | Justin Pryzby | 13:44 |
| Re: Gained %20 performance after disabling bitmapscan | Tom Lane | 13:52 |
| Re: Gained %20 performance after disabling bitmapscan | Vladimir Ryabtsev | 18:09 |
| Re: Gained %20 performance after disabling bitmapscan | Jeff Janes | 19:40 |
| Thread | Author | Time |
|---|---|---|
| Ynt: Gained %20 performance after disabling bitmapscan | Yavuz Selim Sertoglu | 06:52 |
| Ynt: Gained %20 performance after disabling bitmapscan | Yavuz Selim Sertoglu | 06:55 |
| Ynt: Gained %20 performance after disabling bitmapscan | Yavuz Selim Sertoglu | 07:20 |
| High CPU Usage of "SET ROLE" 📎 | Ulf Lohbrügge | 13:44 |
| Re: High CPU Usage of "SET ROLE" | Tom Lane | 13:57 |