Re: pg_log

* Tom Lane <tgl@sss.pgh.pa.us> [010116 16:38] wrote:
> "Andrew W. Nosenko" <awn@bcs.zp.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@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."