From: | tfinneid(at)student(dot)matnat(dot)uio(dot)no |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | how to truncate/purge the pg_xlog directory? |
Date: | 2007-10-12 09:23:05 |
Message-ID: | 47138.134.32.140.234.1192180985.squirrel@webmail.uio.no |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
As far as I understand pg_xlog is the transaction log i.e. the WAL.
I have a pg 8.2 which has consumed about 113MB in pg_xlog/, while the
cluster is virtually empty. There are a couple of tables in the postgres
schema, but they contain no data at the moment. My disk is filling up and
I want to purge directories that are larger than need to be.
I performed a VACUUM FULL, because I thought that would help, but it did not.
I searched the net and the forums here and found only one post about
tuning the wal parameters to control the pg_xlog directory size, but when
looking at the documentation for that I found nothing that could be used
for that
Also the base/ directory is 268MB big and still not many tables, is ti
possible to purge that directory as well?.
I would appreciate some help on what to do.
regards
thomas
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2007-10-12 09:41:41 | Re: how to truncate/purge the pg_xlog directory? |
Previous Message | longlong | 2007-10-12 08:15:36 | Re: silent install |