Re: after restore the size of the database is increased

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Luca Ferrari <fluca1978(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: after restore the size of the database is increased
Date: 2019-07-15 17:20:57
Message-ID: CAH2-Wz=ue+Xjd8LOPr+eOvfpEhnxHaX6=R7Y0mXHrd5WsYvbVA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jul 15, 2019 at 6:22 AM Luca Ferrari <fluca1978(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chatterjee, Shibayan 2019-07-15 18:10:01 RE: Issue: Creating Symlink for data directory of postgresql in CentOS7
Previous Message Adrian Klaver 2019-07-15 17:07:51 Re: after restore the size of the database is increased