Re: Why Size Of Data Backed Up Varies Significantly In SQL 6.5? - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Why Size Of Data Backed Up Varies Significantly In SQL 6.5?
Date
Msg-id Pine.LNX.4.30.0104261737220.758-100000@peter.localdomain
Whole thread Raw
In response to Why Size Of Data Backed Up Varies Significantly In SQL 6.5?  ("Wendy" <windy1a@yahoo.com>)
Responses Re: Why Size Of Data Backed Up Varies Significantly In SQL 6.5?
List pgsql-general
Wendy writes:

> I backed up a database at night and noted the size to be about over 300MB.
> The following morning, I again backed up the same database and found out the
> size to be less than 100MB. There was no massive deletes by users during
> that morning.
> What would account to that vast difference in size?

If you have done a VACUUM in between it's possible that a lot of dead rows
were deleted.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: crypt(table.field) ?
Next
From: Peter Eisentraut
Date:
Subject: Re: I am now Linux and PostgreSQL user, have a question