Potential performance improvement to restore databases template ?

[lse-odoo]

Database created from template from odev used the default strategy, see:

odev/odev/common/connectors/postgres.py

Line 195 in 0339cfc

WITH TEMPLATE "{template}"

However, other strategies exist and might be better for big databases, see;
See: https://www.postgresql.org/docs/current/sql-createdatabase.html#CREATE-DATABASE-STRATEGY

I tested locally with a upgrade database dump (6466 MB), the results are not incredible, but it might be worth to consider with other database;
w/ default strategy (WAL_LOG according to SQL doc): ~19 seconds
w/ STATEGY = FILE_COPY: ~ 18 seconds

[brinkflew]

It will be difficult to find the pivot point where it becomes faster to change strategy, I suppose we'll have to rely on size only but there should be other parameters to take into account as well. It is very rare I have to restore databases larger than ~500MB honestly (maybe it's only me). I would put this request aside because of the following reasons:

1. Small databases: taking a few seconds to fully restore, shaving 1 or 2 seconds won't be noticeable
2. Large databases: taking up to 15 minutes (40GB after restore), shaving even 2 minutes won't make a real difference either IMO

I won't work on this unless we have more proof that this is actually beneficial