CODEWITHSUNDEEP
herokuheroku-postgres
Ronen Ness
Ronen Ness

Reputation: 10740

migrated db size is smaller than original

I followed the heroku tutorial to upgrade my db from dev to basic, using the backups plugin. everything seems to work just fine, but there is something that bothers me - the size of the new db is smaller than the size of the original db!

when I use pg info info, I get the following information

# New DB (10.7 MB)
Plan:        Basic
Status:      available
Connections: 1
PG Version:  9.2.4
Created:     2013-10-07 17:33 UTC
Data Size:   10.7 MB
Tables:      28
Fork/Follow: Unsupported

# Old DB (14.9 MB)
Plan:        Dev
Status:      available
Connections: 1
PG Version:  9.2.4
Created:     2013-04-25 13:46 UTC
Data Size:   14.9 MB
Tables:      28
Rows:        9717/10000 (In compliance, close to row limit)
Fork/Follow: Unsupported

also, how can I get the rows count of the new db? (I want to validate it has the same number of rows)

thanks!

Upvotes: 0

Views: 547

Answers (1)

Todd C
Todd C

Reputation: 11

I have a similar issue upon upgrading from Ronin to Standard Tengu (9.2 -> 9.3)

I believe the following answers it:

PostgreSQL database size is less after backup/load on Heroku

Upvotes: 1

Related Questions