From: | Alfred Perlstein <bright(at)wintelcom(dot)net> |
---|---|
To: | "Andrew W(dot) Nosenko" <awn(at)bcs(dot)zp(dot)ua>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_log |
Date: | 2001-01-17 09:52:55 |
Message-ID: | 20010117015255.J7240@fw.wintelcom.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
* Andrew W. Nosenko <awn(at)bcs(dot)zp(dot)ua> [010117 01:16] wrote:
> Alfred Perlstein wrote:
> : * Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> [010116 16:38] wrote:
> : > "Andrew W. Nosenko" <awn(at)bcs(dot)zp(dot)ua> writes:
> : > > Question: what is logged in pg_log table and how I can cleanup it?
> : >
> : > Transaction commit-status bits, and don't even *think* of touching it.
> : > Easiest way to hose your database that I know of :-(
> : >
> : > If it gets big enough to be really annoying, you can
> : > dumpall/initdb/reload. There is no shortcut.
>
> Thanks to Tom for answer, this is exactly what I want to know.
>
> :
> : My pg_log file is about 3MB on one server and 5MB on another. If
> : 3-6MB is a "pretty large" size for pg_log and people are deleting
> : it, perhaps a name change is in order?
> :
> : pg_commitstatus? or something?
> :
> : I think pg_'log' screams 'delete me please' to um... "power users"
> :
> : :)
> :
>
> Sorry for my English, when I say `cleanup' I don't say about deleting
> file nor about any other changes directly/"in evade"/without PostrgreSQL
> backend. But simple about `is this file/table/etc have data what never
> be used anymore (like deleted tuples in regular tables)?' and if this
> sort of data exist then `is exist some analog of VACUUM that can return
> this space into filesystem (decrease size of file)?'
We get a lot of "I deleted pg_log and now everything is broke" emails
on this list.
Just curious, how large is this file on your system?
--
-Alfred Perlstein - [bright(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
"I have the heart of a child; I keep it in a jar on my desk."
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Ansley | 2001-01-17 10:31:42 | RE: MySQL file system |
Previous Message | Marc SCHAEFER | 2001-01-17 09:38:37 | Re: Re: MySQL file system |