From: | tfinneid(at)student(dot)matnat(dot)uio(dot)no |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: how to truncate/purge the pg_xlog directory? |
Date: | 2007-10-12 13:44:16 |
Message-ID: | 47682.134.32.140.234.1192196656.squirrel@webmail.uio.no |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> As checkpoints are issued, old WAL files will either be recycled
> (renamed) or deleted. Change the setting, then try (as user postgres)
> issuing a "vacuum full <tbl>" followed by "SELECT pg_switch_xlog()" that
> should recycle them quicker. That'll only get you down to 3 or 4 files
> though - that's the minimum.
Nothings changed yet, maybe I need to start using the db again before I
something real happens...
>>> You might find the "pg_xxx_size()" functions useful - they are detailed
>>> in the functions/system-admin chapter of the manuals.
>>
>> Can you be a bit more specific? I tried looking for it, but the sections
>> are too big to just browse unknown information.
>
> Try looking again, perhaps?
> Go to the online manuals, go to the section on "functions and operators"
> then to the section on "system administration functions". The first
> ocurrence of the word "size" on that page is a heading for the bit you
> need.
That was not easy to find, your descriptions were not easy to dechiper.
When you said sys-admin chapter I started looking for a functions chapter
in section 3 (i.e. chapters 14-28), but you were talking about chapter
9... which is in the section about the sql language. Quite confusing.
regards
thomas
From | Date | Subject | |
---|---|---|---|
Next Message | Sam Mason | 2007-10-12 13:46:19 | Re: disjoint union types |
Previous Message | Clemens Schwaighofer | 2007-10-12 13:14:28 | Query problem |