3 ms·
Yes, it's significantly faster because it doesn't require rebuilding indexes (among other reasons probably). Downside is it consumes more disk space. Stellar i
by gkop 6y ago
Yes, it's significantly faster because it doesn't require rebuilding indexes (among other reasons probably). Downside is it consumes more disk space.
Stellar is a tool that wraps the template mechanism, and has some benchmarks: https://github.com/fastmonkeys/stellar https://github.com/fastmonkeys/stellar
- jpitz 6y agoMy understanding has always been that creating a database is essentially a series of file copy operations from the template.
- gkop 6y agoThat may be true! The point is the template has the indexes already built ready to copy. Where the dump file does not.
- gkop 6y agoOh another key downside I remembered of the template mechanism, at least with Postgres 9.6, is that you can't have any connections open to the source database when making a snapshot copy.