From: Alex Ignatov <a.ignatov@postgrespro.ru>
To: Artem Tomyuk <admin@leboutique.com>
To: pgsql-admin@postgresql.org
Subject: Re: index
Date: Tue, 10 Nov 2015 12:51:50 +0300
Message-ID: <5641BE36.4050605@postgrespro.ru> (raw)
In-Reply-To: <CANYYVq+dofQK5DHTqTg=KQHeFha-FkqFh94UA16yEsiCeG2LRA@mail.gmail.com>
References: <CANYYVq+dofQK5DHTqTg=KQHeFha-FkqFh94UA16yEsiCeG2LRA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: a.ignatov@postgrespro.ru, admin@leboutique.com
Subject: Re: index
In-Reply-To: <5641BE36.4050605@postgrespro.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox