Re: after restore the size of the database is increased

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: after restore the size of the database is increased
Дата
Msg-id CAH2-Wz=ue+Xjd8LOPr+eOvfpEhnxHaX6=R7Y0mXHrd5WsYvbVA@mail.gmail.com
обсуждение исходный текст
Ответ на after restore the size of the database is increased  (Luca Ferrari <fluca1978@gmail.com>)
Ответы Re: after restore the size of the database is increased  (Luca Ferrari <fluca1978@gmail.com>)
Список pgsql-general
Дерево обсуждения 
On Mon, Jul 15, 2019 at 6:22 AM Luca Ferrari <fluca1978@gmail.com> wrote:
> What am I missing here?

Sometimes B-Tree indexes can be *larger* after a REINDEX (or after
they're recreated with a CREATE INDEX). It's not that common, but it
does happen. There isn't actually a very large size difference here,
so it seems worth comparing index size in detail.

-- 
Peter Geoghegan

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: after restore the size of the database is increased
Следующее
От: "Chatterjee, Shibayan"
Дата:
Сообщение: RE: Issue: Creating Symlink for data directory of postgresql inCentOS7