pgsql-performance

Messages by Date

2021/05/27 Count (select 1) subquery as constant Eugen Konkov
2021/05/25 Re: issue partition scan Christophe Pettus
2021/05/25 Re: issue partition scan David Rowley
2021/05/25 Re: issue partition scan Nagaraj Raj
2021/05/25 Re: issue partition scan Christophe Pettus
2021/05/25 issue partition scan Nagaraj Raj
2021/05/24 Re: transaction blocking on COMMIT Alexey M Boltenkov
2021/05/24 Re: transaction blocking on COMMIT Christophe Pettus
2021/05/24 Re: transaction blocking on COMMIT Bob Jolliffe
2021/05/24 Re: Optimising outer joins in the presence of non-nullable references Tom Lane
2021/05/24 Re: transaction blocking on COMMIT Vijaykumar Jain
2021/05/24 Re: transaction blocking on COMMIT Bob Jolliffe
2021/05/24 Optimising outer joins in the presence of non-nullable references Philip Lykke Carlsen
2021/05/24 Re: transaction blocking on COMMIT Vijaykumar Jain
2021/05/24 transaction blocking on COMMIT Bob Jolliffe
2021/05/21 RE: Partition with check constraint with "like" Michel SALAIS
2021/05/21 Re: Partition with check constraint with "like" David Rowley
2021/05/21 Re: Partition with check constraint with "like" David Rowley
2021/05/21 Re: Partition with check constraint with "like" Nagaraj Raj
2021/05/21 Re: Partition with check constraint with "like" Nagaraj Raj
2021/05/21 RE: Partition with check constraint with "like" Michel SALAIS
2021/05/21 Re: Partition with check constraint with "like" Nagaraj Raj
2021/05/21 Re: Partition with check constraint with "like" Vijaykumar Jain
2021/05/21 Re: Partition with check constraint with "like" Nagaraj Raj
2021/05/21 Re: logical replication Marc Millas
2021/05/21 Re: logical replication Andrew Dunstan
2021/05/21 logical replication Marc Millas
2021/05/21 Re: Partition with check constraint with "like" David Rowley
2021/05/21 Re: Partition with check constraint with "like" Nagaraj Raj
2021/05/20 Re: Partition with check constraint with "like" Michael Lewis
2021/05/20 Re: Partition with check constraint with "like" Justin Pryzby
2021/05/20 Re: Partition with check constraint with "like" Nagaraj Raj
2021/05/20 Re: Partition with check constraint with "like" David Rowley
2021/05/20 Partition with check constraint with "like" Nagaraj Raj
2021/05/17 Re: Index and statistics not used David Rowley
2021/05/17 Index and statistics not used rstander
2021/05/17 Re: BUG #16968: Planner does not recognize optimization Eugen Konkov
2021/05/17 Re: BUG #16968: Planner does not recognize optimization Eugen Konkov
2021/05/17 Re: BUG #16968: Planner does not recognize optimization David Rowley
2021/05/17 Re: BUG #16968: Planner does not recognize optimization David Rowley
2021/05/14 Re: Very slow "bloat query" Marcin Gozdalik
2021/05/14 Re: Very slow "bloat query" Marcin Gozdalik
2021/05/14 Re: Very slow "bloat query" Imre Samu
2021/05/14 Re: BUG #16968: Planner does not recognize optimization KES
2021/05/14 Re: Very slow "bloat query" Marcin Gozdalik
2021/05/14 Re: Very slow "bloat query" Tom Lane
2021/05/14 Re: Very slow "bloat query" Imre Samu
2021/05/14 Re: Very slow "bloat query" Gilles Darold
2021/05/14 Very slow "bloat query" Marcin Gozdalik
2021/05/14 RE: Re: PostgreSQL blocked locks query Manoj Kumar
2021/05/14 Re: BUG #16968: Planner does not recognize optimization David Rowley
2021/05/13 Re: PostgreSQL blocked locks query Justin Pryzby
2021/05/13 PostgreSQL blocked locks query Manoj Kumar
2021/05/10 Re: Very slow Query compared to Oracle / SQL - Server Semen Yefimenko
2021/05/08 Re: Very slow Query compared to Oracle / SQL - Server Semen Yefimenko
2021/05/07 Re: Very slow Query compared to Oracle / SQL - Server didier
2021/05/07 Re: Very slow Query compared to Oracle / SQL - Server Peter Geoghegan
2021/05/07 Re: Very slow Query compared to Oracle / SQL - Server Peter Geoghegan
2021/05/07 Re: Very slow Query compared to Oracle / SQL - Server Tom Lane
2021/05/07 Re: Very slow Query compared to Oracle / SQL - Server Justin Pryzby
2021/05/07 Re: Very slow Query compared to Oracle / SQL - Server Semen Yefimenko
2021/05/07 Re: Very slow Query compared to Oracle / SQL - Server Rick Otten
2021/05/07 Re: Very slow Query compared to Oracle / SQL - Server Vijaykumar Jain
2021/05/07 Re: Very slow Query compared to Oracle / SQL - Server Semen Yefimenko
2021/05/07 Re: Very slow Query compared to Oracle / SQL - Server Vijaykumar Jain
2021/05/07 Re: Very slow Query compared to Oracle / SQL - Server Semen Yefimenko
2021/05/06 Re: Very slow Query compared to Oracle / SQL - Server Imre Samu
2021/05/06 Re: Very slow Query compared to Oracle / SQL - Server Alexey M Boltenkov
2021/05/06 Re: Very slow Query compared to Oracle / SQL - Server Alexey M Boltenkov
2021/05/06 Re: Very slow Query compared to Oracle / SQL - Server Justin Pryzby
2021/05/06 Re: Very slow Query compared to Oracle / SQL - Server Alexey M Boltenkov
2021/05/06 Re: Very slow Query compared to Oracle / SQL - Server Vijaykumar Jain
2021/05/06 Re: Very slow Query compared to Oracle / SQL - Server Andreas Joseph Krogh
2021/05/06 Re: Very slow Query compared to Oracle / SQL - Server Semen Yefimenko
2021/05/06 Re: Very slow Query compared to Oracle / SQL - Server Alexey M Boltenkov
2021/05/06 Re: Very slow Query compared to Oracle / SQL - Server Alexey M Boltenkov
2021/05/06 Re: Very slow Query compared to Oracle / SQL - Server luis . roberto
2021/05/06 Very slow Query compared to Oracle / SQL - Server Semen Yefimenko
2021/05/05 Re: 15x slower PreparedStatement vs raw query Alex
2021/05/04 Re: 15x slower PreparedStatement vs raw query Justin Pryzby
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