Re: Wrapping a select in another select makes it slower

2025-07-23 Thread Peter J. Holzer
On 2025-07-23 10:08:31 +1200, David Rowley wrote: > On Wed, 23 Jul 2025 at 03:18, Peter J. Holzer wrote: > > > > PostgreSQL version 17.5 on Ubuntu 24.04 (PGDG build). > > > > -> Merge Left Join (cost=4613.25..7180.30 rows=8357 > > width=136) (actual time=222.037..292242.701 rows

Re: Wrapping a select in another select makes it slower

2025-07-22 Thread David Rowley
On Wed, 23 Jul 2025 at 03:18, Peter J. Holzer wrote: > > PostgreSQL version 17.5 on Ubuntu 24.04 (PGDG build). > -> Merge Left Join (cost=4613.25..7180.30 rows=8357 > width=136) (actual time=222.037..292242.701 rows=40460 loops=1) > Merge Cond: (ns.nspname =

Wrapping a select in another select makes it slower

2025-07-22 Thread Peter J. Holzer
PostgreSQL version 17.5 on Ubuntu 24.04 (PGDG build). Context: We use CheckMK to monitor our systems. This also reports various health indicators for Postgres. Recently a colleague noticed that the indicators for one database were missing, presumable since upgrading to Ubuntu 24.04 and Postgres 17