pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: proposal: schema variables - doc
2021-03-17 12:05 UTC Erik Rijkers <er@xs4all.nl>
` Re: proposal: schema variables - doc
2021-03-22 09:47 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: proposal: schema variables - doc
2021-03-25 08:05 UTC Pavel Stehule <pavel.stehule@gmail.com>
[3+ messages in thread]
Odd (slow) plan choice with min/max
2021-03-23 04:00 UTC Paul McGarry <paul@paulmcgarry.com>
` Re: Odd (slow) plan choice with min/max
2021-03-23 05:13 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Odd (slow) plan choice with min/max
2021-03-23 06:51 UTC Paul McGarry <paul@paulmcgarry.com>
` Re: Odd (slow) plan choice with min/max
2021-03-23 13:07 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Odd (slow) plan choice with min/max
2021-03-23 21:38 UTC Paul McGarry <paul@paulmcgarry.com>
` Re: Odd (slow) plan choice with min/max
2021-03-24 09:26 UTC Yoan SULTAN <yeyeyo@gmail.com>
[6+ messages in thread]
SQL performance issue (postgresql chooses a bad plan when a better one is available)
2021-03-22 13:10 UTC Chris Stephens <cstephens16@gmail.com>
` Re: SQL performance issue (postgresql chooses a bad plan when a better one is available)
2021-03-22 14:54 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: SQL performance issue (postgresql chooses a bad plan when a better one is available)
2021-03-22 17:28 UTC Chris Stephens <cstephens16@gmail.com>
` Re: SQL performance issue (postgresql chooses a bad plan when a better one is available)
2021-03-22 21:39 UTC Hannu Krosing <hannuk@google.com>
` Re: SQL performance issue (postgresql chooses a bad plan when a better one is available)
2021-03-23 15:21 UTC Chris Stephens <cstephens16@gmail.com>
` Re: SQL performance issue (postgresql chooses a bad plan when a better one is available)
2021-03-23 23:20 UTC Hannu Krosing <hannuk@google.com>
[6+ messages in thread]
Extremely inefficient merge-join
2021-03-17 16:10 UTC Marcin Gozdalik <gozdal@gmail.com>
` Re: Extremely inefficient merge-join
2021-03-17 20:47 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Extremely inefficient merge-join
2021-03-17 21:27 UTC Marcin Gozdalik <gozdal@gmail.com>
[3+ messages in thread]
wide table, many many partitions, poor query performance
2021-03-15 16:53 UTC S Bob <sbob@quadratum-braccas.com>
` Re: wide table, many many partitions, poor query performance
2021-03-15 17:03 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: wide table, many many partitions, poor query performance
2021-03-15 17:03 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[3+ messages in thread]
FreeBSD UFS & fsync
2021-02-22 16:48 UTC Luca Ferrari <fluca1978@gmail.com>
` Re: FreeBSD UFS & fsync
2021-02-22 21:37 UTC Thomas Munro <thomas.munro@gmail.com>
` Re: FreeBSD UFS & fsync
2021-02-23 07:46 UTC Luca Ferrari <fluca1978@gmail.com>
` Re: FreeBSD UFS & fsync
2021-02-23 11:57 UTC Luca Ferrari <fluca1978@gmail.com>
` Re: FreeBSD UFS & fsync
2021-03-11 14:29 UTC Bruce Momjian <bruce@momjian.us>
` Re: FreeBSD UFS & fsync
2021-03-12 09:08 UTC Luca Ferrari <fluca1978@gmail.com>
` Re: FreeBSD UFS & fsync
2021-03-12 09:33 UTC Thomas Munro <thomas.munro@gmail.com>
` Re: FreeBSD UFS & fsync
2021-03-12 19:39 UTC Bruce Momjian <bruce@momjian.us>
` Re: FreeBSD UFS & fsync
2021-03-15 13:35 UTC Luca Ferrari <fluca1978@gmail.com>
[9+ messages in thread]
Is there a known bug with SKIP LOCKED and "tuple to be locked was already moved to another partition due to concurrent update"?
2020-06-30 16:10 UTC Gunther Schadow <gunther@pragmaticdata.com>
` Re: Is there a known bug with SKIP LOCKED and "tuple to be locked was already moved to another partition due to concurrent update"?
2020-08-11 22:58 UTC Jim Jarvie <jim@talentstack.to>
` Re: Is there a known bug with SKIP LOCKED and "tuple to be locked was already moved to another partition due to concurrent update"?
2021-03-11 21:12 UTC Kamil Dziedzic <kamil@dziedzic.es>
` Re: Is there a known bug with SKIP LOCKED and "tuple to be locked was already moved to another partition due to concurrent update"?
2021-03-12 16:22 UTC Michael Lewis <mlewis@entrata.com>
` Re: Is there a known bug with SKIP LOCKED and "tuple to be locked was already moved to another partition due to concurrent update"?
2021-03-12 16:30 UTC Kamil Dziedzic <kamil@dziedzic.es>
[5+ messages in thread]
Fwd: different execution time for the same query (and same DB status)
2021-03-06 21:40 UTC Francesco De Angelis <franc.tozzus@gmail.com>
` RE: different execution time for the same query (and same DB status)
2021-03-07 14:51 UTC Michel SALAIS <msalais@msym.fr>
` Re: different execution time for the same query (and same DB status)
2021-03-07 15:08 UTC Julien Rouhaud <rjuju123@gmail.com>
` Re: different execution time for the same query (and same DB status)
2021-03-07 16:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: different execution time for the same query (and same DB status)
2021-03-08 17:03 UTC Michael Lewis <mlewis@entrata.com>
` Re: different execution time for the same query (and same DB status)
2021-03-09 22:58 UTC Francesco De Angelis <franc.tozzus@gmail.com>
` Re: Fwd: different execution time for the same query (and same DB status)
2021-03-10 08:27 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Fwd: different execution time for the same query (and same DB status)
2021-03-10 11:48 UTC Francesco De Angelis <franc.tozzus@gmail.com>
` Re: Fwd: different execution time for the same query (and same DB status)
2021-03-10 13:29 UTC Michael Lewis <mlewis@entrata.com>
` Re: Fwd: different execution time for the same query (and same DB status)
2021-03-12 13:39 UTC Francesco De Angelis <franc.tozzus@gmail.com>
[10+ messages in thread]
Users grants with setting options
2021-03-08 23:30 UTC Nagaraj Raj <nagaraj.sf@yahoo.com>
` Re: Users grants with setting options
2021-03-08 23:46 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Users grants with setting options
2021-03-08 23:48 UTC Nagaraj Raj <nagaraj.sf@yahoo.com>
[3+ messages in thread]
Slow query performance inside a transaction on a clean database
2021-03-05 17:55 UTC val.janeiko@gmail.com
` Re: Slow query performance inside a transaction on a clean database
2021-03-08 09:17 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[2+ messages in thread]
Potential performance issues related to group by and covering index
2021-03-02 04:44 UTC Liu, Xinyu <liuxy@gatech.edu>
` Re: Potential performance issues related to group by and covering index
2021-03-02 09:08 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Potential performance issues related to group by and covering index
2021-03-02 09:49 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Potential performance issues related to group by and covering index
2021-03-02 21:04 UTC Michael Lewis <mlewis@entrata.com>
` Re: Potential performance issues related to group by and covering index
2021-03-02 21:41 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Potential performance issues related to group by and covering index
2021-03-05 01:14 UTC Hannu Krosing <hannuk@google.com>
[6+ messages in thread]
tables meta data collection
2021-03-03 01:20 UTC Nagaraj Raj <nagaraj.sf@yahoo.com>
` Re: tables meta data collection
2021-03-03 04:20 UTC Justin Pryzby <pryzby@telsasoft.com>
[2+ messages in thread]
Performance issues related to left join and order by
2021-03-02 04:47 UTC Liu, Xinyu <liuxy@gatech.edu>
` Re: Performance issues related to left join and order by
2021-03-02 10:26 UTC David Rowley <dgrowleyml@gmail.com>
[2+ messages in thread]
Potential performance issues
2021-02-28 15:04 UTC Jung, Jinho <jinho.jung@gatech.edu>
` Re: Potential performance issues
2021-03-01 12:59 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: Potential performance issues
2021-03-01 13:04 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Potential performance issues
2021-03-01 13:05 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Potential performance issues
2021-03-01 13:44 UTC Bob Jolliffe <bobjolliffe@gmail.com>
` Re: Potential performance issues
2021-03-01 14:41 UTC Jung, Jinho <jinho.jung@gatech.edu>
` Re: Potential performance issues
2021-03-01 14:44 UTC Thomas Kellerer <shammat@gmx.net>
` Re: Potential performance issues
2021-03-01 14:53 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Potential performance issues
2021-03-01 15:06 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Potential performance issues
2021-03-01 16:58 UTC Hannu Krosing <hannuk@google.com>
[10+ messages in thread]
Postgres performance comparing GCP and AWS
2021-02-23 18:12 UTC Maurici Meneghetti <maurici.meneghetti@bixtecnologia.com.br>
` Re: Postgres performance comparing GCP and AWS
2021-02-24 13:10 UTC Gunther Schadow <raj@gusw.net>
` Re: Postgres performance comparing GCP and AWS
2021-02-24 13:15 UTC Milos Babic <milos.babic@gmail.com>
` Re: Postgres performance comparing GCP and AWS
2021-02-24 13:35 UTC Julien Rouhaud <rjuju123@gmail.com>
` Re: Postgres performance comparing GCP and AWS
2021-02-24 15:11 UTC Igor Gois <igor@bixtecnologia.com.br>
` Re: Postgres performance comparing GCP and AWS
2021-02-24 15:16 UTC Imre Samu <pella.samu@gmail.com>
` Re: Postgres performance comparing GCP and AWS
2021-02-25 18:13 UTC Philip Semanchuk <philip@americanefficient.com>
` Re: Postgres performance comparing GCP and AWS
2021-02-25 20:46 UTC Igor Gois <igor@bixtecnologia.com.br>
` Re: Postgres performance comparing GCP and AWS
2021-02-25 20:53 UTC Philip Semanchuk <philip@americanefficient.com>
` Re: Postgres performance comparing GCP and AWS
2021-02-25 21:04 UTC Igor Gois <igor@bixtecnologia.com.br>
` Re: Postgres performance comparing GCP and AWS
2021-02-25 22:32 UTC Philip Semanchuk <philip@americanefficient.com>
` Re: Postgres performance comparing GCP and AWS
2021-02-26 01:06 UTC Justin Pitts <justinpitts@gmail.com>
` Re: Postgres performance comparing GCP and AWS
2021-03-01 16:01 UTC Hannu Krosing <hannuk@google.com>
[13+ messages in thread]
Disabling options lowers the estimated cost of a query
2021-02-25 23:07 UTC Arne Roland <A.Roland@index.de>
` Re: Disabling options lowers the estimated cost of a query
2021-02-26 03:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Autovacuum not functioning for large tables but it is working for few other small tables.
2020-12-16 11:54 UTC M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>
` RE: Autovacuum not functioning for large tables but it is working for few other small tables.
2020-12-16 11:55 UTC M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>
` Re: Autovacuum not functioning for large tables but it is working for few other small tables.
2020-12-16 15:14 UTC Martín Marqués <martin.marques@gmail.com>
` Re: Autovacuum not functioning for large tables but it is working for few other small tables.
2020-12-16 15:28 UTC Michael Lewis <mlewis@entrata.com>
` Re: Autovacuum not functioning for large tables but it is working for few other small tables.
2020-12-16 18:18 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Autovacuum not functioning for large tables but it is working for few other small tables.
2020-12-17 01:46 UTC Tomas Vondra <tomas.vondra@enterprisedb.com>
` RE: Autovacuum not functioning for large tables but it is working for few other small tables.
2021-01-08 11:59 UTC M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>
` RE: Autovacuum not functioning for large tables but it is working for few other small tables.
2021-01-08 12:01 UTC M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>
` Re: Autovacuum not functioning for large tables but it is working for few other small tables.
2021-01-08 15:52 UTC Michael Lewis <mlewis@entrata.com>
` RE: Autovacuum not functioning for large tables but it is working for few other small tables.
2021-02-19 10:51 UTC M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>
` Re: Autovacuum not functioning for large tables but it is working for few other small tables.
2021-02-19 13:29 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[11+ messages in thread]
Slow query and wrong row estimates for CTE
2021-02-15 17:49 UTC Dane Foster <studdugie@gmail.com>
` Re: Slow query and wrong row estimates for CTE
2021-02-15 22:32 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Slow query and wrong row estimates for CTE
2021-02-16 15:12 UTC Michael Lewis <mlewis@entrata.com>
` Re: Slow query and wrong row estimates for CTE
2021-02-16 15:19 UTC Dane Foster <studdugie@gmail.com>
` Re: Slow query and wrong row estimates for CTE
2021-02-16 15:25 UTC Dane Foster <studdugie@gmail.com>
` Re: Slow query and wrong row estimates for CTE
2021-02-16 19:11 UTC Dane Foster <studdugie@gmail.com>
` Re: Slow query and wrong row estimates for CTE
2021-02-17 16:51 UTC Dane Foster <studdugie@gmail.com>
` Re: Slow query and wrong row estimates for CTE
2021-02-17 18:37 UTC Yoan SULTAN <yeyeyo@gmail.com>
` Re: Slow query and wrong row estimates for CTE
2021-02-17 20:32 UTC Dane Foster <studdugie@gmail.com>
` Re: Slow query and wrong row estimates for CTE
2021-02-18 04:33 UTC Yoan SULTAN <yeyeyo@gmail.com>
[10+ messages in thread]
Understanding logical replication lag
2021-01-21 18:21 UTC Patrick Molgaard <draaglom@gmail.com>
High COMMIT times
2021-01-06 16:19 UTC Don Seiler <don@seiler.us>
` Re: High COMMIT times
2021-01-06 16:51 UTC Joshua Drake <jd@commandprompt.com>
` Re: High COMMIT times
2021-01-06 18:06 UTC Don Seiler <don@seiler.us>
` Re: High COMMIT times
2021-01-06 18:53 UTC Joshua Drake <jd@commandprompt.com>
` Re: High COMMIT times
2021-01-06 19:15 UTC Kenneth Marshall <ktm@rice.edu>
` Re: High COMMIT times
2021-01-06 20:06 UTC Don Seiler <don@seiler.us>
` Re: High COMMIT times
2021-01-07 02:02 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: High COMMIT times
2021-01-07 17:49 UTC Craig Jackson <craig.jackson@broadcom.com>
` Re: High COMMIT times
2021-01-07 18:03 UTC Don Seiler <don@seiler.us>
` Re: High COMMIT times
2021-01-08 09:05 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: High COMMIT times
2021-01-08 17:51 UTC José Arthur Benetasso Villanova <jose.arthur@gmail.com>
` Re: High COMMIT times
2021-01-08 19:04 UTC Don Seiler <don@seiler.us>
` Re: High COMMIT times
2021-01-08 21:01 UTC Craig Jackson <craig.jackson@broadcom.com>
` Re: High COMMIT times
2021-01-09 20:07 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: High COMMIT times
2021-01-11 00:42 UTC Don Seiler <don@seiler.us>
` Re: High COMMIT times
2021-01-11 15:05 UTC Craig Jackson <craig.jackson@broadcom.com>
` Re: High COMMIT times
2021-01-11 15:23 UTC Don Seiler <don@seiler.us>
` Re: High COMMIT times
2021-01-15 21:18 UTC Don Seiler <don@seiler.us>
[18+ messages in thread]
RE: Need information on how MM frees up disk space (vaccum) after scheduled DB cleanup by BGwCronScript/BGwLogCleaner
2021-01-14 12:09 UTC M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>
How to deal with analyze gathering irrelevant stats
2021-01-11 15:50 UTC Rémi Chatenay <remi.chatenay@doctolib.com>
` Re: How to deal with analyze gathering irrelevant stats
2021-01-11 16:29 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: How to deal with analyze gathering irrelevant stats
2021-01-11 16:37 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: How to deal with analyze gathering irrelevant stats
2021-01-11 16:47 UTC Michael Lewis <mlewis@entrata.com>
` Re: How to deal with analyze gathering irrelevant stats
2021-01-11 16:52 UTC Rémi Chatenay <remi.chatenay@doctolib.com>
` Re: How to deal with analyze gathering irrelevant stats
2021-01-11 18:26 UTC Michael Lewis <mlewis@entrata.com>
[6+ messages in thread]
Slow recursive CTE query questions, with row estimate and n_distinct issues
2020-12-28 14:50 UTC Christopher Baines <mail@cbaines.net>
` Re: Slow recursive CTE query questions, with row estimate and n_distinct issues
2020-12-28 15:12 UTC Michael Lewis <mlewis@entrata.com>
` Re: Slow recursive CTE query questions, with row estimate and n_distinct issues
2020-12-28 16:09 UTC Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Slow recursive CTE query questions, with row estimate and n_distinct issues
2020-12-29 22:40 UTC Christopher Baines <mail@cbaines.net>
` Re: Slow recursive CTE query questions, with row estimate and n_distinct issues
2020-12-29 22:45 UTC Christopher Baines <mail@cbaines.net>
[5+ messages in thread]
Conundrum with scaling out of bottleneck with hot standby, PgPool-II, etc.
2020-12-23 18:01 UTC Gunther Schadow <raj@gusw.net>
` Re: Conundrum with scaling out of bottleneck with hot standby, PgPool-II, etc.
2020-12-23 18:34 UTC Marco Colli <collimarco91@gmail.com>
` Re: Conundrum with scaling out of bottleneck with hot standby, PgPool-II, etc.
2020-12-23 19:09 UTC Bruce Momjian <bruce@momjian.us>
[3+ messages in thread]
Reversing NULLS in ORDER causes index not to be used?
2020-12-19 01:53 UTC Ken Tanzer <ken.tanzer@gmail.com>
` Re: Reversing NULLS in ORDER causes index not to be used?
2020-12-19 02:02 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Reversing NULLS in ORDER causes index not to be used?
2020-12-19 02:30 UTC Ken Tanzer <ken.tanzer@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