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

Re: database question

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: john(dot)crawford(at)sirsidynix(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: database question
Date: 2008-09-29 22:14:53
Message-ID: Pine.GSO.4.64.0809291805120.16949@westnet.com (view raw or flat)
Thread:
Lists: pgsql-general
On Mon, 29 Sep 2008, john(dot)crawford(at)sirsidynix(dot)com wrote:

> What are these files and why have they suddenly started to be created
> and why so large?

They're the contents of the database and they get created every time there 
is another 1GB worth of data in there.  Note that the database will use 
more space if data is being UPDATEd and you don't vacuum it regularly. 
Without the vacuum going it's as if you'd added a new row instead when you 
update something.

While it's possible to decode what those files are by using oid2name or 
pg_class, what you probably want to know instead is what the big tables 
and indexes in your database are to figure out what is gobbling space. 
The script at http://wiki.postgresql.org/wiki/Disk_Usage will give you 
that.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

pgsql-general by date

Next:From: Bruce MomjianDate: 2008-09-29 23:06:46
Subject: Re: pg_start_backup() takes too long
Previous:From: David RowleyDate: 2008-09-29 22:11:04
Subject: Re: Sample databases

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