Re: [HACKERS] Decoding of (nearly) empty transactions and regression tests

2014-06-29 Thread Tom Lane
Andres Freund writes: > Hm? I think we're misunderstanding each other - I was thinking of tacking > ALTER TABLE .. SET (AUTOVACUUM_ENABLED = false) to the tables created in > test_decoding/sql/, not to something outside. Ah, got it. Yeah, seems like an OK workaround. reg

Re: [HACKERS] Decoding of (nearly) empty transactions and regression tests

2014-06-29 Thread Andres Freund
On 2014-06-29 11:08:39 -0400, Tom Lane wrote: > Andres Freund writes: > > On 2014-06-29 10:36:22 -0400, Tom Lane wrote: > >> You mean disable autovac only in the contrib/test_decoding check run, > >> right? That's probably OK since it's tested in the main regression > >> runs. > > > Actually I'd

Re: [HACKERS] Decoding of (nearly) empty transactions and regression tests

2014-06-29 Thread Tom Lane
Andres Freund writes: > On 2014-06-29 10:36:22 -0400, Tom Lane wrote: >> You mean disable autovac only in the contrib/test_decoding check run, >> right? That's probably OK since it's tested in the main regression >> runs. > Actually I'd not even though of that, but just of disabling it on > rela

Re: [HACKERS] Decoding of (nearly) empty transactions and regression tests

2014-06-29 Thread Andres Freund
On 2014-06-29 10:36:22 -0400, Tom Lane wrote: > Andres Freund writes: > > Solution I) > > Change ReorderBufferCommit() to not call the begin()/commit() callbacks > > if no change() callback has been called. Technically that's trivial, but > > I don't think that'd end up being a better behaviour. >

Re: [HACKERS] Decoding of (nearly) empty transactions and regression tests

2014-06-29 Thread Tom Lane
Andres Freund writes: > Solution I) > Change ReorderBufferCommit() to not call the begin()/commit() callbacks > if no change() callback has been called. Technically that's trivial, but > I don't think that'd end up being a better behaviour. > Solution II) > Disable autovacuum/analyze for the tabl