Re: Inheritance pg_largeobject table

Ron <ronljohnsonjr@xxxxxxxxx> · Thu, 8 Dec 2022 23:27:14 -0600



    On 12/8/22 23:08, Zhao, Bing wrote:

    
        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?
      
    
    Out of curiosity, why inheritance instead of declarative
    partitioning?

    
    -- 

      Angular momentum makes the world go 'round.