pgsql-performance

Messages by Date

2021/05/04 Re: 15x slower PreparedStatement vs raw query David Rowley
2021/05/04 Re: 15x slower PreparedStatement vs raw query Vijaykumar Jain
2021/05/04 Re: 15x slower PreparedStatement vs raw query Laurenz Albe
2021/05/04 Re: 15x slower PreparedStatement vs raw query Alex
2021/05/04 Re: 15x slower PreparedStatement vs raw query Rick Otten
2021/05/04 Re: 15x slower PreparedStatement vs raw query Alex
2021/05/03 Re: 15x slower PreparedStatement vs raw query Justin Pryzby
2021/05/03 15x slower PreparedStatement vs raw query Alex
2021/04/30 Re: Error while calling proc with table type from Application (npgsql) Vijaykumar Jain
2021/04/30 Re: Error while calling proc with table type from Application (npgsql) aditya desai
2021/04/30 Re: Error while calling proc with table type from Application (npgsql) aditya desai
2021/04/29 RES: Log number of tuples returned Edson Richter
2021/04/29 Re: Log number of tuples returned Justin Pryzby
2021/04/29 Log number of tuples returned Edson Richter
2021/04/29 Re: Error while calling proc with table type from Application (npgsql) Justin Pryzby
2021/04/29 Error while calling proc with table type from Application aditya desai
2021/04/27 Re: Order of execution Jean-Christophe Boggio
2021/04/27 Order of execution luis . roberto
2021/04/26 Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Marc Millas
2021/04/26 Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Rory Campbell-Lange
2021/04/26 Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Marc Millas
2021/04/25 Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Simon Connah
2021/04/24 Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Rory Campbell-Lange
2021/04/24 Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Tomas Vondra
2021/04/24 Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Christophe Pettus
2021/04/24 Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Bruce Momjian
2021/04/24 Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Justin Pryzby
2021/04/24 Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Simon Connah
2021/04/22 Re: hint in determining effective_io_concurrency Bruce Momjian
2021/04/22 Re: hint in determining effective_io_concurrency Justin Pryzby
2021/04/22 Re: hint in determining effective_io_concurrency Luca Ferrari
2021/04/22 Re: hint in determining effective_io_concurrency Justin Pryzby
2021/04/22 Re: hint in determining effective_io_concurrency Bruce Momjian
2021/04/22 Re: hint in determining effective_io_concurrency Luca Ferrari
2021/04/22 Re: hint in determining effective_io_concurrency Bruce Momjian
2021/04/22 hint in determining effective_io_concurrency Luca Ferrari
2021/04/21 Re: Planning performance problem (67626.278ms) Tom Lane
2021/04/21 Re: Planning performance problem (67626.278ms) David Rowley
2021/04/20 Re: OLEDB for PostgreSQL Pavan Pusuluri
2021/04/19 Re: OLEDB for PostgreSQL aditya desai
2021/04/18 Re: Most proper partitioning form on an integer column Justin Pryzby
2021/04/18 Most proper partitioning form on an integer column Il Mimo di Creta
2021/04/16 Re: Disabling options lowers the estimated cost of a query Tomas Vondra
2021/04/16 Re: Why is there a tenfold difference between Postgres's alleged query execution time and packet transmission time? Tom Lane
2021/04/16 Re: Disabling options lowers the estimated cost of a query Tom Lane
2021/04/16 Re: Disabling options lowers the estimated cost of a query Tom Lane
2021/04/15 Re: Strange behavior once statistics are there Daniel Westermann (DWE)
2021/04/15 Re: Disabling options lowers the estimated cost of a query Tomas Vondra
2021/04/15 Re: Disabling options lowers the estimated cost of a query Arne Roland
2021/04/15 Re: Strange behavior once statistics are there Tom Lane
2021/04/15 Re: Is there a way to change current time? Eugene Pazhitnov
2021/04/15 Re: Is there a way to change current time? Pavel Stehule
2021/04/15 Re: Is there a way to change current time? Tom Lane
2021/04/15 Re: Is there a way to change current time? Justin Pryzby
2021/04/15 Re: Is there a way to change current time? Bruce Momjian
2021/04/15 Is there a way to change current time? Warstone
2021/04/15 Strange behavior once statistics are there Daniel Westermann (DWE)
2021/04/15 Why is there a tenfold difference between Postgres's alleged query execution time and packet transmission time? Rollo Konig-Brock
2021/04/14 Re: LWLocks by LockManager slowing large DB Alvaro Herrera
2021/04/13 Re: LWLocks by LockManager slowing large DB Andres Freund
2021/04/13 Re: LWLocks by LockManager slowing large DB Tom Lane
2021/04/13 Re: LWLocks by LockManager slowing large DB Andres Freund
2021/04/13 Re: LWLocks by LockManager slowing large DB Tom Lane
2021/04/13 RE: LWLocks by LockManager slowing large DB Paul Friedman
2021/04/13 Re: LWLocks by LockManager slowing large DB Tom Lane
2021/04/13 Re: LWLocks by LockManager slowing large DB Alvaro Herrera
2021/04/13 Re: LWLocks by LockManager slowing large DB Andres Freund
2021/04/13 RE: LWLocks by LockManager slowing large DB Paul Friedman
2021/04/13 Re: LWLocks by LockManager slowing large DB Andres Freund
2021/04/13 RE: LWLocks by LockManager slowing large DB Paul Friedman
2021/04/13 RE: LWLocks by LockManager slowing large DB Paul Friedman
2021/04/12 Re: LWLocks by LockManager slowing large DB Nikolay Samokhvalov
2021/04/12 Re: LWLocks by LockManager slowing large DB Andres Freund
2021/04/12 RE: LWLocks by LockManager slowing large DB Paul Friedman
2021/04/12 Re: LWLocks by LockManager slowing large DB Andres Freund
2021/04/12 RE: LWLocks by LockManager slowing large DB Paul Friedman
2021/04/12 Re: LWLocks by LockManager slowing large DB Andres Freund
2021/04/12 LWLocks by LockManager slowing large DB Paul Friedman
2021/04/09 Re: INSERTS waiting with wait_event is "transactionid" Nagaraj Raj
2021/04/09 Re: INSERTS waiting with wait_event is "transactionid" Laurenz Albe
2021/04/08 INSERTS waiting with wait_event is "transactionid" Nagaraj Raj
2021/04/08 RE: procedure using CURSOR to insert is extremely slow Szalontai Zoltán
2021/04/08 Re: procedure using CURSOR to insert is extremely slow Milos Babic
2021/04/08 RE: procedure using CURSOR to insert is extremely slow Mike Sofen
2021/04/08 RE: procedure using CURSOR to insert is extremely slow Szalontai Zoltán
2021/04/08 Re: str_aggr function not wokring aditya desai
2021/04/08 Re: str_aggr function not wokring aditya desai
2021/04/08 Re: procedure using CURSOR to insert is extremely slow Milos Babic
2021/04/08 RE: procedure using CURSOR to insert is extremely slow Szalontai Zoltán
2021/04/08 RE: str_aggr function not wokring Patrick FICHE
2021/04/08 Re: procedure using CURSOR to insert is extremely slow HER
2021/04/08 str_aggr function not wokring aditya desai
2021/04/08 procedure using CURSOR to insert is extremely slow Szalontai Zoltán
2021/04/07 Re: select count(*) is slow aditya desai
2021/04/06 Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS Andrew Dunstan
2021/04/06 Re: select count(*) is slow Andrew Dunstan
2021/04/06 Re: select count(*) is slow aditya desai
2021/04/06 Re: select count(*) is slow Tom Lane
2021/04/06 Re: Substitute for synonym in Oracle after migration to postgres aditya desai
2021/04/06 select count(*) is slow aditya desai
2021/04/06 Re: Substitute for synonym in Oracle after migration to postgres hubert depesz lubaczewski
2021/04/06 Re: Substitute for synonym in Oracle after migration to postgres Laurenz Albe
2021/04/06 Substitute for synonym in Oracle after migration to postgres aditya desai
2021/04/05 Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS aditya desai
2021/04/05 PosgtgreSQL hot standby reading WAL from muli-attached volume? Gunther Schadow
2021/04/04 Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS Justin Pryzby
2021/04/04 Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS Amine Tengilimoglu
2021/04/04 Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai
2021/04/04 SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS aditya desai
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. aditya desai
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. 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. Bruce Momjian
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. Tom Lane
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. Pavel Stehule
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