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

Re: Disk full problem

From: "Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar(dot)Pyatalo(at)honeywell(dot)com>
To: Frank Bax <fbax(at)sympatico(dot)ca>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Disk full problem
Date: 2005-04-22 08:28:57
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
But in the documentation, it says that there can be 2*checkpoint_segments +
1 xlog files at a time. Since I have configured the only 1
checkpoint_segments....there should be a maximum of only 3 xlog files taking
only 48 MB, not 4 taking 65MB.  

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Frank Bax
Sent: Thursday, April 21, 2005 6:26 PM
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Disk full problem

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.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

pgsql-novice by date

Next:From: SG EdwardsDate: 2005-04-22 08:53:10
Subject: Quick join query
Previous:From: Michael FuhrDate: 2005-04-22 00:17:53
Subject: Re: lo_creat SQL command

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