Tom Lane writes:
> [...] Can you correlate the performance hit with any specific part
> of autovacuum? In particular, I'm wondering if it matters whether
> vacuum is cleaning tables or indexes [...]
In case it helps, this systemtap run will report on the top few
time-sampled call graphs of pos
Peter Hopfgartner writes:
> [...]
> > >http://sourceware.org/systemtap/examples/process/sigmon.stp
> Now we had the error, but systemtap did not report any SIGTERM. Is
> it possible to have this error without a SIGTERM being involved? As
> mentioned in a previous mail, I've modified the script
Hi -
peter.hopfgartner wrote:
> >http://sourceware.org/systemtap/examples/process/sigmon.stp
> As it seems I need to recompile the kernel in order to have the debug
> infos, http://sourceware.org/systemtap/wiki/SystemTapOnCentOS.
> Tomorrow I will start the probes.
Check first on http://debugin
Hi All,
even with PITR not in place yet, how far is it possible to use the xlog to
restore a database (beyond redo-after-crash)? Suppose I lose my data
partition, but have an archive of my xlog and clog, and occasional pg_dumps,
it probably won't be as simple as restoring from the dump, stopping p
