Bloated pg_catalog.pg_largeobjects

ways allocating new pages. The table just keeps growing. Is this a known thing, maybe something special about LOs? Also, is the only way to recover space here a vacuum full on the table since it's a catalog table? Thanks, --  Jon Erdman (aka StuckMojo on IRC)     PostgreSQL Zealot

Re: Bogus temp file reporting?

Thanks for the clarification. Also, I was wrong about the temp_* columns in the pg_stat_database view in that they report the overall temp file usage since the last stats reset and not the “current” usage. Regards, Kiriakos Georgiou > On Jul 27, 2023, at 11:31 AM, Kyotaro Horiguchi > wrote

Bogus temp file reporting?

--- PostgreSQL 14.8 (Ubuntu 14.8-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit (1 row) select datname

Conditional JOINs to optimise expensive views

t the Postgresql (9.5 and 9.6) query planner executes LEFT and LATERAL JOINed queries even when the JOIN conditions are false. I don't understand why. I could work around some of this by adding a (dirty-ish?) CASE statement or a slower and more complex CTE construct or even create functions f