agora inbox for pgsql-performance@postgresql.org
help / color / mirror / Atom feedPerformance of Query 60 on TPC-DS Benchmark
2024-11-22 11:12 UTC Ba Jinsheng <bajinsheng@u.nus.edu>
` Re: Performance of Query 60 on TPC-DS Benchmark
2024-11-22 14:32 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: Performance of Query 60 on TPC-DS Benchmark
2024-11-24 12:04 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: Performance of Query 60 on TPC-DS Benchmark
2024-11-28 07:58 UTC Nikita Malakhov <hukutoc@gmail.com>
` Re: Performance of Query 60 on TPC-DS Benchmark
2024-11-29 14:27 UTC Nikita Malakhov <hukutoc@gmail.com>
[5+ messages in thread]
Has gen_random_uuid() gotten much slower in v17?
2024-09-10 13:58 UTC David Mullineux <dmullx@gmail.com>
` Re: Has gen_random_uuid() gotten much slower in v17?
2024-09-11 09:40 UTC Peter Eisentraut <peter@eisentraut.org>
` Re: Has gen_random_uuid() gotten much slower in v17?
2024-09-11 10:47 UTC David Mullineux <dmullx@gmail.com>
` Re: Has gen_random_uuid() gotten much slower in v17?
2024-11-20 10:35 UTC Frédéric Yhuel <frederic.yhuel@dalibo.com>
` Re: Has gen_random_uuid() gotten much slower in v17?
2024-11-20 15:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Has gen_random_uuid() gotten much slower in v17?
2024-11-20 22:11 UTC David Mullineux <dmullx@gmail.com>
` Re: Has gen_random_uuid() gotten much slower in v17?
2024-11-20 22:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Has gen_random_uuid() gotten much slower in v17?
2024-11-26 15:23 UTC David Mullineux <dmullx@gmail.com>
[8+ messages in thread]
Performance of TPC-DS Query 95
2024-11-25 20:54 UTC Ba Jinsheng <bajinsheng@u.nus.edu>
` Re: Performance of TPC-DS Query 95
2024-11-25 22:41 UTC David Rowley <dgrowleyml@gmail.com>
[2+ messages in thread]
Cardinality estimate of the inner relation
2024-11-22 15:53 UTC Frédéric Yhuel <frederic.yhuel@dalibo.com>
` Re: Cardinality estimate of the inner relation
2024-11-23 02:07 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: Cardinality estimate of the inner relation
2024-11-25 12:46 UTC Frédéric Yhuel <frederic.yhuel@dalibo.com>
[3+ messages in thread]
could not send data to client: Connection reset by peer
2024-11-21 12:13 UTC James Pang <jamespang886@gmail.com>
` Re: could not send data to client: Connection reset by peer
2024-11-23 01:38 UTC Tomas Vondra <tomas@vondra.me>
[2+ messages in thread]
tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4
2024-11-08 19:32 UTC Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
` Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4
2024-11-09 10:49 UTC Tomas Vondra <tomas@vondra.me>
` Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4
2024-11-09 14:05 UTC Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
` Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4
2024-11-09 14:08 UTC Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
` Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4
2024-11-09 15:41 UTC Tomas Vondra <tomas@vondra.me>
` Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4
2024-11-10 09:45 UTC Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
` Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4
2024-11-12 10:37 UTC Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com>
` Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4
2024-11-12 13:17 UTC Tomas Vondra <tomas@vondra.me>
` Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4
2024-11-12 18:24 UTC Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
` Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4
2024-11-12 19:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4
2024-11-12 21:46 UTC Tomas Vondra <tomas@vondra.me>
` Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4
2024-11-13 07:14 UTC Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com>
` Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4
2024-11-13 08:45 UTC Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com>
[13+ messages in thread]
Performance of Query 4 on TPC-DS Benchmark
2024-11-10 19:35 UTC Ba Jinsheng <bajinsheng@u.nus.edu>
` Re: Performance of Query 4 on TPC-DS Benchmark
2024-11-10 19:58 UTC Thomas Munro <thomas.munro@gmail.com>
` Re: Performance of Query 4 on TPC-DS Benchmark
2024-11-10 20:16 UTC Alena Rybakina <a.rybakina@postgrespro.ru>
` Re: Performance of Query 4 on TPC-DS Benchmark
2024-11-10 20:18 UTC Alena Rybakina <a.rybakina@postgrespro.ru>
` Re: Performance of Query 4 on TPC-DS Benchmark
2024-11-11 09:41 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: Performance of Query 4 on TPC-DS Benchmark
2024-11-11 10:49 UTC Ba Jinsheng <bajinsheng@u.nus.edu>
` Re: Performance of Query 4 on TPC-DS Benchmark
2024-11-11 10:51 UTC Ba Jinsheng <bajinsheng@u.nus.edu>
` Re: Performance of Query 4 on TPC-DS Benchmark
2024-11-12 10:40 UTC Andrei Lepikhov <lepihov@gmail.com>
[8+ messages in thread]
Major performance degradation with joins in 15.8 or 15.7?
2024-11-07 21:54 UTC Ed Sabol <edwardjsabol@gmail.com>
` Re: Major performance degradation with joins in 15.8 or 15.7?
2024-11-07 22:18 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Major performance degradation with joins in 15.8 or 15.7?
2024-11-08 01:21 UTC Ed Sabol <edwardjsabol@gmail.com>
` Re: Major performance degradation with joins in 15.8 or 15.7?
2024-11-08 02:27 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: Major performance degradation with joins in 15.8 or 15.7?
2024-11-08 02:45 UTC Ed Sabol <edwardjsabol@gmail.com>
` Re: Major performance degradation with joins in 15.8 or 15.7?
2024-11-08 02:54 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: Major performance degradation with joins in 15.8 or 15.7?
2024-11-08 20:32 UTC Ed Sabol <edwardjsabol@gmail.com>
` Re: Major performance degradation with joins in 15.8 or 15.7?
2024-11-09 01:21 UTC Andrei Lepikhov <lepihov@gmail.com>
[8+ messages in thread]
Bloom filters and the planner / parallel execution
2024-10-08 11:56 UTC Daniel Westermann (DWE) <daniel.westermann@dbi-services.com>
` Re: Bloom filters and the planner / parallel execution
2024-11-05 13:22 UTC Rafia Sabih <rafia.pghackers@gmail.com>
[2+ messages in thread]
Performance of Query 2 in TPC-H
2024-11-04 08:42 UTC Ba Jinsheng <bajinsheng@u.nus.edu>
` Re: Performance of Query 2 in TPC-H
2024-11-05 02:22 UTC Andrei Lepikhov <lepihov@gmail.com>
[2+ messages in thread]
Postgresql 14/15/16/17 partition pruning on dependent table during join
2024-11-01 13:21 UTC Stepan Yankevych <Stepan_Yankevych@epam.com>
` Re: Postgresql 14/15/16/17 partition pruning on dependent table during join
2024-11-02 20:21 UTC Vijaykumar Jain <vijaykumarjain.github@gmail.com>
` Re: Postgresql 14/15/16/17 partition pruning on dependent table during join
2024-11-03 02:42 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: Postgresql 14/15/16/17 partition pruning on dependent table during join
2024-11-04 08:23 UTC Stepan Yankevych <Stepan_Yankevych@epam.com>
` Re: Postgresql 14/15/16/17 partition pruning on dependent table during join
2024-11-04 12:05 UTC Andrei Lepikhov <lepihov@gmail.com>
[5+ messages in thread]
Unexpected Performance for the Function simplify_function
2024-10-24 19:43 UTC Ba Jinsheng <bajinsheng@u.nus.edu>
` Re: Unexpected Performance for the Function simplify_function
2024-10-24 19:48 UTC Shiv Iyer <shiv@minervadb.com>
` Re: Unexpected Performance for the Function simplify_function
2024-10-24 20:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Unexpected Performance for the Function simplify_function
2024-10-24 20:51 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Unexpected Performance for the Function simplify_function
2024-10-24 21:05 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Unexpected Performance for the Function simplify_function
2024-10-24 23:09 UTC Greg Sabino Mullane <htamfids@gmail.com>
` Re: Unexpected Performance for the Function simplify_function
2024-10-25 02:13 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: Unexpected Performance for the Function simplify_function
2024-10-25 09:26 UTC Ba Jinsheng <bajinsheng@u.nus.edu>
` Re: Unexpected Performance for the Function simplify_function
2024-10-25 09:29 UTC Ba Jinsheng <bajinsheng@u.nus.edu>
` Re: Unexpected Performance for the Function simplify_function
2024-10-25 09:38 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: Unexpected Performance for the Function simplify_function
2024-10-25 10:20 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Unexpected Performance for the Function simplify_function
2024-10-26 06:28 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Unexpected Performance for the Function simplify_function
2024-10-26 07:31 UTC Ba Jinsheng <bajinsheng@u.nus.edu>
[13+ messages in thread]
Adding exclusion constraint in a big table
2024-10-24 06:43 UTC Marcelo Fernandes <marcefern7@gmail.com>
Performance degradation in Index searches with special characters
2024-10-05 09:23 UTC Andrey Stikheev <andrey.stikheev@gmail.com>
` Re: Performance degradation in Index searches with special characters
2024-10-06 16:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance degradation in Index searches with special characters
2024-10-06 17:28 UTC Andrey Stikheev <andrey.stikheev@gmail.com>
` Re: Performance degradation in Index searches with special characters
2024-10-06 17:45 UTC Joe Conway <mail@joeconway.com>
` Re: Performance degradation in Index searches with special characters
2024-10-06 18:13 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance degradation in Index searches with special characters
2024-10-06 20:02 UTC Shiv Iyer <shiv@minervadb.com>
` Re: Performance degradation in Index searches with special characters
2024-10-06 20:24 UTC Thomas Munro <thomas.munro@gmail.com>
` Re: Performance degradation in Index searches with special characters
2024-10-07 16:48 UTC Joe Conway <mail@joeconway.com>
` Re: Performance degradation in Index searches with special characters
2024-10-07 17:16 UTC Andrey Stikheev <andrey.stikheev@gmail.com>
[9+ messages in thread]
Partition pruning with array-contains check and current_setting function
2024-08-07 21:10 UTC Marcelo Zabani <mzabani@gmail.com>
` Re: Partition pruning with array-contains check and current_setting function
2024-09-11 19:11 UTC Marcelo Zabani <mzabani@gmail.com>
[2+ messages in thread]
many backends hang on MultiXactOffsetSLRU
2024-09-10 07:33 UTC James Pang <jamespang886@gmail.com>
` Re: many backends hang on MultiXactOffsetSLRU
2024-09-10 08:12 UTC Amine Tengilimoglu <aminetengilimoglu@gmail.com>
` Re: many backends hang on MultiXactOffsetSLRU
2024-09-10 08:13 UTC Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: many backends hang on MultiXactOffsetSLRU
2024-09-10 08:15 UTC Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: many backends hang on MultiXactOffsetSLRU
2024-09-10 08:34 UTC James Pang <jamespang886@gmail.com>
` Re: many backends hang on MultiXactOffsetSLRU
2024-09-10 08:53 UTC Amine Tengilimoglu <aminetengilimoglu@gmail.com>
` Re: many backends hang on MultiXactOffsetSLRU
2024-09-10 09:00 UTC Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: many backends hang on MultiXactOffsetSLRU
2024-09-11 07:00 UTC James Pang <jamespang886@gmail.com>
[8+ messages in thread]
Estimate of the inner_rows
2024-09-08 08:21 UTC =?GBK?B?s8LR47fJ?= <postgresql_2016@163.com>
` Re: Estimate of the inner_rows
2024-09-08 16:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Estimate of the inner_rows
2024-09-09 03:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
checking for a NULL date in a partitioned table kills performance
2024-08-22 21:44 UTC Sbob <sbob@quadratum-braccas.com>
` checking for a NULL date in a partitioned table kills performance (accidentally sent to the admin list before)
2024-08-22 21:47 UTC Sbob <sbob@quadratum-braccas.com>
` Re: checking for a NULL date in a partitioned table kills performance
2024-08-22 23:06 UTC Rui DeSousa <rui.desousa@icloud.com>
` Re: checking for a NULL date in a partitioned table kills performance
2024-08-22 23:26 UTC Sbob <sbob@quadratum-braccas.com>
` Re: checking for a NULL date in a partitioned table kills performance
2024-08-22 23:32 UTC Sbob <sbob@quadratum-braccas.com>
` Re: checking for a NULL date in a partitioned table kills performance (accidentally sent to the admin list before)
2024-08-22 23:54 UTC Vitalii Tymchyshyn <vit@tym.im>
` Re: checking for a NULL date in a partitioned table kills performance
2024-08-23 00:01 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: checking for a NULL date in a partitioned table kills performance
2024-08-23 00:05 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: checking for a NULL date in a partitioned table kills performance
2024-08-23 00:07 UTC Rui DeSousa <rui.desousa@icloud.com>
` Re: checking for a NULL date in a partitioned table kills performance
2024-08-23 04:40 UTC Muhammad Usman Khan <usman.k@bitnine.net>
` Re: checking for a NULL date in a partitioned table kills performance
2024-08-23 06:45 UTC shammat@gmx.net
` Re: checking for a NULL date in a partitioned table kills performance
2024-08-23 09:54 UTC Rui DeSousa <rui.desousa@icloud.com>
` Re: checking for a NULL date in a partitioned table kills performance
2024-08-23 11:39 UTC Doug Reynolds <mav@wastegate.net>
` Re: checking for a NULL date in a partitioned table kills performance
2024-08-23 13:47 UTC Sbob <sbob@quadratum-braccas.com>
` Re: checking for a NULL date in a partitioned table kills performance
2024-08-23 15:17 UTC Scott Ribe <scott_ribe@elevated-dev.com>
` Re: checking for a NULL date in a partitioned table kills performance
2024-08-23 15:42 UTC Doug Reynolds <mav@wastegate.net>
` Re: checking for a NULL date in a partitioned table kills performance
2024-08-23 15:49 UTC Wetmore, Matthew (CTR) <Matthew.Wetmore@mdlive.com>
` Re: checking for a NULL date in a partitioned table kills performance
2024-08-23 16:08 UTC Scott Ribe <scott_ribe@elevated-dev.com>
[18+ messages in thread]
Trying to understand why a query is filtering when there is a composite index
2024-08-19 01:55 UTC Stephen Samuel (Sam) <sam@sksamuel.com>
` Re: Trying to understand why a query is filtering when there is a composite index
2024-08-19 01:59 UTC Peter Geoghegan <pg@bowt.ie>
` Re: Trying to understand why a query is filtering when there is a composite index
2024-08-19 02:01 UTC Stephen Samuel (Sam) <sam@sksamuel.com>
` Re: Trying to understand why a query is filtering when there is a composite index
2024-08-19 02:08 UTC Peter Geoghegan <pg@bowt.ie>
` Re: Trying to understand why a query is filtering when there is a composite index
2024-08-19 02:09 UTC Stephen Samuel (Sam) <sam@sksamuel.com>
` Re: Trying to understand why a query is filtering when there is a composite index
2024-08-19 02:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Trying to understand why a query is filtering when there is a composite index
2024-08-19 03:11 UTC Peter Geoghegan <pg@bowt.ie>
` Re: Trying to understand why a query is filtering when there is a composite index
2024-08-19 04:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Trying to understand why a query is filtering when there is a composite index
2024-08-19 04:16 UTC Stephen Samuel (Sam) <sam@sksamuel.com>
` Re: Trying to understand why a query is filtering when there is a composite index
2024-08-19 08:05 UTC Shiv Iyer <shiv@minervadb.com>
` Re: Trying to understand why a query is filtering when there is a composite index
2024-08-19 15:21 UTC Peter Geoghegan <pg@bowt.ie>
` Re: Trying to understand why a query is filtering when there is a composite index
2024-08-19 23:44 UTC Stephen Samuel (Sam) <sam@sksamuel.com>
` Re: Trying to understand why a query is filtering when there is a composite index
2024-08-19 23:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Trying to understand why a query is filtering when there is a composite index
2024-08-20 00:00 UTC Stephen Samuel (Sam) <sam@sksamuel.com>
[14+ messages in thread]
Postgres index usage
2024-08-07 17:06 UTC Dirschel, Steve <steve.dirschel@thomsonreuters.com>
` RE: Postgres index usage
2024-08-07 17:23 UTC Dirschel, Steve <steve.dirschel@thomsonreuters.com>
` Re: Postgres index usage
2024-08-07 17:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres index usage
2024-08-07 18:18 UTC Greg Sabino Mullane <htamfids@gmail.com>
[4+ messages in thread]
logical replication out of memory
2024-07-31 02:17 UTC James Pang <jamespang886@gmail.com>
` Re: logical replication out of memory
2024-07-31 02:30 UTC James Pang <jamespang886@gmail.com>
` Re: logical replication out of memory
2024-07-31 05:41 UTC khan Affan <bawag773@gmail.com>
` Re: logical replication out of memory
2024-07-31 06:48 UTC James Pang <jamespang886@gmail.com>
` Re: logical replication out of memory
2024-07-31 07:06 UTC khan Affan <bawag773@gmail.com>
[5+ messages in thread]
Help with row estimate problem
2024-07-29 20:51 UTC Jon Zeppieri <zeppieri@gmail.com>
` Re: Help with row estimate problem
2024-07-30 15:34 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: Help with row estimate problem
2024-07-30 17:22 UTC Jon Zeppieri <zeppieri@gmail.com>
[3+ messages in thread]
Outer cost higher than the inner cost
2024-07-26 13:25 UTC Stanisław Skonieczny <stanislaw.skonieczny@gmail.com>
` Re: Outer cost higher than the inner cost
2024-07-26 14:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
inequality predicate not pushed down in JOIN?
2024-07-11 23:31 UTC Paul George <p.a.george19@gmail.com>
` Re: inequality predicate not pushed down in JOIN?
2024-07-11 23:49 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: inequality predicate not pushed down in JOIN?
2024-07-12 00:07 UTC Paul George <p.a.george19@gmail.com>
` Re: inequality predicate not pushed down in JOIN?
2024-07-12 00:58 UTC Jerry Brenner <jbrenner@guidewire.com>
[4+ messages in thread]
How to solve my slow disk i/o throughput during index scan
2024-07-04 13:25 UTC FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT) <simon.freyburger@sncf.fr>
` Re: How to solve my slow disk i/o throughput during index scan
2024-07-04 14:36 UTC Andrei Lepikhov <lepihov@gmail.com>
` RE: How to solve my slow disk i/o throughput during index scan
2024-07-04 15:23 UTC FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT) <simon.freyburger@sncf.fr>
` Re: How to solve my slow disk i/o throughput during index scan
2024-07-05 02:04 UTC Andrei Lepikhov <lepihov@gmail.com>
` RE: How to solve my slow disk i/o throughput during index scan
2024-07-11 14:59 UTC FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT) <simon.freyburger@sncf.fr>
` RE: How to solve my slow disk i/o throughput during index scan
2024-07-11 15:09 UTC FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT) <simon.freyburger@sncf.fr>
` Re: How to solve my slow disk i/o throughput during index scan
2024-07-11 15:19 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: How to solve my slow disk i/o throughput during index scan
2024-07-11 15:22 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: How to solve my slow disk i/o throughput during index scan
2024-07-11 15:34 UTC Andrei Lepikhov <lepihov@gmail.com>
[9+ messages in thread]
[next (older)]
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox