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

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Vince McMahon <sippingonesandzeros(at)gmail(dot)com>
Cc: Ron <ronljohnsonjr(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Does standalone postfrsql have autogrowth/ manual growth on table space?
Date: 2022-10-20 18:48:20
Message-ID: 29C10C57-B9DA-4136-A427-B33F71768F0E@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Oct 20, 2022, at 11:45, Vince McMahon <sippingonesandzeros(at)gmail(dot)com> wrote:
>
> Thanks. I guess it is time for vacuum. 😂

Ironically, vacuum is the main issue. The main reason that you can't just slap a few gigabytes onto the end of a table is that the next time vacuum runs, it will happily truncate it all away.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lists 2022-10-20 19:51:39 Re: PG RPMS for RHEL 9 on aarch64?
Previous Message Vince McMahon 2022-10-20 18:45:43 Re: Does standalone postfrsql have autogrowth/ manual growth on table space?