| 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: | Whole Thread | Raw Message | 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
| 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 |