Hi, On 2019-05-06 16:54:08 +0530, Siddharth Karandikar wrote: > I am trying to restore database dump created on PostgreSQL 9.5.16 to > PostgreSQL 10.7 and it is taking a lot of time to restore. Restoring > the same dump to 9.5 doesn't take that much. So I am wondering what > could be reason behind this slowness. Is there any chance the configuration is different between 9.5 and 10? If there e.g. is an index on the table, the maintanance_work_mem setting would make a large differerence when rebuilding. Note that the medium-tablecase is noticably faster in 10 and that there's been some speedup work around that in 10. > > Postgres configuration that I have on this setup: > shared_buffers = 128MB > > work_mem = 1MB > maintenance_work_mem = 16MB maintenance_work_mem = 16Mb is a very low value - it's e.g. used for index builds, to sort the data. Greetings, Andres Freund
