I have a Plone 4.3 instance using RelStorage. I noticed that the restore of a FileStorage to Relstorage is much slower than saving the RelStorage as FileStorage; in my case (Data.fs size about 3.6 GiB):
RelStorage --> FileStorage: below 20 minutes,
FileStorage --> RelStorage: about 4050 minutes (more than 200 times slower!)
I tried to switch off autovacuum in PostgreSQL during that process, reloading the PostgreSQL demon configuration, but this didn't seem to change much.
- Is this considered normal?
- Could this improve by using newer packages?
- Are there some important configuration tweeks to check?
My current versions:
- PostgreSQL 9.3 (ancient, I know; because of CentOS 7)
- RelStorage 1.6.3
- psycopg2 2.8.6
- ZODB3 3.10.5