pgsql: Don't auto-restart per-database autoprewarm workers. - Mailing list pgsql-committers

From Robert Haas
Subject pgsql: Don't auto-restart per-database autoprewarm workers.
Date
Msg-id E1h5y2g-0005OH-2P@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Don't auto-restart per-database autoprewarm workers.

We should try to prewarm each database only once.  Otherwise, if
prewarming fails for some reason, it will just keep retrying in an
infnite loop.  This can happen if, for example, the database has been
dropped.  The existing code was intended to implement the try-once
behavior, but failed to do so because it neglected to set
worker.bgw_restart_time to BGW_NEVER_RESTART.

Mithun Cy, per a report from Hans Buschmann

Discussion: http://postgr.es/m/CA+hUKGKpQJCWcgyy3QTC9vdn6uKAR_8r__A-MMm2GYfj45caag@mail.gmail.com

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/fc8b39a46eb7132edc0165f23b738a2292ee9ca9

Modified Files
--------------
contrib/pg_prewarm/autoprewarm.c | 1 +
1 file changed, 1 insertion(+)


pgsql-committers by date:

Previous
From: Robert Haas
Date:
Subject: pgsql: Revise parse tree representation for VACUUM and ANALYZE.
Next
From: Andres Freund
Date:
Subject: pgsql: Remove leftover reference to oid column.