public inbox for [email protected]  
help / color / mirror / Atom feed
Hash Right join and seq scan
  2024-07-03 04:57 UTC  James Pang <[email protected]>
` Re: Hash Right join and seq scan
  2024-07-03 06:51 UTC  James Pang <[email protected]>
` Re: Hash Right join and seq scan
  2024-07-03 06:53 UTC  James Pang <[email protected]>
` Re: Hash Right join and seq scan
  2024-07-03 17:40 UTC  Tomas Vondra <[email protected]>
` Re: Hash Right join and seq scan
  2024-07-05 00:50 UTC  James Pang <[email protected]>
` Re: Hash Right join and seq scan
  2024-07-05 02:15 UTC  David Rowley <[email protected]>
` Re: Hash Right join and seq scan
  2024-07-05 14:43 UTC  James Pang <[email protected]>
` Re: Hash Right join and seq scan
  2024-07-06 00:32 UTC  David Rowley <[email protected]>
` Re: Hash Right join and seq scan
  2024-07-08 02:21 UTC  James Pang <[email protected]>
` Re: Hash Right join and seq scan
  2024-07-08 02:26 UTC  Justin Pryzby <[email protected]>
  [10+ messages in thread]

a lot of shared buffers hit when planning for a simple query with primary access path
  2024-07-01 09:45 UTC  James Pang <[email protected]>
` Re: a lot of shared buffers hit when planning for a simple query with primary access path
  2024-07-01 10:10 UTC  David Rowley <[email protected]>
` Re: a lot of shared buffers hit when planning for a simple query with primary access path
  2024-07-01 10:20 UTC  Pavel Stehule <[email protected]>
` Re: a lot of shared buffers hit when planning for a simple query with primary access path
  2024-07-01 10:52 UTC  David Rowley <[email protected]>
` Re: a lot of shared buffers hit when planning for a simple query with primary access path
  2024-07-01 10:58 UTC  James Pang <[email protected]>
` Re: a lot of shared buffers hit when planning for a simple query with primary access path
  2024-07-01 11:31 UTC  Andrei Lepikhov <[email protected]>
  [6+ messages in thread]

Inconsistent query performance based on relation hit frequency
  2024-06-27 00:50 UTC  Laura Hausmann <[email protected]>
` Re: Inconsistent query performance based on relation hit frequency
  2024-06-27 10:31 UTC  Andrei Lepikhov <[email protected]>
` Re: Inconsistent query performance based on relation hit frequency
  2024-06-27 13:27 UTC  Achilleas Mantzios - cloud <[email protected]>
` Re: Inconsistent query performance based on relation hit frequency
  2024-06-27 14:58 UTC  Laura Hausmann <[email protected]>
` Re: Inconsistent query performance based on relation hit frequency
  2024-06-27 19:22 UTC  Achilleas Mantzios <[email protected]>
  [5+ messages in thread]

Row level security
  2024-06-24 22:28 UTC  Thomas Simpson <[email protected]>
` Re: Row level security
  2024-06-27 10:45 UTC  Andrew Okhmat <[email protected]>
  [2+ messages in thread]

performance of sql and plpgsql functions
  2024-06-17 09:35 UTC  Julius Tuskenis <[email protected]>
` Re: performance of sql and plpgsql functions
  2024-06-17 09:44 UTC  Pavel Stehule <[email protected]>
` Re: performance of sql and plpgsql functions
  2024-06-17 11:01 UTC  Julius Tuskenis <[email protected]>
` Re: performance of sql and plpgsql functions
  2024-06-17 12:59 UTC  Philip Semanchuk <[email protected]>
` Re: performance of sql and plpgsql functions
  2024-06-17 13:54 UTC  Julius Tuskenis <[email protected]>
` Re: performance of sql and plpgsql functions
  2024-06-17 14:07 UTC  Pavel Stehule <[email protected]>
` Re: performance of sql and plpgsql functions
  2024-06-17 14:24 UTC  Tom Lane <[email protected]>
` Re: performance of sql and plpgsql functions
  2024-06-18 13:03 UTC  Julius Tuskenis <[email protected]>
  [8+ messages in thread]

BDR that performs
  2024-06-14 12:08 UTC  Smith, Travis <[email protected]>
` Re: BDR that performs
  2024-06-14 12:35 UTC  Bruce Momjian <[email protected]>
` Re: BDR that performs
  2024-06-14 12:40 UTC  Hari Kiran <[email protected]>
` Re: BDR that performs
  2024-06-14 12:41 UTC  P C <[email protected]>
` Re: BDR that performs
  2024-06-14 14:57 UTC  Bruce Momjian <[email protected]>
  [5+ messages in thread]

Need help on configuration SMTP
  2024-06-12 11:58 UTC  nikhil kumar <[email protected]>
` Re: Need help on configuration SMTP
  2024-06-12 12:01 UTC  Muhammad Ikram <[email protected]>
` Re: Need help on configuration SMTP
  2024-06-12 12:25 UTC  David G. Johnston <[email protected]>
` Re: Need help on configuration SMTP
  2024-06-12 17:16 UTC  nikhil kumar <[email protected]>
  [4+ messages in thread]

Distinct performance dropped by multiple times in v16
  2024-06-10 06:59 UTC  Vitaliy Litovskiy <[email protected]>
` Re: Distinct performance dropped by multiple times in v16
  2024-06-10 16:24 UTC  Greg Sabino Mullane <[email protected]>
` Re: Distinct performance dropped by multiple times in v16
  2024-06-11 07:10 UTC  Andrei Lepikhov <[email protected]>
` Re: Distinct performance dropped by multiple times in v16
  2024-06-12 12:10 UTC  Andrei Lepikhov <[email protected]>
  [4+ messages in thread]

Postgresql initialize error
  2024-06-11 19:58 UTC  nikhil kumar <[email protected]>
` Re: Postgresql initialize error
  2024-06-11 19:59 UTC  nikhil kumar <[email protected]>
` Re: Postgresql initialize error
  2024-06-11 20:04 UTC  Muhammad Salahuddin Manzoor <[email protected]>
` Re: Postgresql initialize error
  2024-06-11 20:05 UTC  nikhil kumar <[email protected]>
` Re: Postgresql initialize error
  2024-06-11 20:23 UTC  nikhil kumar <[email protected]>
` RE: Postgresql initialize error
  2024-06-11 20:25 UTC  Smith, Travis <[email protected]>
  [6+ messages in thread]

query column in pg_stat_statements and pg_stat_activity
  2024-06-04 06:46 UTC  Satalabaha Postgres <[email protected]>

Plan selection based on worst case scenario
  2024-05-30 01:03 UTC  Darwin O'Connor <[email protected]>
` Re: Plan selection based on worst case scenario
  2024-05-30 01:44 UTC  David Rowley <[email protected]>
` Re: Plan selection based on worst case scenario
  2024-05-30 04:03 UTC  Chema <[email protected]>
  [3+ messages in thread]

Extremely slow to establish connection when user has a high number of roles
  2024-04-20 11:55 UTC  Michal Charemza <[email protected]>
` Re: Extremely slow to establish connection when user has a high number of roles
  2024-04-20 12:57 UTC  Tomas Vondra <[email protected]>
` Re: Extremely slow to establish connection when user has a high number of roles
  2024-04-20 14:37 UTC  Tom Lane <[email protected]>
` Re: Extremely slow to establish connection when user has a high number of roles
  2024-04-20 14:52 UTC  Vijaykumar Jain <[email protected]>
` Re: Extremely slow to establish connection when user has a high number of roles
  2024-04-20 15:12 UTC  Michal Charemza <[email protected]>
` Re: Extremely slow to establish connection when user has a high number of roles
  2024-04-20 15:22 UTC  Michal Charemza <[email protected]>
` Re: Extremely slow to establish connection when user has a high number of roles
  2024-04-20 15:24 UTC  Frits Hoogland <[email protected]>
` Re: Extremely slow to establish connection when user has a high number of roles
  2024-04-20 15:34 UTC  Michal Charemza <[email protected]>
` Re: Extremely slow to establish connection when user has a high number of roles
  2024-04-20 15:52 UTC  Tom Lane <[email protected]>
` Re: Extremely slow to establish connection when user has a high number of roles
  2024-04-21 11:08 UTC  Michal Charemza <[email protected]>
` Re: Extremely slow to establish connection when user has a high number of roles
  2024-04-21 15:08 UTC  Tom Lane <[email protected]>
  [11+ messages in thread]

Re: Performance implications of 8K pread()s
  2024-04-12 05:45 UTC  Thomas Munro <[email protected]>
` Re: Performance implications of 8K pread()s
  2024-04-12 11:12 UTC  Dimitrios Apostolou <[email protected]>
  [2+ messages in thread]

LWlock:LockManager waits
  2024-04-09 03:07 UTC  James Pang <[email protected]>
` Re: LWlock:LockManager waits
  2024-04-09 04:31 UTC  Laurenz Albe <[email protected]>
` Re: LWlock:LockManager waits
  2024-04-09 07:54 UTC  James Pang <[email protected]>
` Re: LWlock:LockManager waits
  2024-04-09 08:36 UTC  Frits Hoogland <[email protected]>
` Re: LWlock:LockManager waits
  2024-04-09 09:36 UTC  Frits Hoogland <[email protected]>
` Re: LWlock:LockManager waits
  2024-04-09 10:33 UTC  Luiz Fernando G. Verona <[email protected]>
  [6+ messages in thread]

IN subquery, many joins, very different plans
  2024-04-05 15:20 UTC  Dave Thorn <[email protected]>

maintenance_work_mem impact?
  2024-03-19 16:05 UTC  Adithya Kumaranchath <[email protected]>
` Re: maintenance_work_mem impact?
  2024-03-19 17:54 UTC  Laurenz Albe <[email protected]>
  [2+ messages in thread]

Re: FW: huge SubtransSLRU and SubtransBuffer wait_event
  2024-03-01 06:56 UTC  James Pang <[email protected]>
` Re: FW: huge SubtransSLRU and SubtransBuffer wait_event
  2024-03-01 07:35 UTC  Alvaro Herrera <[email protected]>
` Re: FW: huge SubtransSLRU and SubtransBuffer wait_event
  2024-03-15 02:03 UTC  James Pang <[email protected]>
  [3+ messages in thread]

Is partition pruning impacted by data type
  2024-03-04 19:39 UTC  sud <[email protected]>
` Re: Is partition pruning impacted by data type
  2024-03-05 05:20 UTC  sud <[email protected]>
` Re: Is partition pruning impacted by data type
  2024-03-05 19:05 UTC  Lok P <[email protected]>
` Re: Is partition pruning impacted by data type
  2024-03-05 19:29 UTC  sud <[email protected]>
` Re: Is partition pruning impacted by data type
  2024-03-07 20:37 UTC  sud <[email protected]>
  [5+ messages in thread]

Separate 100 M spatial data in 100 tables VS one big table
  2024-03-05 07:44 UTC  kimaidou <[email protected]>
` Re: Separate 100 M spatial data in 100 tables VS one big table
  2024-03-05 12:47 UTC  Marc Millas <[email protected]>
` Re: Separate 100 M spatial data in 100 tables VS one big table
  2024-03-05 20:13 UTC  Tomas Vondra <[email protected]>
` Re: Separate 100 M spatial data in 100 tables VS one big table
  2024-03-06 16:13 UTC  kimaidou <[email protected]>
  [4+ messages in thread]

Re: Optimizing count(), but Explain estimates wildly off
  2024-03-01 08:57 UTC  Laurenz Albe <[email protected]>
` Re: Optimizing count(), but Explain estimates wildly off
  2024-03-04 19:13 UTC  Chema <[email protected]>
` Re: Optimizing count(), but Explain estimates wildly off
  2024-03-05 01:50 UTC  Greg Sabino Mullane <[email protected]>
` Re: Optimizing count(), but Explain estimates wildly off
  2024-03-05 14:00 UTC  Chema <[email protected]>
` Re: Optimizing count(), but Explain estimates wildly off
  2024-03-05 17:04 UTC  Greg Sabino Mullane <[email protected]>
` Re: Optimizing count(), but Explain estimates wildly off
  2024-03-06 14:00 UTC  Chema <[email protected]>
  [6+ messages in thread]

Optimizing count(), but Explain estimates wildly off
  2024-02-27 00:25 UTC  Chema <[email protected]>
` Re: Optimizing count(), but Explain estimates wildly off
  2024-02-27 04:36 UTC  Vitalii Tymchyshyn <[email protected]>
` Re: Optimizing count(), but Explain estimates wildly off
  2024-02-27 07:40 UTC  Laurenz Albe <[email protected]>
` Re: Optimizing count(), but Explain estimates wildly off
  2024-02-27 13:11 UTC  Alvaro Herrera <[email protected]>
` Re: Optimizing count(), but Explain estimates wildly off
  2024-02-29 23:15 UTC  Chema <[email protected]>
  [5+ messages in thread]

Table Partitioning and Indexes Performance Questions
  2024-02-29 16:42 UTC  David Kelly <[email protected]>
` Re: Table Partitioning and Indexes Performance Questions
  2024-02-29 17:32 UTC  Laurenz Albe <[email protected]>
` Re: Table Partitioning and Indexes Performance Questions
  2024-02-29 18:11 UTC  Anupam b <[email protected]>
  [3+ messages in thread]

generic plan generate poor performance
  2024-02-29 14:27 UTC  James Pang <[email protected]>
` Re: generic plan generate poor performance
  2024-02-29 14:38 UTC  Pavel Stehule <[email protected]>
  [2+ messages in thread]

extend statistics help reduce index scan a lot of shared buffer hits.
  2024-02-27 13:54 UTC  James Pang <[email protected]>
` Fwd: extend statistics help reduce index scan a lot of shared buffer hits.
  2024-02-27 13:58 UTC  James Pang <[email protected]>
` Re: Fwd: extend statistics help reduce index scan a lot of shared buffer hits.
  2024-02-28 14:53 UTC  Tomas Vondra <[email protected]>
  [3+ messages in thread]

huge SubtransSLRU and SubtransBuffer wait_event
  2024-02-01 11:50 UTC  James Pang (chaolpan) <[email protected]>
` Re: huge SubtransSLRU and SubtransBuffer wait_event
  2024-02-01 12:41 UTC  Laurenz Albe <[email protected]>
` RE: huge SubtransSLRU and SubtransBuffer wait_event
  2024-02-01 15:34 UTC  James Pang (chaolpan) <[email protected]>
` RE: huge SubtransSLRU and SubtransBuffer wait_event
  2024-02-02 06:47 UTC  James Pang (chaolpan) <[email protected]>
` Re: huge SubtransSLRU and SubtransBuffer wait_event
  2024-02-02 08:12 UTC  Alvaro Herrera <[email protected]>
` Re: huge SubtransSLRU and SubtransBuffer wait_event
  2024-02-02 09:26 UTC  Lars Aksel Opsahl <[email protected]>
` Re: huge SubtransSLRU and SubtransBuffer wait_event
  2024-02-02 10:04 UTC  Nikolay Samokhvalov <[email protected]>
` Re: huge SubtransSLRU and SubtransBuffer wait_event
  2024-02-02 10:31 UTC  Laurenz Albe <[email protected]>
` RE: huge SubtransSLRU and SubtransBuffer wait_event
  2024-02-06 06:59 UTC  James Pang (chaolpan) <[email protected]>
` Re: FW: huge SubtransSLRU and SubtransBuffer wait_event
  2024-02-26 06:01 UTC  James Pang <[email protected]>
  [10+ messages in thread]


[next (older)]

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox