Re: vacuum vs vacuum full

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: vacuum vs vacuum full
Дата
Msg-id 1933cd6b-45b0-be1f-3a05-dd02e341ec28@gmx.net
обсуждение исходный текст
Ответ на Re: vacuum vs vacuum full  (Ron <ronljohnsonjr@gmail.com>)
Ответы Re: vacuum vs vacuum full  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список 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 по дате отправления:

Предыдущее
От: Hemil Ruparel
Дата:
Сообщение: Re: Postgresql13-devel fails to install on centos 7
Следующее
От: Olivier Gautherot
Дата:
Сообщение: Re: vacuum vs vacuum full