Mailing lists [pgsql-performance]

4 August 2023

• 17:59   Plan weirdness. A sort produces more rows than the node beneath it Dane Foster
• 18:07   Re: Plan weirdness. A sort produces more rows than the node beneath it Jeff Janes
• 18:09   Re: Plan weirdness. A sort produces more rows than the node beneath it Dane Foster
• 18:10   Re: Plan weirdness. A sort produces more rows than the node beneath it Tom Lane
• 18:15   Re: Plan weirdness. A sort produces more rows than the node beneath it Dane Foster
• 18:31   Re: Plan weirdness. A sort produces more rows than the node beneath it Tom Lane
• 19:41   Re: Plan weirdness. A sort produces more rows than the node beneath it Dane Foster

9 August 2023

• 02:07   Function call very slow from JDBC/java but super fast from DBear An, Hongguo (CORP)
• 16:29   Re: Function call very slow from JDBC/java but super fast from DBear Dave Cramer
• 19:50   Re: Function call very slow from JDBC/java but super fast from DBear An, Hongguo (CORP)

10 August 2023

• 06:33   Re: Function call very slow from JDBC/java but super fast from DBear David G. Johnston
• 11:36   Partitioning update-heavy queue with hash partitions vs partial indexes Dorian Hoxha

11 August 2023

• 07:49   Re: Partitioning update-heavy queue with hash partitions vs partial indexes David Rowley
• 08:13   Re: Partitioning update-heavy queue with hash partitions vs partial indexes burcinyazici@gmail.com
• 14:09   Re: Partitioning update-heavy queue with hash partitions vs partial indexes Dorian Hoxha

15 August 2023

• 23:23   slow delete Les
• 23:37   Re: slow delete Tom Lane

16 August 2023

• 07:43   Re: slow delete Les
• 17:03   Re: slow delete Jeff Janes

23 August 2023

• 12:19   Question regarding writes when locking rows Martin Querleu

27 August 2023

• 14:58   Slow query, possibly not using index Les
• 16:27   Re: Slow query, possibly not using index Tom Lane
• 20:39   Re: Slow query, possibly not using index Les
• 21:54   Re: Slow query, possibly not using index Wael Khobalatte

28 August 2023

• 02:34   Re: Slow query, possibly not using index Tom Lane
• 09:04   Re: Slow query, possibly not using index Les
• 10:21   Re: Slow query, possibly not using index Les
• 13:59   Re: Slow query, possibly not using index Les
• 14:03   Re: Slow query, possibly not using index Pavel Stehule
• 14:42   Re: Slow query, possibly not using index David Rowley
• 14:47   Re: Slow query, possibly not using index Les

29 August 2023

• 03:32   Index bloat and REINDEX/VACUUM optimization for partial index jayaprabhakar k
• 04:49   Re: Index bloat and REINDEX/VACUUM optimization for partial index Peter Geoghegan
• 10:40   Range partitioning query performance with date_trunc (vs timescaledb) Philippe Pepiot
• 12:38   Re: Range partitioning query performance with date_trunc (vs timescaledb) David Rowley
• 19:47   Re: Index bloat and REINDEX/VACUUM optimization for partial index jayaprabhakar k
• 21:42   Re: Queries containing ORDER BY and LIMIT started to work slowly Jeff Janes
• 22:43   Re: Index bloat and REINDEX/VACUUM optimization for partial index Jeff Janes
• 23:11   Re: Queries containing ORDER BY and LIMIT started to work slowly Jeff Janes

30 August 2023

• 00:06   Re: Queries containing ORDER BY and LIMIT started to work slowly Rick Otten

31 August 2023

• 00:43   Re: Queries containing ORDER BY and LIMIT started to work slowly David Rowley
• 03:42   Re: Index bloat and REINDEX/VACUUM optimization for partial index jayaprabhakar k
• 11:19   Join order optimization Christian Beikov
• 18:05   Re: Index bloat and REINDEX/VACUUM optimization for partial index Maxim Boguk
• 19:52   Re: Queries containing ORDER BY and LIMIT started to work slowly Jeff Janes