Re: pg_log

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

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"

:)

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