Re: Should a DB vacuum use up a lot of space ?

From: Philippe Girolami <philippe(dot)girolami(at)mosaik(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Should a DB vacuum use up a lot of space ?
Date: 2016-08-07 07:32:07
Message-ID: 8F4598C0-4F7B-4348-BA26-53B11F4176B9@mosaik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

@Adrian, no problem ! I’m sure someone else will run into this and have the same questions, hopefully they’ll find the answers.

I am seeing something weird though (again, this is v9.1): after my database became usable again, I started getting the 10M warning on template0. So I made it connectable and ran VACUUM FREEZE on it and made it unconnectable again. That resolve the warning.

However, I see the “age” keeps increasing on that database as I ran queries on my own db. Yesterday the age was 32 and now it’s already 77933902
Is that to be expected ? I didn’t expect it

Thanks

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Joseph Krogh 2016-08-07 08:05:52 Re: Updated RUM-index and support for bigint as part of index
Previous Message Andreas Joseph Krogh 2016-08-07 06:42:40 Re: Updated RUM-index and support for bigint as part of index