Re: Introduction of a new field in pg_class indicating presence of a large object in a table

2024-04-30 Thread Tom Lane
"David G. Johnston" writes: > On Tue, Apr 30, 2024 at 11:57 AM Gaurav Pant > wrote: >> I wanted to know if there is any such system table that we can use to >> identify and map the fields containing large objects and the respective >> tables and if it is not already there, do we have any plans to

Re: Introduction of a new field in pg_class indicating presence of a large object in a table

2024-04-30 Thread David G. Johnston
On Tue, Apr 30, 2024 at 11:57 AM Gaurav Pant wrote: > I wanted to know if there is any such system table that we can use to > identify and map the fields containing large objects and the respective > tables and if it is not already there, do we have any plans to incorporate > the same in pg_class

Introduction of a new field in pg_class indicating presence of a large object in a table

2024-04-30 Thread Gaurav Pant
Hi All, I hope you're all doing well! Recently, I have across a scenario where one of our client was unable to perform a major version upgrade of their PostgreSQL instance as it was failing due to OOM errors. When reviewed the upgrade log files and queried pg_largeobject_metadata, we found a sign