Re: proposal: CREATE DATABASE vs. (partial) CHECKPOINT

Tomas Vondra wrote
> I mean, when we use database A as a template, why do we need to checkpoint
> B, C, D and F too? (Apologies if this is somehow obvious, I'm way out of
> my comfort zone in this part of the code.)

IIUC you have to checkpoint the whole cluster because it is not possible to
do checkpoint individual databases.  There is only a single WAL stream and
while it could have source database markers I don't believe it does so there
is no way to have separate checkpoint locations recorded for different
databases. 

Adding such seems to introduce a lot of book-keeping and both reload and
file size overhead for little practical gain.

David J.



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/proposal-CREATE-DATABASE-vs-partial-CHECKPOINT-tp5824343p5824522.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.