Lists: | pgsql-novice |
---|
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: | 169e29a905042000066d471b2d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
From: | Frank Bax <fbax(at)sympatico(dot)ca> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Disk full problem |
Date: | 2005-04-21 12:56:25 |
Message-ID: | 5.2.1.1.0.20050421082836.04aebc90@pop6.sympatico.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-novice |
At 03:06 AM 4/20/05, Prashant wrote:
>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.
Not quite. the docs say 16M per file. 4 files * 16M = 64M
>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.
pgsql/data contains one folder for each database you created. To further
reduce space here, you'll need to drop tables and/or databases.