Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > It only becomes better if we can throw away that file (or contents) when > > the transaction completes and we have marked all the subtransactions as > > completed. We can't compress pg_clog if we store the parent info in > > there. > > But we already have a recycling mechanism for pg_clog. AFAICS, > creating a parallel log file with a separate recycling mechanism is > a study in wasted effort.
But that recycling requires the vacuum of every database in the system. Do people do that frequently enough? -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
