pgsql-performance  

Messages by Thread

• • Re: 15x slower PreparedStatement vs raw query Justin Pryzby
  • Re: 15x slower PreparedStatement vs raw query Alex
  • Re: 15x slower PreparedStatement vs raw query Rick Otten
  • Re: 15x slower PreparedStatement vs raw query Alex
  • Re: 15x slower PreparedStatement vs raw query Laurenz Albe
  • Re: 15x slower PreparedStatement vs raw query Vijaykumar Jain
  • Re: 15x slower PreparedStatement vs raw query David Rowley
  • Re: 15x slower PreparedStatement vs raw query Alex
  • Re: 15x slower PreparedStatement vs raw query Justin Pryzby
• Log number of tuples returned Edson Richter
  • Re: Log number of tuples returned Justin Pryzby
  • RES: Log number of tuples returned Edson Richter
• Error while calling proc with table type from Application aditya desai
  • Re: Error while calling proc with table type from Application (npgsql) Justin Pryzby
  • Re: Error while calling proc with table type from Application (npgsql) aditya desai
  • Re: Error while calling proc with table type from Application (npgsql) aditya desai
  • Re: Error while calling proc with table type from Application (npgsql) Vijaykumar Jain
• Order of execution luis . roberto
  • Re: Order of execution Jean-Christophe Boggio
• Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Simon Connah
  • Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Justin Pryzby
  • Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Bruce Momjian
  • Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Marc Millas
  • Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Rory Campbell-Lange
  • Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Marc Millas
  • Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Christophe Pettus
  • Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Tomas Vondra
  • Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Rory Campbell-Lange
  • Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Simon Connah
• hint in determining effective_io_concurrency Luca Ferrari
  • Re: hint in determining effective_io_concurrency Bruce Momjian
  • Re: hint in determining effective_io_concurrency Luca Ferrari
  • Re: hint in determining effective_io_concurrency Bruce Momjian
  • Re: hint in determining effective_io_concurrency Merlin Moncure
  • Re: hint in determining effective_io_concurrency Luca Ferrari
  • Re: hint in determining effective_io_concurrency Justin Pryzby
  • Re: hint in determining effective_io_concurrency Luca Ferrari
  • Re: hint in determining effective_io_concurrency Justin Pryzby
  • Re: hint in determining effective_io_concurrency Bruce Momjian
• Re: Planning performance problem (67626.278ms) David Rowley
  • Re: Planning performance problem (67626.278ms) Tom Lane
  • Re: Planning performance problem (67626.278ms) Manuel Weitzman
  • Re: Planning performance problem (67626.278ms) Manuel Weitzman
  • Re: Planning performance problem (67626.278ms) Tom Lane
  • Re: Planning performance problem (67626.278ms) Ranier Vilela
  • Re: Planning performance problem (67626.278ms) Tom Lane
  • Re: Planning performance problem (67626.278ms) Manuel Weitzman
  • Re: Planning performance problem (67626.278ms) Tom Lane
  • Re: Planning performance problem (67626.278ms) Manuel Weitzman
  • Re: Planning performance problem (67626.278ms) Tom Lane
  • Re: Planning performance problem (67626.278ms) Manuel Weitzman
  • Re: Planning performance problem (67626.278ms) Manuel Weitzman
  • Re: Planning performance problem (67626.278ms) David Rowley
• Re: OLEDB for PostgreSQL aditya desai
  • Re: OLEDB for PostgreSQL Pavan Pusuluri
• Most proper partitioning form on an integer column Il Mimo di Creta
  • Re: Most proper partitioning form on an integer column Justin Pryzby
• Is there a way to change current time? Warstone
  • Re: Is there a way to change current time? Bruce Momjian
  • Re: Is there a way to change current time? Justin Pryzby
  • Re: Is there a way to change current time? Tom Lane
  • Re: Is there a way to change current time? Pavel Stehule
  • Re: Is there a way to change current time? Eugene Pazhitnov
• Strange behavior once statistics are there Daniel Westermann (DWE)
  • Re: Strange behavior once statistics are there Tom Lane
  • Re: Strange behavior once statistics are there Daniel Westermann (DWE)
• Why is there a tenfold difference between Postgres's alleged query execution time and packet transmission time? Rollo Konig-Brock
  • Re: Why is there a tenfold difference between Postgres's alleged query execution time and packet transmission time? Tom Lane
• LWLocks by LockManager slowing large DB Paul Friedman
  • Re: LWLocks by LockManager slowing large DB Andres Freund
  • RE: LWLocks by LockManager slowing large DB Paul Friedman
  • Re: LWLocks by LockManager slowing large DB Andres Freund
  • RE: LWLocks by LockManager slowing large DB Paul Friedman
  • Re: LWLocks by LockManager slowing large DB Andres Freund
  • RE: LWLocks by LockManager slowing large DB Paul Friedman
  • Re: LWLocks by LockManager slowing large DB Andres Freund
  • RE: LWLocks by LockManager slowing large DB Paul Friedman
  • Re: LWLocks by LockManager slowing large DB Andres Freund
  • Re: LWLocks by LockManager slowing large DB Alvaro Herrera
  • Re: LWLocks by LockManager slowing large DB Tom Lane
  • Re: LWLocks by LockManager slowing large DB Tom Lane
  • Re: LWLocks by LockManager slowing large DB Andres Freund
  • Re: LWLocks by LockManager slowing large DB Tom Lane
  • Re: LWLocks by LockManager slowing large DB Andres Freund
  • Re: LWLocks by LockManager slowing large DB Alvaro Herrera
  • RE: LWLocks by LockManager slowing large DB Paul Friedman
  • Re: LWLocks by LockManager slowing large DB Nikolay Samokhvalov
  • RE: LWLocks by LockManager slowing large DB Paul Friedman
• INSERTS waiting with wait_event is "transactionid" Nagaraj Raj
  • Re: INSERTS waiting with wait_event is "transactionid" Laurenz Albe
  • Re: INSERTS waiting with wait_event is "transactionid" Nagaraj Raj
• str_aggr function not wokring aditya desai
  • RE: str_aggr function not wokring Patrick FICHE
  • Re: str_aggr function not wokring aditya desai
  • Re: str_aggr function not wokring aditya desai
• procedure using CURSOR to insert is extremely slow Szalontai Zoltán
  • Re: procedure using CURSOR to insert is extremely slow HER
  • RE: procedure using CURSOR to insert is extremely slow Szalontai Zoltán
  • Re: procedure using CURSOR to insert is extremely slow Milos Babic
  • RE: procedure using CURSOR to insert is extremely slow Szalontai Zoltán
  • RE: procedure using CURSOR to insert is extremely slow Mike Sofen
  • Re: procedure using CURSOR to insert is extremely slow Milos Babic
  • RE: procedure using CURSOR to insert is extremely slow Szalontai Zoltán
• select count(*) is slow aditya desai
  • Re: select count(*) is slow Tom Lane
  • Re: select count(*) is slow aditya desai
  • Re: select count(*) is slow Andrew Dunstan
  • Re: select count(*) is slow aditya desai
• Substitute for synonym in Oracle after migration to postgres aditya desai
  • Re: Substitute for synonym in Oracle after migration to postgres Laurenz Albe
  • Re: Substitute for synonym in Oracle after migration to postgres hubert depesz lubaczewski
  • Re: Substitute for synonym in Oracle after migration to postgres aditya desai
• PosgtgreSQL hot standby reading WAL from muli-attached volume? Gunther Schadow
• SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS aditya desai
  • Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS Amine Tengilimoglu
  • Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS Justin Pryzby
  • Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS aditya desai
  • Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS Andrew Dunstan
• SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai
  • Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Bharath Rupireddy
  • Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Pavel Stehule
  • Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Justin Pryzby
  • Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai
  • Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Bruce Momjian
  • Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai
  • Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Bruce Momjian
  • Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Tom Lane
  • Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Justin Pryzby
  • Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Bruce Momjian
  • Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai
  • Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai
  • Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Pavel Stehule
  • Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai
  • Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Pavel Stehule
  • Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai
  • Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Bruce Momjian
  • Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai
  • Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Michael Lewis
  • Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai
  • Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Bruce Momjian
  • Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai
  • Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Pavel Stehule
  • Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Bruce Momjian
• High-volume writes - what is the max throughput possible Geervan Hayatnagarkar
  • Re: High-volume writes - what is the max throughput possible Frits Jalvingh
  • Re: High-volume writes - what is the max throughput possible Hannu Krosing
• Odd (slow) plan choice with min/max Paul McGarry
  • Re: Odd (slow) plan choice with min/max Justin Pryzby
  • Re: Odd (slow) plan choice with min/max Paul McGarry
  • Re: Odd (slow) plan choice with min/max Rick Otten
  • Re: Odd (slow) plan choice with min/max Paul McGarry
  • Re: Odd (slow) plan choice with min/max Yoan SULTAN
• SQL performance issue (postgresql chooses a bad plan when a better one is available) Chris Stephens
  • Re: SQL performance issue (postgresql chooses a bad plan when a better one is available) Laurenz Albe
  • Re: SQL performance issue (postgresql chooses a bad plan when a better one is available) Chris Stephens
  • Re: SQL performance issue (postgresql chooses a bad plan when a better one is available) Hannu Krosing
  • Re: SQL performance issue (postgresql chooses a bad plan when a better one is available) Chris Stephens
  • Re: SQL performance issue (postgresql chooses a bad plan when a better one is available) Hannu Krosing
• Extremely inefficient merge-join Marcin Gozdalik
  • Re: Extremely inefficient merge-join Tom Lane
  • Re: Extremely inefficient merge-join Marcin Gozdalik
• wide table, many many partitions, poor query performance S Bob
  • Re: wide table, many many partitions, poor query performance Justin Pryzby
  • Re: wide table, many many partitions, poor query performance Laurenz Albe
• Users grants with setting options Nagaraj Raj
  • Re: Users grants with setting options David G. Johnston
  • Re: Users grants with setting options Nagaraj Raj
• Fwd: different execution time for the same query (and same DB status) Francesco De Angelis
  • RE: different execution time for the same query (and same DB status) Michel SALAIS
  • Re: different execution time for the same query (and same DB status) Julien Rouhaud
  • Re: different execution time for the same query (and same DB status) Tom Lane
  • Re: different execution time for the same query (and same DB status) Michael Lewis
  • Re: different execution time for the same query (and same DB status) Francesco De Angelis
  • Re: Fwd: different execution time for the same query (and same DB status) Justin Pryzby
  • Re: Fwd: different execution time for the same query (and same DB status) Francesco De Angelis
  • Re: Fwd: different execution time for the same query (and same DB status) Michael Lewis
  • Re: Fwd: different execution time for the same query (and same DB status) Francesco De Angelis
  • How do we hint a query to use index in postgre Manish Lad
  • Re: How do we hint a query to use index in postgre Gaetano Mendola
  • Re: How do we hint a query to use index in postgre Manish Lad
  • Re: How do we hint a query to use index in postgre Nikhil Shetty
• Slow query performance inside a transaction on a clean database val.janeiko
  • Re: Slow query performance inside a transaction on a clean database Laurenz Albe
• tables meta data collection Nagaraj Raj
  • Re: tables meta data collection Justin Pryzby
• High availability management tool. Rodriguez Pablo A
  • Re: High availability management tool. Dorian Hoxha
  • Re: High availability management tool. Hüseyin Demir
  • Re: High availability management tool. Adalberto Caccia
• Performance issues related to left join and order by Liu, Xinyu
  • Re: Performance issues related to left join and order by David Rowley
• Potential performance issues related to group by and covering index Liu, Xinyu
  • Re: Potential performance issues related to group by and covering index Pavel Stehule
  • Re: Potential performance issues related to group by and covering index David Rowley
  • Re: Potential performance issues related to group by and covering index Michael Lewis
  • Re: Potential performance issues related to group by and covering index David Rowley
  • Re: Potential performance issues related to group by and covering index Hannu Krosing
• Potential performance issues Jung, Jinho
  • Re: Potential performance issues Andrew Dunstan
  • Re: Potential performance issues MichaelDBA

• Earlier messages
• Later messages