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

Disk full problem

From: Prashant <pachik(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Disk full problem
Date: 2005-04-20 07:06:40
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Hi all,

I am a new addition to this mailing list. I am using Postgresql 7.4.3.
I went through the postgresql documentation for saving the disk usage.
Accordingly i changed the checkpoint_segments parameter to 1 in the
postgresql.conf file. I cross checked by giving the SHOW ALL command.
It shows 1 for the checkpoint_segments parameter. But when I chk the
disk usage, the pg_xlog folder is taking up 65MB. There are 4 files
under pg_xlog folder. According to the documentation, it should be
taking only 16MB.

And one more thing I noticed was that the base folder under pgsql/data
folder is taking up 25MB space.

How do I reduce the space taken up by these folders. I am running the
vaccumdb command at regular intervals.

Thanks in advance.


pgsql-novice by date

Next:From: tövisDate: 2005-04-20 08:36:08
Subject: Re: records chaining
Previous:From: John DeSoiDate: 2005-04-20 05:05:58
Subject: Re: Pqintaller for Windows Leaving me with Questions

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