Skip site navigation (1) Skip section navigation (2)

database size question

From: Mija Lee <mija(at)scharp(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: database size question
Date: 2007-12-19 16:53:56
Message-ID: 47694CA4.2030503@scharp.org (view raw or flat)
Thread:
Lists: pgsql-novice
Hi:

I have a discrepancy in database size that I don't quite understand. I'm
using postgres 8.1.3 on solaris 10. I have two databases on the same
machine - the production database and a staging database. The production
database is 9 GB, and growing fairly rapidly. Recently I did a dump and 
restore of the production database to the staging database. The 
recreated staging database was only 2 GB (approximately). There were no 
errors in the reload.

I compared the two databases in terms of number of records, and then
actual table size. At first I thought that there was a problem with the
connection pool in the application which in turn was keeping large
temporary tables around. This was part of the problem but only accounted 
for less than 1 GB of the difference. The real tables are different 
sizes. The ones that seem to show the most difference are tables that 
have the most churn: much of the data is deleted and reinserted nightly.

The database server has autovacuuming turned on, although the
application also vacuums on a schedule.

Anyone have ideas about why this might be, and what the solution is?

Mija



Responses

pgsql-novice by date

Next:From: Sean DavisDate: 2007-12-19 16:57:16
Subject: Re: database size question
Previous:From: A. KretschmerDate: 2007-12-19 10:46:24
Subject: Re: Reading source test of a function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group