Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Zc39N-0006Rc-IV for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Sep 2015 03:12:49 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1Zc39N-00018H-4H for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Sep 2015 03:12:49 +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) (envelope-from ) id 1Zc39L-000164-CZ for pgsql-hackers@postgresql.org; Wed, 16 Sep 2015 03:12:47 +0000 Received: from mail-wi0-f172.google.com ([209.85.212.172]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1Zc39I-0001WU-3J for pgsql-hackers@postgresql.org; Wed, 16 Sep 2015 03:12:46 +0000 Received: by wiclk2 with SMTP id lk2so51785588wic.1 for ; Tue, 15 Sep 2015 20:12:42 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:subject:to:references:cc:from:message-id:date :user-agent:mime-version:in-reply-to:content-type; bh=TwR6u3BrGbSZJVVONXZ6gGXH8jDvr1e8Gx2q4THEZtM=; b=Gp69Fn/V2Q7uPouTjCnBdqYbNpU1U+9NGaUm9eRYofe2+1BWAe0U24rbVO+Xc8e27r RynV96CAPwKzriPr94JqgG8SPsT3kWSEwnYW+YNoUDwOkCa0KMGDkL7ouHE1KY6lnMPA zT55SrIryOH6WG0uJnLaFv2X0utO24lBF1t7w3lBgD4GMrOoez7yuA4JebmEKTpvltfH xaAfaEa2/s4208qk1aiN8WBwjVA/L35atxb6XN1zSUxpwqOriBkQoJEyY70oEQkX0dU5 s1PFEKBAkYbRUnWWIEN5L2tDBetywZRnNCCB6cUhgmA5xZ+Yqr84jqHROUt+QJQiBOpy VwMw== X-Gm-Message-State: ALoCoQlf5+m1i3525JkUnH09mlWdZhywgwmZbyI/W+ccHl5dYioh4xq8ambec3EjptPXLTjHjaqu X-Received: by 10.194.92.166 with SMTP id cn6mr47005336wjb.6.1442373162190; Tue, 15 Sep 2015 20:12:42 -0700 (PDT) Received: from ?IPv6:2a00:1028:9941:52fa:14e2:d5a9:70c8:89c3? (dynamic-2a00-1028-9941-52fa-14e2-d5a9-70c8-89c3.ipv6.broadband.iol.cz. [2a00:1028:9941:52fa:14e2:d5a9:70c8:89c3]) by smtp.gmail.com with ESMTPSA id c3sm24090731wja.3.2015.09.15.20.12.37 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 15 Sep 2015 20:12:40 -0700 (PDT) Subject: Re: [DOCS] max_worker_processes on the standby To: Fujii Masao , Robert Haas References: Cc: Alvaro Herrera , pgsql-docs , Pg Hackers , Craig Ringer From: Petr Jelinek Message-ID: <55F8DE22.5090602@2ndquadrant.com> Date: Wed, 16 Sep 2015 05:12:34 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.2.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/mixed; boundary="------------060409090808030104030005" X-Pg-Spam-Score: -2.6 (--) 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 This is a multi-part message in MIME format. --------------060409090808030104030005 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit On 2015-09-03 15:03, Fujii Masao wrote: > On Sat, Aug 8, 2015 at 11:02 PM, Robert Haas wrote: >> There's no existing precedent for a feature that lets the standby be >> different from the master *in any way*. So I don't see why we should >> start here. I think the reasonable definition is that the GUC >> controls whether the master tries to update the SLRU (and generate >> appropriate WAL records, presumably). The standby should not get a >> choice about whether to replay those WAL records. > > +1 > > I added this to the 9.5 open item list. > I see I forgot to send patch for this, so here it is. It just removes the on start check for track_commit_timestamp being same in config and control file. -- Petr Jelinek http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services --------------060409090808030104030005 Content-Type: application/x-patch; name="committs-standby-fix.patch" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="committs-standby-fix.patch" RnJvbSA0OTUzM2Y1NTZkODEyMDU2NGVkODFkYzY3YWNmY2MwM2QyODk0MTY2 IE1vbiBTZXAgMTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBQZXRyIEplbGluZWsg PHBqbW9kb3NAcGptb2Rvcy5uZXQ+CkRhdGU6IFdlZCwgMTYgU2VwIDIwMTUg MDQ6Mjk6MjkgKzAyMDAKU3ViamVjdDogW1BBVENIXSBjb21taXR0cy1zdGFu ZGJ5LWZpeAoKLS0tCiBzcmMvYmFja2VuZC9hY2Nlc3MvdHJhbnNhbS94bG9n LmMgfCAxNiAtLS0tLS0tLS0tLS0tLS0tCiAxIGZpbGUgY2hhbmdlZCwgMTYg ZGVsZXRpb25zKC0pCgpkaWZmIC0tZ2l0IGEvc3JjL2JhY2tlbmQvYWNjZXNz L3RyYW5zYW0veGxvZy5jIGIvc3JjL2JhY2tlbmQvYWNjZXNzL3RyYW5zYW0v eGxvZy5jCmluZGV4IGEwOTJhYWQuLmZjNWExZDcgMTAwNjQ0Ci0tLSBhL3Ny Yy9iYWNrZW5kL2FjY2Vzcy90cmFuc2FtL3hsb2cuYworKysgYi9zcmMvYmFj a2VuZC9hY2Nlc3MvdHJhbnNhbS94bG9nLmMKQEAgLTU4MjYsMTkgKzU4MjYs NiBAQCBkbyB7IFwKIAkJCQkJCW1pblZhbHVlKSkpOyBcCiB9IHdoaWxlKDAp CiAKLSNkZWZpbmUgUmVjb3ZlcnlSZXF1aXJlc0Jvb2xQYXJhbWV0ZXIocGFy YW1fbmFtZSwgY3VyclZhbHVlLCBtYXN0ZXJWYWx1ZSkgXAotZG8geyBcCi0J Ym9vbCBfY3VyclZhbHVlID0gKGN1cnJWYWx1ZSk7IFwKLQlib29sIF9tYXN0 ZXJWYWx1ZSA9IChtYXN0ZXJWYWx1ZSk7IFwKLQlpZiAoX2N1cnJWYWx1ZSAh PSBfbWFzdGVyVmFsdWUpIFwKLQkJZXJlcG9ydChFUlJPUiwgXAotCQkJCShl cnJjb2RlKEVSUkNPREVfSU5WQUxJRF9QQVJBTUVURVJfVkFMVUUpLCBcCi0J CQkJIGVycm1zZygiaG90IHN0YW5kYnkgaXMgbm90IHBvc3NpYmxlIGJlY2F1 c2UgaXQgcmVxdWlyZXMgXCIlc1wiIHRvIGJlIHNhbWUgb24gbWFzdGVyIGFu ZCBzdGFuZGJ5IChtYXN0ZXIgaGFzIFwiJXNcIiwgc3RhbmRieSBoYXMgXCIl c1wiKSIsIFwKLQkJCQkJCXBhcmFtX25hbWUsIFwKLQkJCQkJCV9tYXN0ZXJW YWx1ZSA/ICJ0cnVlIiA6ICJmYWxzZSIsIFwKLQkJCQkJCV9jdXJyVmFsdWUg PyAidHJ1ZSIgOiAiZmFsc2UiKSkpOyBcCi19IHdoaWxlKDApCi0KIC8qCiAg KiBDaGVjayB0byBzZWUgaWYgcmVxdWlyZWQgcGFyYW1ldGVycyBhcmUgc2V0 IGhpZ2ggZW5vdWdoIG9uIHRoaXMgc2VydmVyCiAgKiBmb3IgdmFyaW91cyBh c3BlY3RzIG9mIHJlY292ZXJ5IG9wZXJhdGlvbi4KQEAgLTU4ODUsOSArNTg3 Miw2IEBAIENoZWNrUmVxdWlyZWRQYXJhbWV0ZXJWYWx1ZXModm9pZCkKIAkJ UmVjb3ZlcnlSZXF1aXJlc0ludFBhcmFtZXRlcigibWF4X2xvY2tzX3Blcl90 cmFuc2FjdGlvbiIsCiAJCQkJCQkJCQkgbWF4X2xvY2tzX3Blcl94YWN0LAog CQkJCQkJCQkJIENvbnRyb2xGaWxlLT5tYXhfbG9ja3NfcGVyX3hhY3QpOwot CQlSZWNvdmVyeVJlcXVpcmVzQm9vbFBhcmFtZXRlcigidHJhY2tfY29tbWl0 X3RpbWVzdGFtcCIsCi0JCQkJCQkJCQkgIHRyYWNrX2NvbW1pdF90aW1lc3Rh bXAsCi0JCQkJCQkJCQkgIENvbnRyb2xGaWxlLT50cmFja19jb21taXRfdGlt ZXN0YW1wKTsKIAl9CiB9CiAKLS0gCjEuOS4xCgo= --------------060409090808030104030005 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers --------------060409090808030104030005--