pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedUPGRADE TO PG11 CAUSED DEGREDATION IN PERFORMANCE
2019-08-18 06:56 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: UPGRADE TO PG11 CAUSED DEGREDATION IN PERFORMANCE
2019-08-18 08:41 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: UPGRADE TO PG11 CAUSED DEGREDATION IN PERFORMANCE
2019-09-03 17:34 UTC Merlin Moncure <mmoncure@gmail.com>
[3+ messages in thread]
Erratically behaving query needs optimization
2019-08-20 13:54 UTC Barbu Paul - Gheorghe <barbu.paul.gheorghe@gmail.com>
` Re: Erratically behaving query needs optimization
2019-08-20 14:58 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Erratically behaving query needs optimization
2019-08-20 15:07 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Erratically behaving query needs optimization
2019-08-21 07:30 UTC Barbu Paul - Gheorghe <barbu.paul.gheorghe@gmail.com>
` Re: Erratically behaving query needs optimization
2019-08-21 11:30 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Erratically behaving query needs optimization
2019-08-22 11:51 UTC Barbu Paul - Gheorghe <barbu.paul.gheorghe@gmail.com>
` Re: Erratically behaving query needs optimization
2019-08-22 12:10 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Erratically behaving query needs optimization
2019-08-22 12:22 UTC Barbu Paul - Gheorghe <barbu.paul.gheorghe@gmail.com>
` Re: Erratically behaving query needs optimization
2019-08-22 12:49 UTC Barbu Paul - Gheorghe <barbu.paul.gheorghe@gmail.com>
` Re: Erratically behaving query needs optimization
2019-08-22 17:43 UTC legrand legrand <legrand_legrand@hotmail.com>
` Re: Erratically behaving query needs optimization
2019-08-25 14:50 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Erratically behaving query needs optimization
2019-08-26 08:25 UTC Barbu Paul - Gheorghe <barbu.paul.gheorghe@gmail.com>
` Re: Erratically behaving query needs optimization
2019-08-26 11:51 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Erratically behaving query needs optimization
2019-09-02 21:57 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Erratically behaving query needs optimization
2019-09-03 12:41 UTC Barbu Paul - Gheorghe <barbu.paul.gheorghe@gmail.com>
[15+ messages in thread]
Extremely slow HashAggregate in simple UNION query
2019-08-20 15:11 UTC Felix Geisendörfer <felix@felixge.de>
` Re: Extremely slow HashAggregate in simple UNION query
2019-08-20 16:19 UTC Michael Lewis <mlewis@entrata.com>
` Re: Extremely slow HashAggregate in simple UNION query
2019-08-20 16:57 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Extremely slow HashAggregate in simple UNION query
2019-08-20 17:32 UTC Andres Freund <andres@anarazel.de>
` Re: Extremely slow HashAggregate in simple UNION query
2019-08-20 17:55 UTC Felix Geisendörfer <felix@felixge.de>
` Re: Extremely slow HashAggregate in simple UNION query
2019-08-20 18:27 UTC Andres Freund <andres@anarazel.de>
` Re: Extremely slow HashAggregate in simple UNION query
2019-08-21 18:26 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Extremely slow HashAggregate in simple UNION query
2019-08-22 05:08 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Extremely slow HashAggregate in simple UNION query
2019-08-22 09:06 UTC Felix Geisendörfer <felix@felixge.de>
` Re: Extremely slow HashAggregate in simple UNION query
2019-08-24 19:16 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Extremely slow HashAggregate in simple UNION query
2019-08-24 19:41 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Extremely slow HashAggregate in simple UNION query
2019-08-24 19:54 UTC Andres Freund <andres@anarazel.de>
[12+ messages in thread]
pg_basebackup is taking an unusually long time with Postgres 11.3
2019-08-24 03:24 UTC andy andy <brookline.andy@gmail.com>
Extremely slow count (simple query, with index)
2019-08-22 12:44 UTC Marco Colli <collimarco91@gmail.com>
` Re: Extremely slow count (simple query, with index)
2019-08-22 13:19 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Extremely slow count (simple query, with index)
2019-08-22 13:25 UTC Ravikumar Reddy <urravikumarreddy@gmail.com>
` Re: Extremely slow count (simple query, with index)
2019-08-22 13:25 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Extremely slow count (simple query, with index)
2019-08-22 17:37 UTC Michael Lewis <mlewis@entrata.com>
` Re: Extremely slow count (simple query, with index)
2019-08-22 17:54 UTC Marco Colli <collimarco91@gmail.com>
` Re: Extremely slow count (simple query, with index)
2019-08-22 18:04 UTC Justin Pryzby <pryzby@telsasoft.com>
[7+ messages in thread]
Partial join
2019-07-29 16:43 UTC Arne Roland <A.Roland@index.de>
` Partial join
2019-08-01 08:07 UTC Arne Roland <A.Roland@index.de>
` Re: Partial join
2019-08-01 11:14 UTC Richard Guo <riguo@pivotal.io>
` Re: Partial join
2019-08-01 11:46 UTC Arne Roland <A.Roland@index.de>
` Re: Partial join
2019-08-01 14:14 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Partial join
2019-08-01 16:29 UTC Arne Roland <A.Roland@index.de>
` Re: Partial join
2019-08-02 09:33 UTC Richard Guo <riguo@pivotal.io>
` Re: Partial join
2019-08-02 10:00 UTC Richard Guo <riguo@pivotal.io>
` Re: Partial join
2019-08-19 15:17 UTC Arne Roland <A.Roland@index.de>
[9+ messages in thread]
pg11 list partitions vs hash partitions
2019-08-19 12:32 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
Continuous Performance Test
2019-08-14 16:18 UTC Jean Baro <jfbaro@gmail.com>
` Continuous Performance Test
2019-08-14 17:56 UTC Jean Baro <jfbaro@gmail.com>
` Re: Continuous Performance Test
2019-08-14 20:57 UTC Nasby, Jim <nasbyj@amazon.com>
` Re: [UNVERIFIED SENDER] Re: Continuous Performance Test
2019-08-14 20:59 UTC Nasby, Jim <nasbyj@amazon.com>
` Re: [UNVERIFIED SENDER] Re: Continuous Performance Test
2019-08-16 01:33 UTC Jean Baro <jfbaro@gmail.com>
[5+ messages in thread]
ORA-24345: A Truncation or null fetch error occurred -ora2pg
2019-08-13 08:23 UTC Daulat Ram <Daulat.Ram@exponential.com>
` Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg
2019-08-13 15:02 UTC Luca Ferrari <fluca1978@gmail.com>
` RE: ORA-24345: A Truncation or null fetch error occurred -ora2pg
2019-08-13 17:34 UTC Daulat Ram <Daulat.Ram@exponential.com>
` Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg
2019-08-13 17:57 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` RE: ORA-24345: A Truncation or null fetch error occurred -ora2pg
2019-08-14 09:39 UTC Daulat Ram <Daulat.Ram@exponential.com>
` Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg
2019-08-14 14:13 UTC Adrian Klaver <adrian.klaver@aklaver.com>
[6+ messages in thread]
performance bottlenecks on lock transactionid
2019-08-13 14:15 UTC =?gb18030?B?zfXI9Omq?= <wrn@hljdx.net>
` Re: performance bottlenecks on lock transactionid
2019-08-14 07:31 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` re:Re: performance bottlenecks on lock transactionid
2019-08-14 07:57 UTC =?utf-8?B?546L6Iul5qWg?= <wrn@hljdx.net>
` Re: Re: performance bottlenecks on lock transactionid
2019-08-14 10:25 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[4+ messages in thread]
Last event per user
2019-08-12 20:57 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Last event per user
2019-08-12 21:56 UTC Michael Lewis <mlewis@entrata.com>
` Re: Last event per user
2019-08-12 22:28 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Last event per user
2019-08-12 22:35 UTC Michael Lewis <mlewis@entrata.com>
` Re: Last event per user
2019-08-12 23:03 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Last event per user
2019-08-12 23:09 UTC Michael Lewis <mlewis@entrata.com>
` Re: Last event per user
2019-08-13 11:34 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
[7+ messages in thread]
zabbix on postgresql - very slow delete of events
2019-07-23 08:07 UTC Kristian Ejvind <Kristian.Ejvind@resurs.se>
` Re: zabbix on postgresql - very slow delete of events
2019-07-23 12:58 UTC Kenneth Marshall <ktm@rice.edu>
` Re: zabbix on postgresql - very slow delete of events
2019-07-23 13:41 UTC Kristian Ejvind <Kristian.Ejvind@resurs.se>
` Re: zabbix on postgresql - very slow delete of events
2019-07-23 14:33 UTC Kenneth Marshall <ktm@rice.edu>
` Re: zabbix on postgresql - very slow delete of events
2019-07-24 08:11 UTC Kristian Ejvind <Kristian.Ejvind@resurs.se>
` Re: zabbix on postgresql - very slow delete of events
2019-07-24 13:54 UTC Maxim Boguk <maxim.boguk@gmail.com>
` Re: zabbix on postgresql - very slow delete of events
2019-07-24 14:05 UTC Maxim Boguk <maxim.boguk@gmail.com>
` Re: zabbix on postgresql - very slow delete of events
2019-07-24 15:12 UTC Kristian Ejvind <Kristian.Ejvind@resurs.se>
` Re: zabbix on postgresql - very slow delete of events
2019-07-24 17:16 UTC Maxim Boguk <maxim.boguk@gmail.com>
` Re: zabbix on postgresql - very slow delete of events
2019-08-13 11:08 UTC Kristian Ejvind <Kristian.Ejvind@resurs.se>
[10+ messages in thread]
Strange runtime partition pruning behaviour with 11.4
2019-08-02 13:58 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Strange runtime partition pruning behaviour with 11.4
2019-08-03 13:16 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Strange runtime partition pruning behaviour with 11.4
2019-08-03 13:42 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: Strange runtime partition pruning behaviour with 11.4
2019-08-03 14:06 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Strange runtime partition pruning behaviour with 11.4
2019-08-03 15:18 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: Strange runtime partition pruning behaviour with 11.4
2019-08-03 16:05 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Strange runtime partition pruning behaviour with 11.4
2019-08-03 16:49 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Strange runtime partition pruning behaviour with 11.4
2019-08-05 07:29 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Strange runtime partition pruning behaviour with 11.4
2019-08-13 07:02 UTC Sverre Boschman <s.r.boschman@gmail.com>
[9+ messages in thread]
ODP: Planner performance in partitions
2019-08-12 20:03 UTC Piotr Włodarczyk <piotrwlodarczyk89@gmail.com>
` ODP: Planner performance in partitions
2019-08-13 06:29 UTC Piotr Włodarczyk <piotrwlodarczyk89@gmail.com>
[2+ messages in thread]
Re:
2019-08-12 22:43 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re:
2019-08-12 22:53 UTC Michael Lewis <mlewis@entrata.com>
[2+ messages in thread]
Planner performance in partitions
2019-08-12 12:37 UTC =?iso-8859-2?Q?Piotr_W=B3odarczyk?= <piotr.wlodarczyk@gnb.pl>
` Re: Planner performance in partitions
2019-08-12 19:05 UTC Michael Lewis <mlewis@entrata.com>
` Re: Planner performance in partitions
2019-08-12 19:24 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Planner performance in partitions
2019-08-12 20:25 UTC Michael Lewis <mlewis@entrata.com>
` Re: Planner performance in partitions
2019-08-12 22:25 UTC David Rowley <david.rowley@2ndquadrant.com>
` Re: Planner performance in partitions
2019-08-12 22:37 UTC Michael Lewis <mlewis@entrata.com>
[6+ messages in thread]
Bitmap heap scan performance
2019-08-09 08:41 UTC Rob Emery <re-pgsql@codeweavers.net>
` Re: Bitmap heap scan performance
2019-08-09 12:30 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Bitmap heap scan performance
2019-08-12 13:00 UTC Rob Emery <re-pgsql@codeweavers.net>
` Re: Bitmap heap scan performance
2019-08-12 13:29 UTC Jeremy Finzel <finzelj@gmail.com>
[4+ messages in thread]
Postgres not using correct indices for views.
2019-08-08 12:02 UTC Thomas Rosenstein <thomas.rosenstein@creamfinance.com>
` Re: Postgres not using correct indices for views.
2019-08-08 16:05 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres not using correct indices for views.
2019-08-08 20:04 UTC Thomas Rosenstein <thomas.rosenstein@creamfinance.com>
` Re: Postgres not using correct indices for views.
2019-08-08 20:30 UTC Thomas Rosenstein <thomas.rosenstein@creamfinance.com>
` Re: Postgres not using correct indices for views.
2019-08-08 22:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres not using correct indices for views.
2019-08-09 15:16 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres not using correct indices for views.
2019-08-10 10:05 UTC Thomas Rosenstein <thomas.rosenstein@creamfinance.com>
` Re: Postgres not using correct indices for views.
2019-08-10 11:11 UTC Michaeldba@sqlexec.com <Michaeldba@sqlexec.com>
` Re: Postgres not using correct indices for views.
2019-08-11 20:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
[9+ messages in thread]
improving windows functions performance
2019-08-05 20:47 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: improving windows functions performance
2019-08-05 21:15 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
[2+ messages in thread]
PSQL performance - TPS
2019-08-01 03:10 UTC Shital A <brightuser2019@gmail.com>
` Re: PSQL performance - TPS
2019-08-01 05:15 UTC Gavin Flower <GavinFlower@archidevsys.co.nz>
` Re: PSQL performance - TPS
2019-08-01 05:18 UTC Shital A <brightuser2019@gmail.com>
` Re: PSQL performance - TPS
2019-08-01 17:21 UTC Andres Freund <andres@anarazel.de>
` Re: PSQL performance - TPS
2019-08-01 18:06 UTC Purav Chovatia <puravc@gmail.com>
` Re: PSQL performance - TPS
2019-08-01 18:14 UTC Andres Freund <andres@anarazel.de>
` Re: PSQL performance - TPS
2019-08-01 18:27 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: PSQL performance - TPS
2019-08-02 04:59 UTC Shital A <brightuser2019@gmail.com>
` Re: PSQL performance - TPS
2019-08-02 11:04 UTC Imre Samu <pella.samu@gmail.com>
[9+ messages in thread]
Oracle to postgres migration via ora2pg (blob data)
2019-07-31 11:31 UTC Daulat Ram <Daulat.Ram@exponential.com>
` Re: Oracle to postgres migration via ora2pg (blob data)
2019-07-31 16:02 UTC Amol Tarte <amoltarte@gmail.com>
` Re: Oracle to postgres migration via ora2pg (blob data)
2019-07-31 21:05 UTC Gilles Darold <gilles@darold.net>
[3+ messages in thread]
8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
2009-03-13 12:44 UTC Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
2009-03-13 13:43 UTC Gregory Stark <stark@enterprisedb.com>
` Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
2009-03-13 13:57 UTC Gregory Stark <stark@enterprisedb.com>
` Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
2009-03-13 15:20 UTC Alan Stange <stange@rentec.com>
` Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
2009-03-13 17:15 UTC Greg Smith <gsmith@gregsmith.com>
` Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
2009-03-13 17:23 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
2009-03-14 01:58 UTC Gregory Stark <stark@enterprisedb.com>
` Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
2009-03-14 02:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
2009-03-14 02:37 UTC Robert Haas <robertmhaas@gmail.com>
` Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
2009-03-14 04:02 UTC Gregory Stark <stark@enterprisedb.com>
` Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
2009-03-14 15:52 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
2009-04-02 23:08 UTC Bruce Momjian <bruce@momjian.us>
` Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
2009-04-07 22:49 UTC Bruce Momjian <bruce@momjian.us>
` SV: Oracle to postgres migration via ora2pg (blob data)
2019-07-31 11:45 UTC Niels Jespersen <NJN@dst.dk>
[14+ messages in thread]
A question regarding streaming replication
2019-07-31 09:28 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: A question regarding streaming replication
2019-07-31 09:41 UTC Fabio Pardi <f.pardi@portavita.eu>
` Re: A question regarding streaming replication
2019-07-31 09:45 UTC Holger Jakobs <holger@jakobs.com>
[3+ messages in thread]
High concurrency same row (inventory)
2019-07-29 06:17 UTC Jean Baro <jfbaro@gmail.com>
` Re: High concurrency same row (inventory)
2019-07-29 12:35 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: High concurrency same row (inventory)
2019-07-29 12:53 UTC Jayadevan M <maymala.jayadevan@gmail.com>
` Re: High concurrency same row (inventory)
2019-07-29 12:55 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: High concurrency same row (inventory)
2019-07-29 18:09 UTC Jean Baro <jfbaro@gmail.com>
` Re: High concurrency same row (inventory)
2019-07-29 18:12 UTC Michael Lewis <mlewis@entrata.com>
` Re: High concurrency same row (inventory)
2019-07-30 00:04 UTC Jean Baro <jfbaro@gmail.com>
` Re: High concurrency same row (inventory)
2019-07-30 00:06 UTC Jean Baro <jfbaro@gmail.com>
` Re: High concurrency same row (inventory)
2019-07-30 00:26 UTC Jean Baro <jfbaro@gmail.com>
` Re: High concurrency same row (inventory)
2019-07-30 01:13 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: High concurrency same row (inventory)
2019-07-30 01:23 UTC Jean Baro <jfbaro@gmail.com>
[11+ messages in thread]
Standard uuid vs. custom data type uuid_v1
2019-07-25 09:26 UTC Ancoron Luciferis <ancoron.luciferis@googlemail.com>
` Re: Standard uuid vs. custom data type uuid_v1
2019-07-27 13:47 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Standard uuid vs. custom data type uuid_v1
2019-07-29 08:13 UTC Ancoron Luciferis <ancoron.luciferis@googlemail.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