pgsql-performance

Messages by Date

2021/04/03 Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai
2021/04/03 Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai
2021/04/03 Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Bruce Momjian
2021/04/03 Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai
2021/04/03 Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Bruce Momjian
2021/04/03 Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai
2021/04/03 Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Bruce Momjian
2021/04/03 Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai
2021/04/03 Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Justin Pryzby
2021/04/03 Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Michael Lewis
2021/04/03 Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Pavel Stehule
2021/04/03 Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Bharath Rupireddy
2021/04/03 SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai
2021/04/01 Re: High availability management tool. Adalberto Caccia
2021/04/01 Re: High availability management tool. Hüseyin Demir
2021/04/01 Re: High availability management tool. Dorian Hoxha
2021/03/30 Re: High-volume writes - what is the max throughput possible Hannu Krosing
2021/03/26 Re: High-volume writes - what is the max throughput possible Frits Jalvingh
2021/03/26 High-volume writes - what is the max throughput possible Geervan Hayatnagarkar
2021/03/26 Re: How do we hint a query to use index in postgre Nikhil Shetty
2021/03/24 Re: Odd (slow) plan choice with min/max Yoan SULTAN
2021/03/23 Re: SQL performance issue (postgresql chooses a bad plan when a better one is available) Hannu Krosing
2021/03/23 Re: Odd (slow) plan choice with min/max Paul McGarry
2021/03/23 Re: SQL performance issue (postgresql chooses a bad plan when a better one is available) Chris Stephens
2021/03/23 Re: Odd (slow) plan choice with min/max Rick Otten
2021/03/22 Re: Odd (slow) plan choice with min/max Paul McGarry
2021/03/22 Re: Odd (slow) plan choice with min/max Justin Pryzby
2021/03/22 Odd (slow) plan choice with min/max Paul McGarry
2021/03/22 Re: SQL performance issue (postgresql chooses a bad plan when a better one is available) Hannu Krosing
2021/03/22 Re: SQL performance issue (postgresql chooses a bad plan when a better one is available) Chris Stephens
2021/03/22 Re: SQL performance issue (postgresql chooses a bad plan when a better one is available) Laurenz Albe
2021/03/22 SQL performance issue (postgresql chooses a bad plan when a better one is available) Chris Stephens
2021/03/18 Re: How do we hint a query to use index in postgre Manish Lad
2021/03/18 Re: How do we hint a query to use index in postgre Gaetano Mendola
2021/03/18 How do we hint a query to use index in postgre Manish Lad
2021/03/17 Re: Extremely inefficient merge-join Marcin Gozdalik
2021/03/17 Re: Extremely inefficient merge-join Tom Lane
2021/03/17 Extremely inefficient merge-join Marcin Gozdalik
2021/03/15 Re: wide table, many many partitions, poor query performance Laurenz Albe
2021/03/15 Re: wide table, many many partitions, poor query performance Justin Pryzby
2021/03/15 wide table, many many partitions, poor query performance S Bob
2021/03/15 Re: FreeBSD UFS & fsync Luca Ferrari
2021/03/12 Re: FreeBSD UFS & fsync Bruce Momjian
2021/03/12 Re: Is there a known bug with SKIP LOCKED and "tuple to be locked was already moved to another partition due to concurrent update"? Kamil Dziedzic
2021/03/12 Re: Is there a known bug with SKIP LOCKED and "tuple to be locked was already moved to another partition due to concurrent update"? Michael Lewis
2021/03/12 Re: Fwd: different execution time for the same query (and same DB status) Francesco De Angelis
2021/03/12 Re: FreeBSD UFS & fsync Thomas Munro
2021/03/12 Re: FreeBSD UFS & fsync Luca Ferrari
2021/03/11 Re: Is there a known bug with SKIP LOCKED and "tuple to be locked was already moved to another partition due to concurrent update"? Kamil Dziedzic
2021/03/11 Re: FreeBSD UFS & fsync Bruce Momjian
2021/03/10 Re: Fwd: different execution time for the same query (and same DB status) Francesco De Angelis
2021/03/10 Re: Fwd: different execution time for the same query (and same DB status) Michael Lewis
2021/03/10 Re: Fwd: different execution time for the same query (and same DB status) Justin Pryzby
2021/03/10 Re: different execution time for the same query (and same DB status) Francesco De Angelis
2021/03/08 Re: Users grants with setting options Nagaraj Raj
2021/03/08 Re: Users grants with setting options David G. Johnston
2021/03/08 Users grants with setting options Nagaraj Raj
2021/03/08 Re: different execution time for the same query (and same DB status) Michael Lewis
2021/03/08 Re: Slow query performance inside a transaction on a clean database Laurenz Albe
2021/03/07 Re: different execution time for the same query (and same DB status) Tom Lane
2021/03/07 Re: different execution time for the same query (and same DB status) Julien Rouhaud
2021/03/07 RE: different execution time for the same query (and same DB status) Michel SALAIS
2021/03/07 Fwd: different execution time for the same query (and same DB status) Francesco De Angelis
2021/03/05 Slow query performance inside a transaction on a clean database val.janeiko
2021/03/04 Re: Potential performance issues related to group by and covering index Hannu Krosing
2021/03/02 Re: tables meta data collection Justin Pryzby
2021/03/02 tables meta data collection Nagaraj Raj
2021/03/02 Re: Potential performance issues related to group by and covering index David Rowley
2021/03/02 Re: Potential performance issues related to group by and covering index Michael Lewis
2021/03/02 High availability management tool. Rodriguez Pablo A
2021/03/02 Re: Performance issues related to left join and order by David Rowley
2021/03/02 Re: Potential performance issues related to group by and covering index David Rowley
2021/03/02 Re: Potential performance issues related to group by and covering index Pavel Stehule
2021/03/02 Performance issues related to left join and order by Liu, Xinyu
2021/03/02 Potential performance issues related to group by and covering index Liu, Xinyu
2021/03/01 Re: Potential performance issues Hannu Krosing
2021/03/01 Re: Postgres performance comparing GCP and AWS Hannu Krosing
2021/03/01 Re: Potential performance issues Pavel Stehule
2021/03/01 Re: Potential performance issues Jung, Jinho
2021/03/01 Re: Potential performance issues Rick Otten
2021/03/01 Re: Potential performance issues Thomas Kellerer
2021/03/01 Re: Potential performance issues Bob Jolliffe
2021/03/01 Re: Potential performance issues MichaelDBA
2021/03/01 Re: Potential performance issues MichaelDBA
2021/03/01 Re: Potential performance issues Andrew Dunstan
2021/03/01 Potential performance issues Jung, Jinho
2021/02/26 Re: Postgres performance comparing GCP and AWS Justin Pitts
2021/02/26 Re: Postgres performance comparing GCP and AWS Igor Gois
2021/02/26 Re: Postgres performance comparing GCP and AWS Igor Gois
2021/02/25 Re: Disabling options lowers the estimated cost of a query Tom Lane
2021/02/25 Re: Postgres performance comparing GCP and AWS Philip Semanchuk
2021/02/25 Re: Postgres performance comparing GCP and AWS Philip Semanchuk
2021/02/25 Re: Postgres performance comparing GCP and AWS Philip Semanchuk
2021/02/24 Re: Postgres performance comparing GCP and AWS Igor Gois
2021/02/24 Re: Postgres performance comparing GCP and AWS Imre Samu
2021/02/24 Re: Postgres performance comparing GCP and AWS Julien Rouhaud
2021/02/24 Re: Postgres performance comparing GCP and AWS Milos Babic
2021/02/24 Re: Postgres performance comparing GCP and AWS Gunther Schadow
2021/02/23 Postgres performance comparing GCP and AWS Maurici Meneghetti
2021/02/23 Re: FreeBSD UFS & fsync Luca Ferrari
2021/02/22 Re: FreeBSD UFS & fsync Luca Ferrari
2021/02/22 Re: FreeBSD UFS & fsync Thomas Munro
2021/02/22 FreeBSD UFS & fsync Luca Ferrari
2021/02/19 Re: Autovacuum not functioning for large tables but it is working for few other small tables. Laurenz Albe
2021/02/19 RE: Autovacuum not functioning for large tables but it is working for few other small tables. M Tarkeshwar Rao
2021/02/17 Re: Slow query and wrong row estimates for CTE Yoan SULTAN
2021/02/17 Re: Slow query and wrong row estimates for CTE Dane Foster
2021/02/17 Re: Slow query and wrong row estimates for CTE Yoan SULTAN
2021/02/17 Re: Slow query and wrong row estimates for CTE Dane Foster
2021/02/16 Re: Slow query and wrong row estimates for CTE Dane Foster
2021/02/16 Re: Query performance issue Michael Lewis
2021/02/16 Re: Slow query and wrong row estimates for CTE Dane Foster
2021/02/16 Re: Slow query and wrong row estimates for CTE Dane Foster
2021/02/16 Re: Slow query and wrong row estimates for CTE Michael Lewis
2021/02/15 Re: Slow query and wrong row estimates for CTE Justin Pryzby
2021/02/15 Slow query and wrong row estimates for CTE Dane Foster
2021/02/14 Re: Query performance issue Tomas Vondra
2021/01/21 Re: Query performance issue Justin Pryzby
2021/01/21 Query performance issue Nagaraj Raj
2021/01/21 Understanding logical replication lag Patrick Molgaard
2021/01/15 Re: High COMMIT times Don Seiler
2021/01/14 RE: Need information on how MM frees up disk space (vaccum) after scheduled DB cleanup by BGwCronScript/BGwLogCleaner M Tarkeshwar Rao
2021/01/11 Re: How to deal with analyze gathering irrelevant stats Michael Lewis
2021/01/11 Re: How to deal with analyze gathering irrelevant stats Rémi Chatenay
2021/01/11 Re: How to deal with analyze gathering irrelevant stats Michael Lewis
2021/01/11 Re: How to deal with analyze gathering irrelevant stats Adam Brusselback
2021/01/11 Re: How to deal with analyze gathering irrelevant stats Justin Pryzby
2021/01/11 How to deal with analyze gathering irrelevant stats Rémi Chatenay
2021/01/11 Re: High COMMIT times Don Seiler
2021/01/11 Re: High COMMIT times Craig Jackson
2021/01/10 Re: High COMMIT times Don Seiler
2021/01/09 Re: High COMMIT times Jeff Janes
2021/01/08 Re: High COMMIT times Craig Jackson
2021/01/08 Re: High COMMIT times Don Seiler
2021/01/08 Re: High COMMIT times José Arthur Benetasso Villanova
2021/01/08 Re: Autovacuum not functioning for large tables but it is working for few other small tables. Michael Lewis
2021/01/08 RE: Autovacuum not functioning for large tables but it is working for few other small tables. M Tarkeshwar Rao
2021/01/08 Re: High COMMIT times Laurenz Albe
2021/01/07 Re: High COMMIT times Don Seiler
2021/01/07 Re: High COMMIT times Craig Jackson
2021/01/06 Re: High COMMIT times Laurenz Albe
2021/01/06 Re: High COMMIT times Don Seiler
2021/01/06 Re: High COMMIT times Kenneth Marshall
2021/01/06 Re: High COMMIT times Joshua Drake
2021/01/06 Re: High COMMIT times Don Seiler
2021/01/06 Re: High COMMIT times Joshua Drake
2021/01/06 High COMMIT times Don Seiler
2020/12/29 Re: Slow recursive CTE query questions, with row estimate and n_distinct issues Christopher Baines
2020/12/29 Re: Slow recursive CTE query questions, with row estimate and n_distinct issues Christopher Baines
2020/12/28 Re: Slow recursive CTE query questions, with row estimate and n_distinct issues Greg Spiegelberg
2020/12/28 Re: Slow recursive CTE query questions, with row estimate and n_distinct issues Michael Lewis
2020/12/28 Slow recursive CTE query questions, with row estimate and n_distinct issues Christopher Baines
2020/12/23 Re: Conundrum with scaling out of bottleneck with hot standby, PgPool-II, etc. Bruce Momjian
2020/12/23 Re: Conundrum with scaling out of bottleneck with hot standby, PgPool-II, etc. Marco Colli
2020/12/23 Conundrum with scaling out of bottleneck with hot standby, PgPool-II, etc. Gunther Schadow
2020/12/18 Re: Reversing NULLS in ORDER causes index not to be used? Ken Tanzer
2020/12/18 Re: Reversing NULLS in ORDER causes index not to be used? Tom Lane
2020/12/18 Reversing NULLS in ORDER causes index not to be used? Ken Tanzer
2020/12/18 Re: Oracle to postgresql Ian Lawrence Barwick
2020/12/18 Oracle to postgresql bangalore umesh
2020/12/16 Re: Autovacuum not functioning for large tables but it is working for few other small tables. Tomas Vondra
2020/12/16 RE: Autovacuum not functioning for large tables but it is working for few other small tables. M Tarkeshwar Rao
2020/12/14 Performance issues with composite types (partitioned table) Sebastijan Wieser
2020/12/11 Re: "Required checkpoints occurs too frequently" Christophe Pettus
2020/12/11 Re: "Required checkpoints occurs too frequently" Atul Kumar
2020/12/11 Re: "Required checkpoints occurs too frequently" Amine Tengilimoglu
2020/12/11 Re: "Required checkpoints occurs too frequently" Atul Kumar
2020/12/11 Re: "Required checkpoints occurs too frequently" Laurenz Albe
2020/12/11 "Required checkpoints occurs too frequently" Atul Kumar
2020/12/05 Re: Index for range queries on JSON (user defined fields) Marco Colli
2020/12/04 Re: Index for range queries on JSON (user defined fields) Nick Cleaton
2020/12/04 Re: PostgeSQL JSONB Column with various type of data Michael Lewis
2020/12/04 PostgeSQL JSONB Column with various type of data Riswana Rahman
2020/12/04 Index for range queries on JSON (user defined fields) Marco Colli
2020/12/04 Re: Pg_locks and pg_stat_activity aditya desai
2020/12/04 Re: Pg_locks and pg_stat_activity Justin Pryzby
2020/12/04 Re: Pg_locks and pg_stat_activity aditya desai
2020/12/03 Re: Pg_locks and pg_stat_activity Kyotaro Horiguchi
2020/12/03 Re: Temporarily disable not null constraints Justin Pryzby
2020/12/03 Re: Temporarily disable not null constraints Milos Babic
2020/12/03 Re: Temporarily disable not null constraints Michael Lewis
2020/12/03 Temporarily disable not null constraints Nagaraj Raj
2020/12/03 Re: time taking deletion on large tables Andrew Dunstan
2020/12/03 Re: time taking deletion on large tables Tom Lane
2020/12/03 Re: time taking deletion on large tables Justin Pryzby
2020/12/03 Re: time taking deletion on large tables Ravikumar Reddy
2020/12/03 time taking deletion on large tables Atul Kumar
2020/11/22 Re: Simple update query is slow Justin Pryzby
2020/11/22 Re: Simple update query is slow Nandakumar M
2020/11/22 Simple update query is slow Nandakumar M
2020/11/19 Re: How to prioritise walsender reading from pg_wal over WAL writes? Alexey Bashtanov
2020/11/19 Re: Postgres using nested loops despite setting enable_nestloop to false Frits Jalvingh
2020/11/18 Re: How to prioritise walsender reading from pg_wal over WAL writes? Laurenz Albe
2020/11/18 Re: How to prioritise walsender reading from pg_wal over WAL writes? Alexey Bashtanov
2020/11/18 Re: How to prioritise walsender reading from pg_wal over WAL writes? Laurenz Albe
2020/11/18 Re: How to prioritise walsender reading from pg_wal over WAL writes? Alexey Bashtanov
2020/11/17 Re: Postgres using nested loops despite setting enable_nestloop to false Frits Jalvingh
2020/11/17 Re: Postgres using nested loops despite setting enable_nestloop to false Tom Lane
2020/11/17 Re: Postgres using nested loops despite setting enable_nestloop to false Frits Jalvingh
2020/11/17 Re: Postgres using nested loops despite setting enable_nestloop to false Justin Pryzby