Re: pg_log

* 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."