Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dIL90-0008Di-Mr for pgsql-hackers@arkaria.postgresql.org; Tue, 06 Jun 2017 20:32:02 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dIL90-0005Nt-6E for pgsql-hackers@arkaria.postgresql.org; Tue, 06 Jun 2017 20:32:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dIL7U-0002iA-7w for pgsql-hackers@postgresql.org; Tue, 06 Jun 2017 20:30:28 +0000 Received: from mail-wr0-x232.google.com ([2a00:1450:400c:c0c::232]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dIL7Q-0001ZU-Ka for pgsql-hackers@postgresql.org; Tue, 06 Jun 2017 20:30:27 +0000 Received: by mail-wr0-x232.google.com with SMTP id v104so59156698wrb.0 for ; Tue, 06 Jun 2017 13:30:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:cc:subject:references:date:in-reply-to:message-id :user-agent:mime-version; bh=YLIXEBSZravNmxKXNsus/XgGdmqneRSKP9itsE4E2SM=; b=OW7VDG3+FDOQn3TR1Q5+3O2+5ChWLAFTIQHdz5QS+Q+DWLfXoOSMKT4xkLnBWCWxu0 AEjjSQabrlKBVH5ezCxi6UuX+EEUwV3Fobf0D6tZRf7L8sMlcpwd3VUeRWncs+uF87hy PNR5oRPlK+IDXF1NeFVLPy/XMj1Nu1LqP25gp4FbgMKoH0nDXnOhM0c1Yz1MX9ThI4gh btQm4rclCp4VsDqkVYWKnBh4vw76k+8num1ggaw07brPj68zXh7BLL6PMI15MUKCm2S1 yx5YifuxbBmDLH//6k/BZhp6rail5kWkvCL8pBcNlvtb8tc2whzqVxZPE19+Oy/UArKj J3PQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:cc:subject:references:date:in-reply-to :message-id:user-agent:mime-version; bh=YLIXEBSZravNmxKXNsus/XgGdmqneRSKP9itsE4E2SM=; b=s9kV374d3PXVYGF2IBZ/vg2/kCuD6Nc+r1+Wjsbj3jouwbHoyV/6OF297ZHWMoO0w5 CWgzvjSgQa2Qhom1L+9dOl/Bxdz5WGGvSyZ+5/dTwMsJ7t0Gi6GBVIKRL6n58uqlQNBk 9cIYzYaHioCjH3YAOS9AZulIn7OmgXeitngxrHKVvYLTJ+HaY9biBsz3vjQaaTZ/HKyy 6AO0dsUwFg2J5sdrfGCwCqqMq/+EqIXNwciEQukRXDAUfrbWD68u2KL8qEkQOCMbB+NF AHcX0AKsx8Yb9pBRzxTgT6ewB7uV6/iel6Y2/LBLMaaZmZNfa1hkqyMLWXLYf7flFmwL mcIg== X-Gm-Message-State: AODbwcA3hpkxHiFDqkixg/zz4fwdEk6RCfCZMy0Br4DbS6vitUv1yLF1 yTxDqk7RpOKwZb3Ene58NQ== X-Received: by 10.46.76.18 with SMTP id z18mr8732016lja.9.1496781022752; Tue, 06 Jun 2017 13:30:22 -0700 (PDT) Received: from seb.koffice.internal ([46.231.208.130]) by smtp.gmail.com with ESMTPSA id 75sm7893679lja.53.2017.06.06.13.30.20 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 06 Jun 2017 13:30:21 -0700 (PDT) From: Sergey Burladyan To: Dmitriy Sarafannikov Cc: Amit Kapila , Vladimir Borodin , pgsql-hackers Subject: Re: Broken hint bits (freeze) References: <2E86EB5F-50ED-4DE2-B14E-98EF8F62B2F2@simply.name> <4C1127FC-74AE-4544-9B22-6A32FD0C0607@yandex.ru> Date: Tue, 06 Jun 2017 23:30:20 +0300 In-Reply-To: <4C1127FC-74AE-4544-9B22-6A32FD0C0607@yandex.ru> (Dmitriy Sarafannikov's message of "Fri, 2 Jun 2017 13:50:49 +0300") Message-ID: <87wp8o506b.fsf@seb.koffice.internal> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.3 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org Dmitriy Sarafannikov writes: > Starting and stopping master after running pg_upgrade but before rsync to collect statistics > was a bad idea. But, starting and stopping master after running pg_upgrade is *required* by documentation: https://www.postgresql.org/docs/9.6/static/pgupgrade.html > f. Start and stop the new master cluster > In the new master cluster, change wal_level to replica in the postgresql.conf file and then start and stop the cluster. and there is no any suggestion to disable autovacuum for it. -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers