Hi,
On 2021-10-13 15:52:46 -0300, Alvaro Herrera wrote:
> > Hm. I guess we can disable autovac. But that's not a great solution, there
> > might be WAL files due to catalog access etc too.
>
> Well, we don't expect anything else to happen -- the cluster is
> otherwise idle. I think we should do it regardless of any other
> changes, just to keep things steadier.
IDK, it seems good to have a bit of variance as well. But I don't have a
strong opinion on it.
> > Another thing: filling a segment by inserting lots of very tiny rows is pretty
> > expensive. Can't we use something a bit wider? Perhaps even emit_message?
FWIW, the count of inserted rows is something like 171985 ;)
> I think I realized partway through writing the test that I could use
> emit_message instead of using a batched row insert ... so, yeah, we
> can use it here also.
Cool. Even if we want to use inserts, lets at least make the rows wide...
I think it'd be good to have a bit of variance in record width. So perhaps
adding a bit of random() in to influence record width would be a good idea?
Greetings,
Andres Freund