Re: Why Size Of Data Backed Up Varies Significantly In SQL 6.5?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Wendy <windy1a(at)yahoo(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Why Size Of Data Backed Up Varies Significantly In SQL 6.5?
Date: 2001-04-26 15:38:00
Message-ID: Pine.LNX.4.30.0104261737220.758-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net http://funkturm.homeip.net/~peter

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Waugh 2001-04-26 15:38:41 Re: Classes of returned rows
Previous Message Peter Eisentraut 2001-04-26 15:36:26 Re: Consulta