Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p3Vcu-0005Xy-1I for pgsql-general@arkaria.postgresql.org; Fri, 09 Dec 2022 05:08:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p3Vcs-00025q-RN for pgsql-general@arkaria.postgresql.org; Fri, 09 Dec 2022 05:08:46 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p3Vcs-00025h-5U for pgsql-general@lists.postgresql.org; Fri, 09 Dec 2022 05:08:46 +0000 Received: from mail113.cra-arc.gc.ca ([198.103.184.34]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p3Vcn-0001HH-Bk for pgsql-general@lists.postgresql.org; Fri, 09 Dec 2022 05:08:45 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=cra-arc.gc.ca; s=mail113; t=1670562521; h=from:to:subject:date:message-id:mime-version; bh=D4dmHZZSBKSnCh3qIRcuR8xqA/4pAQ2AtYRbipHgQkw=; b=aNhebmgGqY92LjMn6Meb1nF6uqzwz4JIqGZa6swZsDvV8AqNHhFa/jfy HDbY3qNA4mMtzoUAzNYICPQui7X9kKZ9ryHPtirr+QPiF/1hsWRID5x2f g8CNLIreRFICQWfZltKI370JIZkkiqTEO8nm39x+DwhaBexVjgGeSjTwi o=; X-IronPort-AV: E=Sophos;i="5.96,230,1665460800"; d="scan'208,217";a="107034795" From: "Zhao, Bing" To: "pgsql-general@lists.postgresql.org" Subject: Inheritance pg_largeobject table Thread-Topic: Inheritance pg_largeobject table Thread-Index: AdkLimAwvm7LGBTgSv6TnyqIQswR8A== Date: Fri, 9 Dec 2022 05:08:37 +0000 Message-ID: <988914804de248e2af8e2c4d2be915c6@cra-arc.gc.ca> Accept-Language: en-CA, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-titus-metadata-40: eyJDYXRlZ29yeUxhYmVscyI6IiIsIk1ldGFkYXRhIjp7Im5zIjoiaHR0cDpcL1wvd3d3LnRpdHVzLmNvbVwvbnNcL0NhbmFkYSBSZXZlbnVlIEFnZW5jeSIsImlkIjoiYTE5YzBiOGQtMjVkZi00Mzc4LTgzMzAtNTIzNzFhNzJkMGU0IiwicHJvcHMiOlt7Im4iOiJTZWN1cml0eUNsYXNzaWZpY2F0aW9uTGV2ZWwiLCJ2YWxzIjpbeyJ2YWx1ZSI6IlVOQ0xBU1NJRklFRCJ9XX0seyJuIjoiRU5UUlVTVFBCIiwidmFscyI6W119LHsibiI6IkVOVFJVU1RQQSIsInZhbHMiOltdfSx7Im4iOiJMYW5ndWFnZVNlbGVjdGlvbiIsInZhbHMiOlt7InZhbHVlIjoiRU5HTElTSCJ9XX0seyJuIjoiVklTVUFMTUFSS0lOR1MiLCJ2YWxzIjpbeyJ2YWx1ZSI6IllFUyJ9XX1dfSwiU3ViamVjdExhYmVscyI6W10sIlRNQ1ZlcnNpb24iOiIyMS4zLjIxMzAuMyIsIlRydXN0ZWRMYWJlbEhhc2giOiJrS2Noa0FuTE1mXC9uT01zSkpld0F6VEhaOTc4VGFQMzNvN2N5dFp3S3gzOWM2SzJPUjlDVVBYQVJhaUhHV0JJSSJ9 x-originating-ip: [7.32.122.246] Content-Type: multipart/alternative; boundary="_000_988914804de248e2af8e2c4d2be915c6craarcgcca_" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_988914804de248e2af8e2c4d2be915c6craarcgcca_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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_largeobjec= t, and we have tried use triggers(insert or update) to put into child table= s. 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 hav= e to consider toast tables. Thanks, ~Bing --_000_988914804de248e2af8e2c4d2be915c6craarcgcca_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Categorization: Unclassified

We are running PG11.11, and have more than 50T LO da= ta about load into the pg_largeobject table. But 32T is the limitation.

We have created couple child tables that using inher= itance 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? expan= d this table? Or we have to consider toast tables.

 

 

Thanks,

 

~Bing

 

--_000_988914804de248e2af8e2c4d2be915c6craarcgcca_--