Postgres Pro
Downloads
Home   >   mailing lists

Re: Does standalone postfrsql have autogrowth/ manual growth on table space? - Mailing list pgsql-general

From Vince McMahon
Subject Re: Does standalone postfrsql have autogrowth/ manual growth on table space?
Date
Msg-id CAKS+vVYsxMb1XL4Ay8xsMY_9+2LrjTUyKmf0h6dKcQPmTdAr1w@mail.gmail.com
Whole thread Raw
In response to Re: Does standalone postfrsql have autogrowth/ manual growth on table space?  (Christophe Pettus <xof@thebuild.com>)
Responses Re: Does standalone postfrsql have autogrowth/ manual growth on table space?
List pgsql-general
Tree view
Thanks.  I guess it is time for vacuum. 😂

On Thu, Oct 20, 2022, 13:34 Christophe Pettus <xof@thebuild.com> wrote:


> On Oct 20, 2022, at 10:29, Ron <ronljohnsonjr@gmail.com> wrote:
> There's no pre-allocation in Postgresql.

This is correct in that you can't say "please allocate 3GB for this table for me now."  The number of pages that are added to the end of a file isn't always one though; it can allocate more based on recent activity.

pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: Does standalone postfrsql have autogrowth/ manual growth on table space?
Next
From: Christophe Pettus
Date:
Subject: Re: Does standalone postfrsql have autogrowth/ manual growth on table space?