Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rDY7B-002MXS-Rf for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Dec 2023 22:54:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rDY79-000yeH-HX for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Dec 2023 22:54:03 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rDY79-000ye9-4Y for pgsql-hackers@lists.postgresql.org; Wed, 13 Dec 2023 22:54:03 +0000 Received: from smtp-fw-80006.amazon.com ([99.78.197.217]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rDY72-00AGRX-7x for pgsql-hackers@postgresql.org; Wed, 13 Dec 2023 22:54:01 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1702508036; x=1734044036; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=0F52AfbrNv4g+duBhTJvUC89U2KUqQtiIPeGkC33Wvo=; b=vqnf0fORKFFnDUNUwWvtBIWEki6NieeK9a4BHzf/Zz4ov4J5x4o2Cbct 5PGC/ii8zFC3Y4/JoIcifOxitFu6NzueDEBbypLuW5apQZSt5UipWFLmH YoV8fxp/AWsPkmyekhFG7r+B/R/3d2686brQhZ0FLKn1/7DTfJf8HkbZv o=; X-IronPort-AV: E=Sophos;i="6.04,274,1695686400"; d="scan'208";a="258910277" Subject: Re: [BUG] autovacuum may skip tables when session_authorization/role is set on database Thread-Topic: [BUG] autovacuum may skip tables when session_authorization/role is set on database Received: from pdx4-co-svc-p1-lb2-vlan3.amazon.com (HELO email-inbound-relay-iad-1e-m6i4x-7dc0ecf1.us-east-1.amazon.com) ([10.25.36.214]) by smtp-border-fw-80006.pdx80.corp.amazon.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 13 Dec 2023 22:53:53 +0000 Received: from smtpout.prod.us-west-2.prod.farcaster.email.amazon.dev (iad7-ws-svc-p70-lb3-vlan2.iad.amazon.com [10.32.235.34]) by email-inbound-relay-iad-1e-m6i4x-7dc0ecf1.us-east-1.amazon.com (Postfix) with ESMTPS id CF7CA807BC; Wed, 13 Dec 2023 22:53:52 +0000 (UTC) Received: from EX19MTAUWC002.ant.amazon.com [10.0.21.151:19579] by smtpin.naws.us-west-2.prod.farcaster.email.amazon.dev [10.0.43.236:2525] with esmtp (Farcaster) id a28e5c9d-912e-4428-8265-6beb21f04100; Wed, 13 Dec 2023 22:53:52 +0000 (UTC) X-Farcaster-Flow-ID: a28e5c9d-912e-4428-8265-6beb21f04100 Received: from EX19D013UWA004.ant.amazon.com (10.13.138.207) by EX19MTAUWC002.ant.amazon.com (10.250.64.143) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1118.40; Wed, 13 Dec 2023 22:53:47 +0000 Received: from EX19D013UWA001.ant.amazon.com (10.13.138.253) by EX19D013UWA004.ant.amazon.com (10.13.138.207) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA) id 15.2.1118.40; Wed, 13 Dec 2023 22:53:47 +0000 Received: from EX19D013UWA001.ant.amazon.com ([fe80::e912:ae5e:9427:9964]) by EX19D013UWA001.ant.amazon.com ([fe80::e912:ae5e:9427:9964%5]) with mapi id 15.02.1118.040; Wed, 13 Dec 2023 22:53:47 +0000 From: "Imseih (AWS), Sami" To: Tom Lane CC: "pgsql-hackers@postgresql.org" Thread-Index: AQHaLgTtd891DnA05Eu2af+wDycJprCnt8MA//+2E4A= Date: Wed, 13 Dec 2023 22:53:47 +0000 Message-ID: References: <4814073F-6387-4873-8B8E-4D6A7390DEC7@amazon.com> <2660032.1702502302@sss.pgh.pa.us> In-Reply-To: <2660032.1702502302@sss.pgh.pa.us> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.106.179.29] Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PiBXaGF0IGlzIHRoZSBhY3R1YWwNCj4gdXNlIGNhc2UgZm9yIHN1Y2ggYSBzZXR0aW5nPyANCg0K SSBkb24ndCBoYXZlIGV4YWN0IGRldGFpbHMgb24gdGhlIHVzZS1jYXNlLCBiaXQgdGhpcyBpcyBu b3QgYSBjb21tb24NCnVzZS1jYXNlLg0KDQo+IERvZXNuJ3QgaXQgcmlzayBzZWN1cml0eSBwcm9i bGVtcz8NCg0KSSBjYW5ub3Qgc2VlIGhvdyBzZXR0aW5nIGl0IG9uIHRoZSBkYXRhYmFzZSBiZWlu ZyBtb3JlIHByb2JsZW1hdGljIHRoYW4NCnNldHRpbmcgaXQgb24gYSBzZXNzaW9uIGxldmVsLg0K DQoNCj4gSSdtIHJhdGhlciB1bmltcHJlc3NlZCBieSB0aGlzIHByb3Bvc2FsLCBmaXJzdCBiZWNh dXNlIHRoZXJlIGFyZQ0KPiBwcm9iYWJseSB0ZW4gb3RoZXIgd2F5cyB0byBicmVhayBhdXRvdmFj IHdpdGggaWxsLWNvbnNpZGVyZWQgc2V0dGluZ3MsDQoNClRoZXJlIGV4aXN0cyBjb2RlIGluIGF1 dG92YWMgdGhhdCBzYWZlZ3VhcmQgZm9yIHN1Y2ggc2V0dGluZ3MuIEZvciBleGFtcGxlLA0Kc3Rh dGVtZW50X3RpbWVvdXQsIGxvY2tfdGltZW91dCBhcmUgZGlzYWJsZWQuIFRoZXJlIGFyZSBhIGRv emVuIG9yDQptb3JlIG90aGVyIHNldHRpbmdzIHRoYXQgYXJlIG92ZXJyaWRkZW4gZm9yIGF1dG92 YWMuDQoNCkkgc2VlIHRoaXMgYmVpbmcganVzdCBhbm90aGVyIG9uZSB0byBlbnN1cmUgdGhhdCBh dXRvdmFjdXVtIGFsd2F5cyBydW5zDQphcyBzdXBlcnVzZXIuDQoNCj4gYW5kIHNlY29uZCBiZWNh dXNlIGlmIHdlIGRvIHdhbnQgdG8gY29uc2lkZXIgdGhpcyBhIHN1cHBvcnRlZCBjYXNlLA0KPiB3 aGF0IGFib3V0IG90aGVyIGJhY2tncm91bmQgcHJvY2Vzc2VzPyBUaGV5J2QgbGlrZWx5IGhhdmUg aXNzdWVzDQo+IGFzIHdlbGwuDQoNCkkgaGF2ZSBub3QgY29uc2lkZXJlZCBvdGhlciBiYWNrZ3Jv dW5kIHByb2Nlc3NlcywgYnV0IGF1dG92YWMgaXMgdGhlIG9ubHkNCm9uZSB0aGF0IEkgY2FuIHRo aW5rIG9mIHdoaWNoIGNoZWNrcyBmb3IgcmVsYXRpb24gcGVybWlzc2lvbnMuDQoNClJlZ2FyZHMs DQoNClNhbWkNCg0KDQoNCg0KDQoNCg==