Can dumping and restoring database make it slower?

263 views Asked by At

I have a Amazon RDS Postgres database. I created a snapshot of this database(say database-A) and then restored the snapshot on a new db instance(say database-B). database-A was a 8 GiB machine with 2 cores. database-B is a 3.75 GiB machine with 1 core.

I find the following:

  1. Storage occupied by database-B is greater than database-A. I found the occupied storage using pg_database_size.

  2. I find the queries slower on database-B than they were on database-A.

Are these two things possible in normal scenario or I must have made some mistake during dump/restore process?

0

There are 0 answers