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.92) (envelope-from ) id 1jI4qE-0001Pp-Dr for pgsql-committers@arkaria.postgresql.org; Sat, 28 Mar 2020 06:21:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jI4qC-0006NB-MH for pgsql-committers@arkaria.postgresql.org; Sat, 28 Mar 2020 06:21:08 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1jI4qC-0006N4-9e for pgsql-committers@lists.postgresql.org; Sat, 28 Mar 2020 06:21:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1jI4q5-000687-ER for pgsql-committers@lists.postgresql.org; Sat, 28 Mar 2020 06:21:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=7zVuiv65JTdAvtXYDQ0ekoUtaUqc++HA3fMy6FDY+90=; b=dB6FLbXKz4DVNAK3/hV9D2KgGz Oj9iDgZPYqEemXp5BxXnnGQoWNX+v0VdZ5q1156OgVh7E/dqxcGKTZeg7W5Oq4HNItCfN3Nq9jL/l 3OJuQE4mgNWZc6AFXgrUzNke/jr/zK6muoUtQRbbrfpx07xwSLwnIrEPI2Qq5JgRn384+nX8FDYAF aVCaA9FdF2ogIo5y5ww73QAnvv823wMHPAH5Q58x2amT8tCC95TDccEAh+d/gzJq2iHPBQS6I/bhm FG+9SaJLJJGimPz5+Yv5DEIbin1HYnVYzVnyRE/kl1QWkijaqWlcIwMV1ILrCiwLxaw2kpQdJKsT6 2UB25WBw==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1jI4q5-0004sI-3r for pgsql-committers@lists.postgresql.org; Sat, 28 Mar 2020 06:21:01 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jI4q4-0005aq-U3 for pgsql-committers@lists.postgresql.org; Sat, 28 Mar 2020 06:21:00 +0000 Content-Type: multipart/mixed; boundary="===============2714264055872024693==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Trigger autovacuum based on number of INSERTs Message-Id: Date: Sat, 28 Mar 2020 06:21:00 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============2714264055872024693== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VHJpZ2dlciBhdXRvdmFjdXVtIGJhc2VkIG9uIG51bWJlciBvZiBJTlNFUlRzCgpUcmFkaXRpb25h bGx5IGF1dG92YWN1dW0gaGFzIG9ubHkgZXZlciBpbnZva2VkIGEgd29ya2VyIGJhc2VkIG9uIHRo ZQplc3RpbWF0ZWQgbnVtYmVyIG9mIGRlYWQgdHVwbGVzIGluIGEgdGFibGUgYW5kIGZvciBhbnRp LXdyYXBhcm91bmQKcHVycG9zZXMuIEZvciB0aGUgbGF0dGVyLCB3aXRoIGNlcnRhaW4gY2xhc3Nl cyBvZiB0YWJsZXMgc3VjaCBhcwppbnNlcnQtb25seSB0YWJsZXMsIGFudGktd3JhcGFyb3VuZCB2 YWN1dW1zIGNvdWxkIGJlIHRoZSBmaXJzdCB2YWN1dW0gdGhhdAp0aGUgdGFibGUgZXZlciByZWNl aXZlcy4gVGhpcyBjb3VsZCBvZnRlbiBsZWFkIHRvIGF1dG92YWN1dW0gd29ya2VycyBiZWluZwpi dXN5IGZvciBleHRlbmRlZCBwZXJpb2RzIG9mIHRpbWUgZHVlIHRvIGhhdmluZyB0byBwb3RlbnRp YWxseSBmcmVlemUKZXZlcnkgcGFnZSBpbiB0aGUgdGFibGUuIFRoaXMgY291bGQgYmUgcGFydGlj dWxhcmx5IGJhZCBmb3IgdmVyeSBsYXJnZQp0YWJsZXMuIE5ldyBjbHVzdGVycywgb3IgcmVjZW50 bHkgcGdfcmVzdG9yZWQgY2x1c3RlcnMgY291bGQgc3VmZmVyIGV2ZW4KbW9yZSBhcyBtYW55IGxh cmdlIHRhYmxlcyBtYXkgaGF2ZSB0aGUgc2FtZSByZWxmcm96ZW54aWQsIHdoaWNoIGNvdWxkCnJl c3VsdCBpbiBsYXJnZSBudW1iZXJzIG9mIHRhYmxlcyByZXF1aXJpbmcgYW4gYW50aS13cmFwYXJv dW5kIHZhY3V1bSBhbGwKYXQgb25jZS4KCkhlcmUgd2UgYWltIHRvIHJlZHVjZSB0aGUgd29yayBy ZXF1aXJlZCBieSBhbnRpLXdyYXBhcm91bmQgYW5kIGFnZ3Jlc3NpdmUKdmFjdXVtcyBpbiBnZW5l cmFsLCBieSB0cmlnZ2VyaW5nIGF1dG92YWN1dW0gd2hlbiB0aGUgdGFibGUgaGFzIHJlY2VpdmVk CmVub3VnaCBJTlNFUlRzLiBUaGlzIGlzIGNvbnRyb2xsZWQgYnkgYWRkaW5nIHR3byBuZXcgR1VD cyBhbmQgcmVsb3B0aW9uczsKYXV0b3ZhY3V1bV92YWN1dW1faW5zZXJ0X3RocmVzaG9sZCBhbmQK YXV0b3ZhY3V1bV92YWN1dW1faW5zZXJ0X3NjYWxlX2ZhY3Rvci4gVGhlc2Ugd29yayBleGFjdGx5 IHRoZSBzYW1lIGFzIHRoZQpleGlzdGluZyBzY2FsZSBmYWN0b3IgYW5kIHRocmVzaG9sZCBjb250 cm9scywgb25seSBiYXNlIHRoZW1zZWx2ZXMgb2ZmIHRoZQpudW1iZXIgb2YgaW5zZXJ0cyBzaW5j ZSB0aGUgbGFzdCB2YWN1dW0sIHJhdGhlciB0aGFuIHRoZSBudW1iZXIgb2YgZGVhZAp0dXBsZXMu IE5ldyBjb250cm9scyB3ZXJlIGFkZGVkIHJhdGhlciB0aGFuIHJldXNpbmcgdGhlIGV4aXN0aW5n CmNvbnRyb2xzLCB0byBhbGxvdyB0aGVzZSBuZXcgdmFjdXVtcyB0byBiZSB0dW5lZCBpbmRlcGVu ZGVudGx5IGFuZCBwZXJoYXBzCmV2ZW4gY29tcGxldGVseSBkaXNhYmxlZCBhbHRvZ2V0aGVyLCB3 aGljaCBjYW4gYmUgZG9uZSBieSBzZXR0aW5nCmF1dG92YWN1dW1fdmFjdXVtX2luc2VydF90aHJl c2hvbGQgdG8gLTEuCgpXZSBtYWtlIG5vIGF0dGVtcHQgdG8gc2tpcCBpbmRleCBjbGVhbnVwIG9w ZXJhdGlvbnMgb24gdGhlc2UgdmFjdXVtcyBhcwp0aGV5IG1heSB0cmlnZ2VyIGZvciBhbiBpbnNl cnQtbW9zdGx5IHRhYmxlIHdoaWNoIGNvbnRpbnVhbGx5IGRvZXNuJ3QgaGF2ZQplbm91Z2ggZGVh ZCB0dXBsZXMgdG8gdHJpZ2dlciBhbiBhdXRvdmFjdXVtIGZvciB0aGUgcHVycG9zZSBvZiByZW1v dmluZwp0aG9zZSBkZWFkIHR1cGxlcy4gSWYgd2Ugd2VyZSB0byBza2lwIGNsZWFuaW5nIHRoZSBp bmRleGVzIGluIHRoaXMgY2FzZSwKdGhlbiBpdCBpcyBwb3NzaWJsZSBmb3IgdGhlIGluZGV4KGVz KSB0byBiZWNvbWUgYmxvYXRlZCBvdmVyIHRpbWUuCgpUaGVyZSBhcmUgYWRkaXRpb25hbCBiZW5l Zml0cyB0byB0cmlnZ2VyaW5nIGF1dG92YWN1dW1zIGJhc2VkIG9uIGluc2VydHMsCmFzIHRhYmxl cyB3aGljaCBuZXZlciBjb250YWluIGVub3VnaCBkZWFkIHR1cGxlcyB0byB0cmlnZ2VyIGFuIGF1 dG92YWN1dW0KYXJlIG5vdyBtb3JlIGxpa2VseSB0byByZWNlaXZlIGEgdmFjdXVtLCB3aGljaCBj YW4gbWFyayBtb3JlIG9mIHRoZSB0YWJsZQphcyAiYWxsdmlzaWJsZSIgYW5kIGVuY291cmFnZSB0 aGUgcXVlcnkgcGxhbm5lciB0byBtYWtlIHVzZSBvZiBJbmRleCBPbmx5ClNjYW5zLgoKQ3VycmVu dGx5LCB3ZSBzdGlsbCBvYmV5IHZhY3V1bV9mcmVlemVfbWluX2FnZSB3aGVuIHRyaWdnZXJpbmcg dGhlc2UgbmV3CmF1dG92YWN1dW1zIGJhc2VkIG9uIElOU0VSVHMuIEZvciBsYXJnZSBpbnNlcnQt b25seSB0YWJsZXMsIGl0IG1heSBiZQpiZW5lZmljaWFsIHRvIGxvd2VyIHRoZSB0YWJsZSdzIGF1 dG92YWN1dW1fZnJlZXplX21pbl9hZ2Ugc28gdGhhdCB0dXBsZXMKYXJlIGVsaWdpYmxlIHRvIGJl IGZyb3plbiBzb29uZXIuIEhlcmUgd2UndmUgb3B0ZWQgbm90IHRvIHplcm8gdGhhdCBmb3IKdGhl c2UgdHlwZXMgb2YgdmFjdXVtcywgc2luY2UgdGhlIHRhYmxlIG1heSBqdXN0IGJlIGluc2VydC1t b3N0bHkgYW5kIHdlCm1heSBvdGhlcndpc2UgZnJlZXplIHR1cGxlcyB0aGF0IGFyZSBzdGlsbCBk ZXN0aW5lZCB0byBiZSB1cGRhdGVkIG9yCnJlbW92ZWQgaW4gdGhlIG5lYXIgZnV0dXJlLgoKVGhl cmUgd2FzIHNvbWUgZGViYXRlIHRvIHdoYXQgZXhhY3RseSB0aGUgbmV3IHNjYWxlIGZhY3RvciBh bmQgdGhyZXNob2xkCnNob3VsZCBkZWZhdWx0IHRvLiBGb3Igbm93LCB0aGVzZSBhcmUgc2V0IHRv IDAuMiBhbmQgMTAwMCwgcmVzcGVjdGl2ZWx5LgpUaGVyZSBtYXkgYmUgc29tZSBtb3RpdmF0aW9u IHRvIGFkanVzdCB0aGVzZSBiZWZvcmUgdGhlIHJlbGVhc2UuCgpBdXRob3I6IExhdXJlbnogQWxi ZSwgRGFyYWZlaSBQcmFsaWFza291c2tpClJldmlld2VkLWJ5OiBBbHZhcm8gSGVycmVyYSwgTWFz YWhpa28gU2F3YWRhLCBDaHJpcyBUcmF2ZXJzLCBBbmRyZXMgRnJldW5kLCBKdXN0aW4gUHJ5emJ5 CkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0FDOFE4dCUyQmozNkdfYkxGJTNEJTJC MGlNbzZqR05XbkxuV2IxdHVqWHVKci0lMkJ4OFpDQ1Rxb1ElNDBtYWlsLmdtYWlsLmNvbQoKQnJh bmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3Fs Lm9yZy9wZy9jb21taXRkaWZmL2IwNzY0MmRiY2Q4ZDVkZTA1ZjBlZTFkYmI3MmRkNjc2MGRkMzA0 MzYKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCmRvYy9zcmMvc2dtbC9jb25maWcuc2dt bCAgICAgICAgICAgICAgICAgICAgICB8IDQzICsrKysrKysrKysrKysrKysrKysrKysrKysrKwpk b2Mvc3JjL3NnbWwvbWFpbnRlbmFuY2Uuc2dtbCAgICAgICAgICAgICAgICAgfCAzNCArKysrKysr KysrKysrKysrLS0tLS0KZG9jL3NyYy9zZ21sL21vbml0b3Jpbmcuc2dtbCAgICAgICAgICAgICAg ICAgIHwgIDUgKysrKwpkb2Mvc3JjL3NnbWwvcmVmL2NyZWF0ZV90YWJsZS5zZ21sICAgICAgICAg ICAgfCAzMCArKysrKysrKysrKysrKysrKysrCnNyYy9iYWNrZW5kL2FjY2Vzcy9jb21tb24vcmVs b3B0aW9ucy5jICAgICAgICB8IDIyICsrKysrKysrKysrKysrCnNyYy9iYWNrZW5kL2NhdGFsb2cv c3lzdGVtX3ZpZXdzLnNxbCAgICAgICAgICB8ICAxICsKc3JjL2JhY2tlbmQvcG9zdG1hc3Rlci9h dXRvdmFjdXVtLmMgICAgICAgICAgIHwgMzEgKysrKysrKysrKysrKysrKy0tLQpzcmMvYmFja2Vu ZC9wb3N0bWFzdGVyL3Bnc3RhdC5jICAgICAgICAgICAgICAgfCAxNiArKysrKysrKysrCnNyYy9i YWNrZW5kL3V0aWxzL2FkdC9wZ3N0YXRmdW5jcy5jICAgICAgICAgICB8IDE2ICsrKysrKysrKysK c3JjL2JhY2tlbmQvdXRpbHMvbWlzYy9ndWMuYyAgICAgICAgICAgICAgICAgIHwgMjAgKysrKysr KysrKysrKwpzcmMvYmFja2VuZC91dGlscy9taXNjL3Bvc3RncmVzcWwuY29uZi5zYW1wbGUgfCAg NSArKysrCnNyYy9iaW4vcHNxbC90YWItY29tcGxldGUuYyAgICAgICAgICAgICAgICAgICB8ICA0 ICsrKwpzcmMvaW5jbHVkZS9jYXRhbG9nL2NhdHZlcnNpb24uaCAgICAgICAgICAgICAgfCAgMiAr LQpzcmMvaW5jbHVkZS9jYXRhbG9nL3BnX3Byb2MuZGF0ICAgICAgICAgICAgICAgfCAgNSArKysr CnNyYy9pbmNsdWRlL3Bnc3RhdC5oICAgICAgICAgICAgICAgICAgICAgICAgICB8ICAxICsKc3Jj L2luY2x1ZGUvcG9zdG1hc3Rlci9hdXRvdmFjdXVtLmggICAgICAgICAgIHwgIDIgKysKc3JjL2lu Y2x1ZGUvdXRpbHMvcmVsLmggICAgICAgICAgICAgICAgICAgICAgIHwgIDIgKysKc3JjL3Rlc3Qv cmVncmVzcy9leHBlY3RlZC9ydWxlcy5vdXQgICAgICAgICAgIHwgIDMgKysKMTggZmlsZXMgY2hh bmdlZCwgMjMwIGluc2VydGlvbnMoKyksIDEyIGRlbGV0aW9ucygtKQoK --===============2714264055872024693==--