Обсуждение: index

Поиск
Список
Период
Сортировка

index

От
Artem Tomyuk
Дата:
Hello.

After upgrading to 9.4 from 9.1 i noticed that indexes recreating slower from backup than it was on 9.1. 
Is it possible?

I am making backup of db on 9.1 pg server and then restoring in on 9.4 every night. 
Thanks

Re: index

От
Alex Ignatov
Дата:
Hello!
What is your maintenance_work_mem parameter value in 9.4 and 9.1?

On 10.11.2015 9:56, Artem Tomyuk wrote:
> Hello.
>
> After upgrading to 9.4 from 9.1 i noticed that indexes recreating
> slower from backup than it was on 9.1.
> Is it possible?
>
> I am making backup of db on 9.1 pg server and then restoring in on 9.4
> every night.
> Thanks

--
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company