On Tue, Jan 11, 2022 at 5:38 PM Francisco Olarte <fola...@peoplecall.com> wrote:
> On Tue, 11 Jan 2022 at 17:10, Dominique Devienne <ddevie...@gmail.com> > wrote: > ... > > Creating the first two "fixed" schemas is fast enough. 300ms, including > populating the 2nd with a bunch of rows. > > But creating the 3rd kind, which will be done many times, is not so > fast, at 2.5 - 3s, which may seem fast, > > but when you do it dozens of time in unit-tests, adds up quickly to slow > running tests... > > First question would be, are you running a test server? No. This is a "site" server, used by everyone. Devs and testers / users. > Are you testing crashes of just application logic? > Well, I try to write code that does not crash :) But yes, it's testing results of running the code are as expected. > For these I normally use wal_level=minimal, fsync=off, same as for > full cluster restores ( it is faster to redo it if restore fails, > reinitdb on test cases ), it normally gives quite a nice performance boost. > I'm well versed in libpq, not so much in server admin. The server is "remote" and "just runs", and I connect to it... --DD
