Re: Vacuum Full not clean the table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Erik Serrano <eserranos@xxxxxxxxx>
Subject: Re: Vacuum Full not clean the table
From: Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx>
Date: Tue, 7 Feb 2023 11:17:09 -0700
Cc: pgsql-admin <pgsql-admin@xxxxxxxxxxxxxx>, Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <CA+dvXXu2krLsS3K_GJkdrCT1hbu+G0rxAjh1KKot5TGrBpn8AA@mail.gmail.com>
References: <CA+dvXXu2krLsS3K_GJkdrCT1hbu+G0rxAjh1KKot5TGrBpn8AA@mail.gmail.com>

> On Feb 7, 2023, at 9:51 AM, Erik Serrano <eserranos@xxxxxxxxx> wrote:
> 
> (table of 420MM records with 20MM dead tuples

Why do you need a vacuum full? Are you really being hurt by 5% dead tuples?

References:
- Vacuum Full not clean the table
  - From: Erik Serrano

Prev by Date: Re: Vacuum Full not clean the table
Next by Date: Re: Vacuum Full not clean the table
Previous by thread: Re: Vacuum Full not clean the table
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Home] [Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite Forum]

Powered by Linux