Re: Disk usage

On Thu, 8 May 2003, Jay O'Connor wrote:

> On 2003.05.08 04:12 Shridhar Daithankar wrote:
> > On 8 May 2003 at 12:41, Daniel Lublin wrote:
> >
> > >
> > > Good day.
> > >
> > > I am wondering if there is some utility for postgresql, which can
> > > display the amount of disk space that a database (and possibly even
> > > more finer grained; a table) occupies?
> >
> > du in $PGDATA coupled with oid2name to figure out what is the object you
> > are
> > lookng at.
> >
> > HTH
> >
>
> Thanks, I found that helpful.
>
> One question though is about the transaction log files on the px_log
> directory I have two huge files totalling about 30 meg. One thing I'm
> working on is figuring out how much disk usage I'll have for our data
> compared to what we are using now. I'm wondering if I should count those
> two files and if there is a way of eliminating them if they ever become not
> needed

That's the write ahead logging system. It isn't optional, so it won't
ever not be needed. But, you can change how big they are by playing with
the WAL settings in the $PGDATA/postgresql.conf file.

http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=runtime-config.html#RUNTIME-CONFIG-WAL