Re: how to speed up 002_pg_upgrade.pl and 025_stream_regress.pl under valgrind

2024-09-16 Thread Tomas Vondra
On 9/15/24 21:47, Tomas Vondra wrote: > On 9/15/24 20:31, Tom Lane wrote: >> Tomas Vondra writes: >>> [ 002_pg_upgrade and 027_stream_regress are slow ] >> >>> I don't have a great idea how to speed up these tests, unfortunately. >>> But one of the problems is that all the TAP tests run serially

Re: how to speed up 002_pg_upgrade.pl and 025_stream_regress.pl under valgrind

2024-09-15 Thread Tom Lane
Thomas Munro writes: > (An interesting archeological detail about the regression tests is > that they seem to derive from the Wisconsin benchmark, famous for > benchmark wars and Oracle lawyers[1]. This is quite off-topic for the thread, but ... we actually had an implementation of the Wisconsin

Re: how to speed up 002_pg_upgrade.pl and 025_stream_regress.pl under valgrind

2024-09-15 Thread Thomas Munro
On Mon, Sep 16, 2024 at 6:31 AM Tom Lane wrote: > Really the way to fix those two tests would be to rewrite them to not > depend on the core regression tests. The core tests do a lot of work > that's not especially useful for the purposes of those tests, and it's > not even clear that they are ex

Re: how to speed up 002_pg_upgrade.pl and 025_stream_regress.pl under valgrind

2024-09-15 Thread Tomas Vondra
On 9/15/24 20:31, Tom Lane wrote: > Tomas Vondra writes: >> [ 002_pg_upgrade and 027_stream_regress are slow ] > >> I don't have a great idea how to speed up these tests, unfortunately. >> But one of the problems is that all the TAP tests run serially - one >> after each other. Could we instead r

Re: how to speed up 002_pg_upgrade.pl and 025_stream_regress.pl under valgrind

2024-09-15 Thread Tom Lane
Tomas Vondra writes: > [ 002_pg_upgrade and 027_stream_regress are slow ] > I don't have a great idea how to speed up these tests, unfortunately. > But one of the problems is that all the TAP tests run serially - one > after each other. Could we instead run them in parallel? The tests setup > the