Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h1ccc-0003oy-CX for pgsql-hackers@arkaria.postgresql.org; Wed, 06 Mar 2019 19:54:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h1ccb-0007Aq-4X for pgsql-hackers@arkaria.postgresql.org; Wed, 06 Mar 2019 19:54:33 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1h1cca-0007Aj-TA for pgsql-hackers@lists.postgresql.org; Wed, 06 Mar 2019 19:54:32 +0000 Received: from mail-yw1-xc44.google.com ([2607:f8b0:4864:20::c44]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h1ccY-0004bA-Ey for pgsql-hackers@lists.postgresql.org; Wed, 06 Mar 2019 19:54:32 +0000 Received: by mail-yw1-xc44.google.com with SMTP id v201so11080804ywa.9 for ; Wed, 06 Mar 2019 11:54:30 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=from:subject:to:cc:references:openpgp:autocrypt:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=hyvBRgjVyuus8EPbFe7Ual2VNk6TFeiRm/mAniig5io=; b=2RX/IxP6eS/pSjljI9CnljeIn/VawFVbFmL3ltWwkWuzSSMyhs/QzGW8+spNnOhE+a ltJbmv8HpR/5JuW83hE872Xv7LmDCOcx1UEoVXzqFiBSkZsOPvtZTlDL24PmCszAclDV iBWZ3NJowC/BhfBncXHov81P2/CYOv8nXRoWcs9NdqoOBb4D8WIfNulQHcqMpI0omsGZ VBLNSAvVhrgpiIfnOUDjmyfqG62PuWn4Ck3fqTKQutsCBi0p4NxGftMfkk0m2DHTqUej zlqgZjItMiiUJanQOWQGuy07Lm+/zdMGak1ZXIxn6Mwkz/pgfTbMD/JdoQKmNnibiMZP RLfA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:subject:to:cc:references:openpgp:autocrypt :message-id:date:user-agent:mime-version:in-reply-to :content-transfer-encoding:content-language; bh=hyvBRgjVyuus8EPbFe7Ual2VNk6TFeiRm/mAniig5io=; b=pSzCZJrxCwjUjnJagPxVOPeWCCwA/han8v55R+J4RmgIfzCi6QB41Gfn72K7ruFuAZ QqzLhBukJFB4JbKHwquI6iM7/JRZf26Y7HfSbOUahtuo7i2RwLr3SkKDG2p/ThyehX4v YqsUgZFyHEFUpDB2k8Nkpgf4b9jupDZWvv6ouWtIA9sWeVEl5MY0VjeiqlV+mBXdoTsn OWYivGL54s8ToI51c9w+Z5kWkeFR3LUUn06FY0RJATLUbadW7oJ/mBD5bIzNRMTovPtF agKssFBZYLL3sA4kCFmg/ckGXcJNd/9SaMCMd5IzBEjfPo4XeJg02xTxM9VGbpRTqxoZ skeg== X-Gm-Message-State: APjAAAWHB6ihbTJdGaO7u4lhw34RMsyMaaKi59s4nTScMHvuEyP+ywmT ZrseDqcqkrn4QeVIa6ny42If/50OQML9WcLrcbSxa5D34uIKPwmqrP6pqty7Y4Y01hSUEj9TPMp CiF/sajBx9rT4NCmMWn2WN2q+emnSzwprhUHzY0vUeCdr9T/e/BmQMbQ/fN5Cr8I8yr9XzgDQsK o6/zt3gVIzqBtlruLCp9as+b8= X-Google-Smtp-Source: APXvYqy77wPFUy6gSnLJrkohhdGdZIbYw0RX1Efm7PYBGWNGVjXW2hYCI3KKoNMNg+2QXlzKeylLKw== X-Received: by 2002:a81:35d0:: with SMTP id c199mr6847698ywa.439.1551902068464; Wed, 06 Mar 2019 11:54:28 -0800 (PST) Received: from [192.168.10.146] ([98.122.175.38]) by smtp.gmail.com with ESMTPSA id x8sm1646211ywj.94.2019.03.06.11.54.27 (version=TLS1_3 cipher=AEAD-AES128-GCM-SHA256 bits=128/128); Wed, 06 Mar 2019 11:54:27 -0800 (PST) From: Andrew Dunstan X-Google-Original-From: Andrew Dunstan Subject: Re: Should we increase the default vacuum_cost_limit? To: Jeremy Schneider , David Rowley , Joe Conway Cc: Peter Geoghegan , PostgreSQL Hackers References: <241b80ab-7af0-c606-7b2c-b0a5d6be696a@joeconway.com> <4a068b09-5a6f-e975-07c9-2333fcef0a8a@amazon.com> Openpgp: preference=signencrypt Autocrypt: addr=andrew.dunstan@2ndQuadrant.com; prefer-encrypt=mutual; keydata= xsBNBE7KWFkBCAClridxur2AIc7eW2AR7izbfp3EnNefie2HbLF0izW5Ik5UjX2HBXBx4syI gY6b0ugohXrr274+baoAlvSbq6cAoQuEVrk5IZFzt20b1Xkx65FwGSEj526yiKLocqkJceSq Xr9xcA5SGY+FZv441chh5SU92v4q6z+6LPpoHOh97ptAVXZYNTtU0LevyvD5lja0TzbvJm6C eFXitJfnm1pLEr0DGJCR/iUOl/N62Kh4855zZC7NHIjQHPOvV5Stz/l5ilDhvGVk+xkXFPys SjZoUr1rXhYLpiyi5sR0X9FHXT0KnGuz1F5ERO7ZTLSSQ6fJwPj6gOk9K+vvoKvoeql5ABEB AAHNL0FuZHJldyBEdW5zdGFuIDxhbmRyZXcuZHVuc3RhbkAybmRRdWFkcmFudC5jb20+wsCY BBMBAgBCAhsDBgsJCAcDAgYVCAIJCgsEFgIDAQIeAQIXgAUJDyV6hBYhBOQ+WEYd/Hy/RGkV pZn6f8tZ/DuBBQJcH/EVAhkBAAoJEJn6f8tZ/DuB7BEH/iDWZEbVft2m2MT6SPjARzTupt/l xLLZ/Cl6n2US2hov5+fBbnR5xvECk/YCOfG9ICvKNlpFjceqNLRKStd8cmndnI+kDw91uNM2 hpL4aJMeW65XCHvqXlOLSwv5chBpXz9NG7FMaJ+q+59sWEWjcTNmjXgkEHn53y+1pc7nSLDe cr5ZI1aB3nGXRm1SoDY5PYZkUKMykW+YBZwgcs/Q5tRaE+siN7DKbz8E628+PerwAkmHPVXN MdJFD6gs4S0gDFA8IxcyIwZU2v4By+brzcJ9Se3FK5BYxBDHtaYZxgSrJAvOUOrLIZPQTQfL TtnVs3C3JTfrxCH1ceHtnA6dRuTOwE0ETspYWQEIANGc4zQULOxhbqO2dyD51YhqCNRmm9oK Waqf+wmW4tpDe/VVcxAnNizd4LWCHfzpb5cHAtGkOPePMfzWVf6nvdF7d3eglbtf59+zG7O7 llV0xSSoFiieQBsrGvqDInXYX/4mRRXMtyhM353/tixC9RWLs1oofyYmCPPXXY7h9R7en3B8 BoVrRFcdzlIY/NFNhFGW/9dkEiGjgna2Rk6e15kln4ZvFBWUg23p93w/pqXcxY6+k/8TEk+C 4R+M6w7o2PLGOjdZ+kPiUcw5H85zf/yZJwQXzisXaNduwWB6Vads9YC9dj6kPR1c4VGRqAaY L++LAEOqrlvm2TvqQqZRtnEAEQEAAcLAZQQYAQIADwIbDAUCXA6fpAUJDyV6xAAKCRCZ+n/L Wfw7geU4B/9vFFsVmWxerDWgNjyiK80zIPmlw/iwdUlU6FIu0JWLMg4093kvxBs7RMZV9hBq n3ekBvD4IvFsVLJrw9qzSI2FH3UeYy5WXpEs01Ppia60NOlvRDqXbryzuvfe+iYo6bVP3Ikr TPTNYL/BePUTD2DPvSI82SbGTyzuA7SJv6NRqqQDMIy1fU6KyQFLmQJp/QJyhKWzm9jWh8ee w8jVaoMY0Kbq5N7RqisEx1Lu/Iw646UphdYzQNymf+kbiU5Kf4I6DhzV8w9sie1Bo1juNj3I c5/fFJsmxljbnaDbXPcnFsur1Oo9mIHFakgWgOBMuxoWfjONiLjjLh/9+ZIqSSLX Message-ID: <30411a5b-ef11-71ef-e9ee-4d26ef3fd0c0@2ndQuadrant.com> Date: Wed, 6 Mar 2019 14:54:27 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.3.0 MIME-Version: 1.0 In-Reply-To: <4a068b09-5a6f-e975-07c9-2333fcef0a8a@amazon.com> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Content-Language: en-MW List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 3/6/19 1:38 PM, Jeremy Schneider wrote: > On 3/5/19 14:14, Andrew Dunstan wrote: >> This patch is tiny, seems perfectly reasonable, and has plenty of >> support. I'm going to commit it shortly unless there are last minute >> objections. > +1 > done. cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services