Inheritance pg_largeobject table

From: "Zhao, Bing" <Bing(dot)Zhao(at)cra-arc(dot)gc(dot)ca>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Inheritance pg_largeobject table
Date: 2022-12-09 05:08:37
Message-ID: 988914804de248e2af8e2c4d2be915c6@cra-arc.gc.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Categorization: Unclassified
We are running PG11.11, and have more than 50T LO data about load into the pg_largeobject table. But 32T is the limitation.
We have created couple child tables that using inheritance to pg_largeobject, and we have tried use triggers(insert or update) to put into child tables. It doesn't work by use LO functions, ex lo_put, lo_create...seems never got triggered. But works with insert statement into the pg_largeobject.
If we move LO data from root table to child, lo_get will break.

Any ideas?

Is there a way store them into pg_largeobject? expand this table? Or we have to consider toast tables.

Thanks,

~Bing

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2022-12-09 05:27:14 Re: Inheritance pg_largeobject table
Previous Message li jie 2022-12-09 03:31:59 Re: Support logical replication of DDLs