pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedAwkward Join between generate_series and long table
2023-11-09 01:26 UTC Lincoln Swaine-Moore <lswainemoore@gmail.com>
` Re: Awkward Join between generate_series and long table
2023-11-09 01:44 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Awkward Join between generate_series and long table
2023-11-09 02:19 UTC Lincoln Swaine-Moore <lswainemoore@gmail.com>
` Re: Awkward Join between generate_series and long table
2023-11-09 13:54 UTC Philip Semanchuk <philip@americanefficient.com>
` Re: Awkward Join between generate_series and long table
2023-11-09 18:00 UTC Lincoln Swaine-Moore <lswainemoore@gmail.com>
[5+ messages in thread]
Performance down with JDBC 42
2023-11-04 19:08 UTC Abraham, Danny <danny_abraham@bmc.com>
` Re: Performance down with JDBC 42
2023-11-04 21:07 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` RE: [EXTERNAL] Re: Performance down with JDBC 42
2023-11-05 16:20 UTC Abraham, Danny <danny_abraham@bmc.com>
` Re: [EXTERNAL] Re: Performance down with JDBC 42
2023-11-05 16:52 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: [EXTERNAL] Re: Performance down with JDBC 42
2023-11-05 17:34 UTC Frits Hoogland <frits.hoogland@gmail.com>
` Re: [EXTERNAL] Re: Performance down with JDBC 42
2023-11-05 19:11 UTC Jeff Janes <jeff.janes@gmail.com>
` RE: [EXTERNAL] Re: Performance down with JDBC 42
2023-11-05 19:37 UTC Abraham, Danny <danny_abraham@bmc.com>
` Re: [EXTERNAL] Re: Performance down with JDBC 42
2023-11-05 19:47 UTC David Rowley <dgrowleyml@gmail.com>
` Re: [EXTERNAL] Performance down with JDBC 42
2023-11-06 09:24 UTC Frits Hoogland <frits.hoogland@gmail.com>
` RE: [EXTERNAL] Performance down with JDBC 42
2023-11-09 14:00 UTC Abraham, Danny <danny_abraham@bmc.com>
[10+ messages in thread]
Performance problems with Postgres JDBC 42.4.2
2023-11-06 14:59 UTC Jose Osinde <jose.osinde@gmail.com>
` Re: Performance problems with Postgres JDBC 42.4.2
2023-11-08 16:55 UTC Dave Cramer <davecramer@postgres.rocks>
[2+ messages in thread]
Postgres Locking
2023-10-31 21:12 UTC Dirschel, Steve <steve.dirschel@thomsonreuters.com>
` RE: Postgres Locking
2023-10-31 21:43 UTC Smith, Travis <Travis.Smith@circana.com>
` Re: Postgres Locking
2023-10-31 21:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
Postgres 15 SELECT query doesn't use index under RLS
2023-10-12 16:41 UTC Alexander Okulovich <aokulovich@stiltsoft.com>
` Re: Postgres 15 SELECT query doesn't use index under RLS
2023-10-13 20:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres 15 SELECT query doesn't use index under RLS
2023-10-18 10:29 UTC Alexander Okulovich <aokulovich@stiltsoft.com>
` Re: Postgres 15 SELECT query doesn't use index under RLS
2023-10-18 14:07 UTC Alexander Okulovich <aokulovich@stiltsoft.com>
` Re: Postgres 15 SELECT query doesn't use index under RLS
2023-10-18 20:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres 15 SELECT query doesn't use index under RLS
2023-10-19 07:43 UTC Tomek <tomekphotos@gmail.com>
` Re: Postgres 15 SELECT query doesn't use index under RLS
2023-10-19 09:58 UTC Alexander Okulovich <aokulovich@stiltsoft.com>
` Re: Postgres 15 SELECT query doesn't use index under RLS
2023-10-26 13:47 UTC Alexander Okulovich <aokulovich@stiltsoft.com>
` Re: Postgres 15 SELECT query doesn't use index under RLS
2023-10-26 14:09 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres 15 SELECT query doesn't use index under RLS
2023-10-31 16:01 UTC Alexander Okulovich <aokulovich@stiltsoft.com>
[10+ messages in thread]
GIN JSONB path index is not always used
2023-10-17 13:48 UTC Tomasz Szymański <lime129@gmail.com>
` Re: GIN JSONB path index is not always used
2023-10-17 14:17 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: GIN JSONB path index is not always used
2023-10-17 17:05 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: GIN JSONB path index is not always used
2023-10-23 10:33 UTC Tomasz Szymański <lime129@gmail.com>
` Re: GIN JSONB path index is not always used
2023-10-23 14:05 UTC Jeff Janes <jeff.janes@gmail.com>
[5+ messages in thread]
Underestimated number of output rows with an aggregate function
2023-10-15 08:38 UTC Philippe BEAUDOIN <phb.emaj@free.fr>
` Re: Underestimated number of output rows with an aggregate function
2023-10-15 16:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Underestimated number of output rows with an aggregate function
2023-10-16 16:52 UTC Philippe BEAUDOIN <phb.emaj@free.fr>
[3+ messages in thread]
Unexpected termination looping over table.
2023-10-02 00:57 UTC Matt Gibbins <matt_gibbins@fastmail.com.au>
` Re: Unexpected termination looping over table.
2023-10-02 01:09 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Unexpected termination looping over table.
2023-10-02 02:36 UTC Matt Gibbins <matt_gibbins@fastmail.com.au>
[3+ messages in thread]
Dirty reads on index scan,
2023-09-21 15:05 UTC Koen De Groote <kdg.dev@gmail.com>
` Re: Dirty reads on index scan,
2023-09-21 19:30 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Dirty reads on index scan,
2023-09-22 08:35 UTC Koen De Groote <kdg.dev@gmail.com>
` Re: Dirty reads on index scan,
2023-09-22 09:14 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Dirty reads on index scan,
2023-09-22 13:22 UTC Frits Hoogland <frits.hoogland@gmail.com>
` Re: Dirty reads on index scan,
2023-09-22 13:54 UTC Koen De Groote <kdg.dev@gmail.com>
` Re: Dirty reads on index scan,
2023-09-24 20:17 UTC Jeff Janes <jeff.janes@gmail.com>
[7+ messages in thread]
pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit
2023-09-15 14:30 UTC Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com>
` Re: pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit
2023-09-15 15:23 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit
2023-09-15 19:31 UTC Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
` Re: pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit
2023-09-15 19:42 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit
2023-09-15 20:36 UTC Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
` Re: pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit
2023-09-15 23:08 UTC Thomas Munro <thomas.munro@gmail.com>
` Re: pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit
2023-09-16 03:27 UTC Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
[7+ messages in thread]
Multixact wraparound monitoring
2023-09-13 12:21 UTC bruno da silva <brunogiovs@gmail.com>
` Re: Multixact wraparound monitoring
2023-09-14 05:14 UTC Wyatt Alt <wyatt.alt@gmail.com>
` Re: Multixact wraparound monitoring
2023-09-14 11:23 UTC Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: Multixact wraparound monitoring
2023-09-14 19:35 UTC bruno da silva <brunogiovs@gmail.com>
` Re: Multixact wraparound monitoring
2023-09-15 09:48 UTC Alvaro Herrera <alvherre@alvh.no-ip.org>
[5+ messages in thread]
query pg_stat_ssl hang 100%cpu
2023-09-06 01:34 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` query pg_stat_ssl hang 100%cpu
2023-09-06 01:40 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` FW: query pg_stat_ssl hang 100%cpu
2023-09-07 01:35 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` Re: FW: query pg_stat_ssl hang 100%cpu
2023-09-07 04:04 UTC Michael Paquier <michael@paquier.xyz>
` RE: FW: query pg_stat_ssl hang 100%cpu
2023-09-07 08:46 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` RE: FW: query pg_stat_ssl hang 100%cpu
2023-09-07 08:54 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` Re: FW: query pg_stat_ssl hang 100%cpu
2023-09-07 09:31 UTC Thomas Munro <thomas.munro@gmail.com>
` RE: FW: query pg_stat_ssl hang 100%cpu
2023-09-07 09:38 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` RE: FW: query pg_stat_ssl hang 100%cpu
2023-09-07 09:54 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` Re: FW: query pg_stat_ssl hang 100%cpu
2023-09-07 10:01 UTC Thomas Munro <thomas.munro@gmail.com>
` RE: FW: query pg_stat_ssl hang 100%cpu
2023-09-07 10:31 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` Re: FW: query pg_stat_ssl hang 100%cpu
2023-09-07 10:36 UTC Thomas Munro <thomas.munro@gmail.com>
` RE: FW: query pg_stat_ssl hang 100%cpu
2023-09-07 10:39 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` Re: FW: query pg_stat_ssl hang 100%cpu
2023-09-07 10:59 UTC Thomas Munro <thomas.munro@gmail.com>
` Re: FW: query pg_stat_ssl hang 100%cpu
2023-09-07 23:45 UTC Thomas Munro <thomas.munro@gmail.com>
` Re: FW: query pg_stat_ssl hang 100%cpu
2023-09-08 02:48 UTC Michael Paquier <michael@paquier.xyz>
` Re: FW: query pg_stat_ssl hang 100%cpu
2023-09-10 22:37 UTC Thomas Munro <thomas.munro@gmail.com>
` Re: FW: query pg_stat_ssl hang 100%cpu
2023-09-10 22:47 UTC Michael Paquier <michael@paquier.xyz>
` Re: FW: query pg_stat_ssl hang 100%cpu
2023-09-13 03:11 UTC Thomas Munro <thomas.munro@gmail.com>
[19+ messages in thread]
Range partitioning query performance with date_trunc (vs timescaledb)
2023-08-29 07:40 UTC Philippe Pepiot <phil@philpep.org>
` Re: Range partitioning query performance with date_trunc (vs timescaledb)
2023-08-29 09:38 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Range partitioning query performance with date_trunc (vs timescaledb)
2023-09-11 12:21 UTC Philippe Pepiot <phil@philpep.org>
[3+ messages in thread]
Index bloat and REINDEX/VACUUM optimization for partial index
2023-08-29 00:32 UTC jayaprabhakar k <jayaprabhakar@gmail.com>
` Re: Index bloat and REINDEX/VACUUM optimization for partial index
2023-08-29 01:49 UTC Peter Geoghegan <pg@bowt.ie>
` Re: Index bloat and REINDEX/VACUUM optimization for partial index
2023-08-29 16:47 UTC jayaprabhakar k <jayaprabhakar@gmail.com>
` Re: Index bloat and REINDEX/VACUUM optimization for partial index
2023-08-29 19:43 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Index bloat and REINDEX/VACUUM optimization for partial index
2023-08-31 00:42 UTC jayaprabhakar k <jayaprabhakar@gmail.com>
` Re: Index bloat and REINDEX/VACUUM optimization for partial index
2023-08-31 15:05 UTC Maxim Boguk <maxim.boguk@gmail.com>
` Re: Index bloat and REINDEX/VACUUM optimization for partial index
2023-09-01 01:05 UTC jayaprabhakar k <jayaprabhakar@gmail.com>
` Re: Index bloat and REINDEX/VACUUM optimization for partial index
2023-09-01 03:01 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Index bloat and REINDEX/VACUUM optimization for partial index
2023-09-01 03:18 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Index bloat and REINDEX/VACUUM optimization for partial index
2023-09-01 18:01 UTC Maxim Boguk <maxim.boguk@gmail.com>
` Re: Index bloat and REINDEX/VACUUM optimization for partial index
2023-09-06 06:50 UTC jayaprabhakar k <jayaprabhakar@gmail.com>
[11+ messages in thread]
Queries containing ORDER BY and LIMIT started to work slowly
2023-08-29 17:47 UTC Rondat Flyag <rondatflyag@yandex.ru>
` Re: Queries containing ORDER BY and LIMIT started to work slowly
2023-08-29 18:42 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Queries containing ORDER BY and LIMIT started to work slowly
2023-08-29 18:55 UTC Rondat Flyag <rondatflyag@yandex.ru>
` Re: Queries containing ORDER BY and LIMIT started to work slowly
2023-08-29 20:11 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Queries containing ORDER BY and LIMIT started to work slowly
2023-08-29 21:06 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Queries containing ORDER BY and LIMIT started to work slowly
2023-08-30 17:31 UTC Rondat Flyag <rondatflyag@yandex.ru>
` Re: Queries containing ORDER BY and LIMIT started to work slowly
2023-08-30 17:46 UTC Rondat Flyag <rondatflyag@yandex.ru>
` Re: Queries containing ORDER BY and LIMIT started to work slowly
2023-08-30 21:43 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Queries containing ORDER BY and LIMIT started to work slowly
2023-08-31 16:52 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Queries containing ORDER BY and LIMIT started to work slowly
2023-09-01 13:41 UTC Rondat Flyag <rondatflyag@yandex.ru>
` Re: Queries containing ORDER BY and LIMIT started to work slowly
2023-09-01 13:45 UTC Rondat Flyag <rondatflyag@yandex.ru>
[11+ messages in thread]
Join order optimization
2023-08-31 08:19 UTC Christian Beikov <christian.beikov@gmail.com>
Slow query, possibly not using index
2023-08-27 11:58 UTC Les <nagylzs@gmail.com>
` Re: Slow query, possibly not using index
2023-08-27 13:27 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow query, possibly not using index
2023-08-27 17:39 UTC Les <nagylzs@gmail.com>
` Re: Slow query, possibly not using index
2023-08-27 18:54 UTC Wael Khobalatte <wael@vendr.com>
` Re: Slow query, possibly not using index
2023-08-27 23:34 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow query, possibly not using index
2023-08-28 06:04 UTC Les <nagylzs@gmail.com>
` Re: Slow query, possibly not using index
2023-08-28 07:21 UTC Les <nagylzs@gmail.com>
` Re: Slow query, possibly not using index
2023-08-28 10:59 UTC Les <nagylzs@gmail.com>
` Re: Slow query, possibly not using index
2023-08-28 11:03 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Slow query, possibly not using index
2023-08-28 11:42 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Slow query, possibly not using index
2023-08-28 11:47 UTC Les <nagylzs@gmail.com>
[11+ messages in thread]
Question regarding writes when locking rows
2023-08-23 09:19 UTC Martin Querleu <martinquerleu@gmail.com>
slow delete
2008-07-04 00:44 UTC Jessica Richard <rjessil@yahoo.com>
` Re: slow delete
2008-07-04 05:16 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: slow delete
2008-07-04 10:11 UTC PFC <lists@peufeu.com>
` Re: slow delete
2008-07-04 12:30 UTC Jessica Richard <rjessil@yahoo.com>
` Re: slow delete
2008-07-04 13:00 UTC tv@fuzzy.cz
` Re: slow delete
2008-07-04 15:48 UTC Alan Hodgson <ahodgson@simkin.ca>
` slow delete
2023-08-15 20:23 UTC Les <nagylzs@gmail.com>
` Re: slow delete
2023-08-15 20:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: slow delete
2023-08-16 04:43 UTC Les <nagylzs@gmail.com>
` Re: slow delete
2023-08-16 14:03 UTC Jeff Janes <jeff.janes@gmail.com>
[10+ messages in thread]
Partitioning update-heavy queue with hash partitions vs partial indexes
2023-08-10 08:36 UTC Dorian Hoxha <dorian.hoxha@gmail.com>
` Re: Partitioning update-heavy queue with hash partitions vs partial indexes
2023-08-11 04:49 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Partitioning update-heavy queue with hash partitions vs partial indexes
2023-08-11 05:13 UTC burcinyazici@gmail.com
` Re: Partitioning update-heavy queue with hash partitions vs partial indexes
2023-08-11 11:09 UTC Dorian Hoxha <dorian.hoxha@gmail.com>
[4+ messages in thread]
Function call very slow from JDBC/java but super fast from DBear
2023-08-08 23:07 UTC An, Hongguo (CORP) <Hongguo.An@ADP.com>
` Re: Function call very slow from JDBC/java but super fast from DBear
2023-08-09 13:29 UTC Dave Cramer <davecramer@postgres.rocks>
` Re: Function call very slow from JDBC/java but super fast from DBear
2023-08-09 16:50 UTC An, Hongguo (CORP) <Hongguo.An@ADP.com>
` Re: Function call very slow from JDBC/java but super fast from DBear
2023-08-10 03:33 UTC David G. Johnston <david.g.johnston@gmail.com>
[4+ messages in thread]
Plan weirdness. A sort produces more rows than the node beneath it
2023-08-04 14:59 UTC Dane Foster <studdugie@gmail.com>
` Re: Plan weirdness. A sort produces more rows than the node beneath it
2023-08-04 15:07 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Plan weirdness. A sort produces more rows than the node beneath it
2023-08-04 15:09 UTC Dane Foster <studdugie@gmail.com>
` Re: Plan weirdness. A sort produces more rows than the node beneath it
2023-08-04 15:10 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Plan weirdness. A sort produces more rows than the node beneath it
2023-08-04 15:15 UTC Dane Foster <studdugie@gmail.com>
` Re: Plan weirdness. A sort produces more rows than the node beneath it
2023-08-04 15:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Plan weirdness. A sort produces more rows than the node beneath it
2023-08-04 16:41 UTC Dane Foster <studdugie@gmail.com>
[7+ messages in thread]
Table copy with SERIALIZABLE is incredibly slow
2023-07-31 05:00 UTC peter plachta <pplachta@gmail.com>
` Re: Table copy with SERIALIZABLE is incredibly slow
2023-07-31 06:30 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[2+ messages in thread]
Results of experiments with UUIDv7, UUIDv8
2023-07-31 04:48 UTC peter plachta <pplachta@gmail.com>
TOAST Fields serialisation/deserialization performance
2023-07-26 12:45 UTC Piyush Katariya <corporate.piyush@gmail.com>
` Re: TOAST Fields serialisation/deserialization performance
2023-07-26 19:39 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: TOAST Fields serialisation/deserialization performance
2023-07-26 19:48 UTC Piyush Katariya <corporate.piyush@gmail.com>
[3+ messages in thread]
[next (older)]
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox