Ed L. pgsql
Fri Nov 12 01:29:25 PST 2004
On Thursday November 11 2004 10:27, Jan Wieck wrote:
> > But back to my original question - is there a way to disable the
> > vacuuming altogether ?
>
> There's no commandline or config option at the moment. But hacking
> cleanup_thread.c might be easy enough to get the desired effect.

So I hacked cleanup_thread.c to skip the if-statement that does the vacuum 
with query3.  Now I'm seeing it do its 2nd round of truncateTable()-copy 
during the copy set operation under the same backend pid.  I can't recreate 
this behavior using the same code on a small pgbench database.

Is there any normal circumstance under which copy set would do it more than 
once??

Ed



More information about the Slony1-general mailing list