On Tue, Jan 11, 2022 at 5:38 PM Francisco Olarte <folarte@xxxxxxxxxxxxxx> wrote:
On Tue, 11 Jan 2022 at 17:10, Dominique Devienne <ddevienne@xxxxxxxxx> 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
