up vote 3 down vote favorite
share [g+] share [fb]

When using CREATE DATABASE TEMPLATE in PostgreSQL, will the target database preserve the statistics from the source database?

link|improve this question
feedback

2 Answers

up vote 0 down vote

I do not believe so -- You will get a copy of the tables/triggers/etc., but they will have new OIDs, and the statistics will need to be regenerated.

It's possible that the statistics will be populated for you (equivalent of doing an ANALYZE on the new DB) - I haven't investigated that though, and if it's not the case you can speed up the process by doing it manually.

link|improve this answer
feedback
up vote 0 down vote

Yes, it's a straight file-level copy of the template database, so whatever was in there will be in the new database.

link|improve this answer
Hmm, I cloned a database that had a vacuum/autovacuum listed in pg_stat_user_tables for example, but the cloned database did not (using "create database new template old;"). It seems the statistics did not get copied, I wrong? – wojo Feb 22 at 18:17
The pg_stat_* tables are not actually tables but views that access information in shared memory. So the information there is not affected by the copying of the template database. – Peter Eisentraut Feb 22 at 21:15
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.