Re: Does standalone postfrsql have autogrowth/ manual growth on table space?

Ron <ronljohnsonjr@xxxxxxxxx> · Thu, 20 Oct 2022 12:32:39 -0500



    On 10/20/22 12:31, Rob Sargent wrote:

    
      On 10/20/22 11:29, Ron wrote:

      
      On
        10/20/22 12:19, Vince McMahon wrote: 

        In other databases, there is a way to
          preallocate the table space to allow bulk loading of data in a
          well packed and continuous space. 

          
          Does psql have that auto/manual growth? 

        
        There's no pre-allocation in Postgresql.  When you run CREATE
        TABLE, an (I think) 8KiB file is created; it grows as you add
        more data. When it hits 1GiB in size, another table is created. 
        And then another and another and another, etc. 

        
      Another "file" is
        created, I think you mean

    
    Yes :D

    
    -- 

      Angular momentum makes the world go 'round.