Re: vacuum vs vacuum full - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: vacuum vs vacuum full
Date
Msg-id 1933cd6b-45b0-be1f-3a05-dd02e341ec28@gmx.net
Whole thread Raw
In response to Re: vacuum vs vacuum full  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: vacuum vs vacuum full  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Ron schrieb am 18.11.2020 um 10:44:
> No matter how long it takes, this is an excellent argument for
> partitioning Very Large Tables: many maintenance tasks are made
> *much* easier.

The problem is, you can't partition every table as long as Postgres
does not support a primary key that is independent of the partitioning key
(i.e. until it has "global indexes" as they are called in Oracle)

Thomas



pgsql-general by date:

Previous
From: Hemil Ruparel
Date:
Subject: Re: Postgresql13-devel fails to install on centos 7
Next
From: Olivier Gautherot
Date:
Subject: Re: vacuum vs vacuum full