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 1tT4ZA-003DpY-Le for pgsql-bugs@arkaria.postgresql.org; Wed, 01 Jan 2025 19:39:41 +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 1tT4Z8-009ry9-3M for pgsql-bugs@arkaria.postgresql.org; Wed, 01 Jan 2025 19:39:37 +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 1tT3yq-009lxb-HP for pgsql-bugs@lists.postgresql.org; Wed, 01 Jan 2025 19:02:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tT3yo-001b5J-04 for pgsql-bugs@lists.postgresql.org; Wed, 01 Jan 2025 19:02:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=M1V162WMQTKJCNTJmxs/H0u5dcopFrdbdTfTQCyFyWk=; b=a58olkAQI0z2Bt0WFNBf6wSH8y pplpnokIXmoBeGZscdpIVIailziNgq618FQv6VQLCdEUgsArcmjsXqxMRfiM1lb6P/vxA9wXpPXRP QDT1C0QTMK2741b/qa0Ry25nFiNh+u+e9IYOdJGaUVn6RyA2TV6olWSJVTf0lzQmuRBzkbVsaG7zH pw/Z0KbZ5SmqKvMUnJK/HBIhmWJV8IzgL2fM7RZv7F1mAvG0WmWiRN3A3k7c7GwgpwzdRsXfkE6FD ZpswYTmxa1cxoiX+Pd7C96lj/Zt3/e/zgYoi+7kQpdt+f/SciarU0epBMFqxTci4Cn4n8+zI/kgiy NXm7nhXw==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tT3ym-0083DV-Nx for pgsql-bugs@lists.postgresql.org; Wed, 01 Jan 2025 19:02:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tT3yk-00BLBj-Bk for pgsql-bugs@lists.postgresql.org; Wed, 01 Jan 2025 19:02:03 +0000 Content-Type: multipart/mixed; boundary="===============8639455648310003330==" MIME-Version: 1.0 Subject: BUG #18762: Update script produces distinct outputs before and after vacuum analyze operation To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: siva.thalaimalai@chainsys.com Reply-To: siva.thalaimalai@chainsys.com, pgsql-bugs@lists.postgresql.org Date: Wed, 01 Jan 2025 19:01:15 +0000 Message-ID: <18762-bffaeede91978f52@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8639455648310003330== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODc2MgpMb2dnZWQgYnk6ICAgICAgICAgIFNpdmEgVGhhbGFpbWFsYWkK RW1haWwgYWRkcmVzczogICAgICBzaXZhLnRoYWxhaW1hbGFpQGNoYWluc3lzLmNvbQpQb3N0Z3Jl U1FMIHZlcnNpb246IDEzLjE1Ck9wZXJhdGluZyBzeXN0ZW06ICAgT3JhY2xlIFNRTApEZXNjcmlw dGlvbjogICAgICAgIAoKSXNzdWUgUmVwb3J0OiBGb3IgYSBzYW1lIHVwZGF0ZSBzY3JpcHQgcHJv ZHVjZXMgZGlzdGluY3Qgb3V0cHV0cyBiZWZvcmUgYW5kCmFmdGVyIHZhY3V1bSBhbmFseXplIG9w ZXJhdGlvbi4NCg0KU1FMIFN0YXRlbWVudCAtIFVQREFURSBzdGd0YmxfODM3NDY1cjQgU1RHVEJM IFNFVCBBVFRSXzcgPQpQVlFVRVJZLmJhdGNoX251bWJlciwgQVRUUl8xID0gUFZRVUVSWS5iYXRj aF9udW1iZXIgLCBURl8xID0nUycgRlJPTSAoU0VMRUNUCkNBU1QoQkFUQ0hfU0VRIEFTIE5VTUVS SUMpIEFTIEJBVENIX05VTUJFUiwgQ0FTVChCQVRDSF9TRVEgQVMgVkFSQ0hBUig1MCkpCkFTIEJB VENILCBCQVRDSF9URVhUIEZST00gKCBTRUxFQ1QgTkVYVFZBTCgnc2FtcGxlX3NlcXVlbmNlX18y ODk5JykgQVMKQkFUQ0hfU0VRLCAgJ0EnIEFTIEJBVENIX1RFWFQNCkZST00gdGVzdF9hY3QgKSBB KSBQVlFVRVJZIFdIRVJFIFBWUVVFUlkuYmF0Y2hfdGV4dCBJUyBOT1QgTlVMTCBhbmQKU1RHVEJM LkV4ZWN1dGlvbl9pZCA9IDA7DQoNCkJlZm9yZSBleGVjdXRpbmcgdGhlIFZhY3V1bSBBbmFseXpl IG9wZXJhdGlvbiBvbiB0aGUgdGFyZ2V0IHRhYmxlLCB0aGUKb3V0cHV0IG9mIHRoZSB1cGRhdGUg c3RhdGVtZW50IChhc3N1bWluZyB0aGUgdGFyZ2V0IHRhYmxlIGNvbnRhaW5zIDMgcm93cywKYWxs IG9mIHdoaWNoIHNhdGlzZnkgdGhlIFdIRVJFIGNvbmRpdGlvbikgcmVzdWx0cyBpbiBkaWZmZXJl bnQgc2VxdWVuY2UKbnVtYmVycyAoZS5nLiwgMSwgMiwgMywgLi4uLCBuKSBiZWluZyBnZW5lcmF0 ZWQgYW5kIHVwZGF0ZWQgZm9yIGVhY2ggcmVjb3JkCmluIHRoZSB0YXJnZXQgdGFibGUuDQoNClF1 ZXJ5IEV4ZWN1dGlvbiBQbGFuIGV4ZWN1dGluZyBWYWN1dW0gQW5hbHl6ZSBPcGVyYXRpb24gb24g dGhlIHRhcmdldAp0YWJsZQ0KVXBkYXRlIG9uIHN0Z3RibF8yNzk4Nzc4IHN0Z3RibCAgKGNvc3Q9 MC4wMC4uNzguNTUgcm93cz0xMzYwIHdpZHRoPTEyMTYpCihhY3R1YWwgdGltZT0wLjE3Mi4uMC4x NzQgcm93cz0wIGxvb3BzPTEpDQogIC0+ICBOZXN0ZWQgTG9vcCAgKGNvc3Q9MC4wMC4uNzguNTUg cm93cz0xMzYwIHdpZHRoPTEyMTYpIChhY3R1YWwKdGltZT0wLjA5Ny4uMC4xMjUgcm93cz0zIGxv b3BzPTEpDQogICAgLT4gIFNlcSBTY2FuIG9uIHN0Z3RibF8yNzk4Nzc4IHN0Z3RibCAgKGNvc3Q9 MC4wMC4uMTAuNzUgcm93cz0xCndpZHRoPTExNjgpIChhY3R1YWwgdGltZT0wLjAzNi4uMC4wNDAg cm93cz0zIGxvb3BzPTEpDQogICAgICAgIEZpbHRlcjogKGV4ZWN1dGlvbl9pZCA9IDEwMTU5Mzkp DQogICAgLT4gIFN1YnF1ZXJ5IFNjYW4gb24gYSAgKGNvc3Q9MC4wMC4uNDAuNjAgcm93cz0xMzYw IHdpZHRoPTQwKSAoYWN0dWFsCnRpbWU9MC4wMTkuLjAuMDIwIHJvd3M9MSBsb29wcz0zKQ0KICAg ICAgICAtPiAgU2VxIFNjYW4gb24gdGVzdF9hY3QgIChjb3N0PTAuMDAuLjI3LjAwIHJvd3M9MTM2 MCB3aWR0aD00MCkKKGFjdHVhbCB0aW1lPTAuMDE1Li4wLjAxNSByb3dzPTEgbG9vcHM9MykNClBs YW5uaW5nIFRpbWU6IDAuMzEwIG1zIA0KRXhlY3V0aW9uIFRpbWU6IDAuMzczIG1zDQoNCkFmdGVy IGV4ZWN1dGluZyB0aGUgVmFjdXVtIEFuYWx5emUgb3BlcmF0aW9uIG9uIHRoZSB0YXJnZXQgdGFi bGUKKHN0Z3RibF8yNzk4Nzc4KSwgdGhlIHVwZGF0ZSBzdGF0ZW1lbnQgcHJvZHVjZWQgdGhlIHNh bWUgc2VxdWVuY2UgbnVtYmVyIGZvcgphbGwgcmVjb3JkcyAoZS5nLiwgYWxsIHJlY29yZHMgd2Vy ZSB1cGRhdGVkIHdpdGggYSBzZXF1ZW5jZSB2YWx1ZSBvZiA0KS4NCg0KUXVlcnkgUGxhbiBBZnRl ciBWYWN1dW06DQoNClVwZGF0ZSBvbiBzdGd0YmxfMjc5ODc3OCBzdGd0YmwgIChjb3N0PTAuMDAu LjEzMy40NSByb3dzPTQwODAgd2lkdGg9MTIxNikKKGFjdHVhbCB0aW1lPTAuMTQzLi4wLjE0NCBy b3dzPTAgbG9vcHM9MSkNCiAgLT4gIE5lc3RlZCBMb29wICAoY29zdD0wLjAwLi4xMzMuNDUgcm93 cz00MDgwIHdpZHRoPTEyMTYpIChhY3R1YWwKdGltZT0wLjA4Ny4uMC4wOTMgcm93cz0zIGxvb3Bz PTEpDQogICAgLT4gIFN1YnF1ZXJ5IFNjYW4gb24gYSAgKGNvc3Q9MC4wMC4uNDAuNjAgcm93cz0x MzYwIHdpZHRoPTQwKSAoYWN0dWFsCnRpbWU9MC4wNTIuLjAuMDUzIHJvd3M9MSBsb29wcz0xKQ0K ICAgICAgICAtPiAgU2VxIFNjYW4gb24gdGVzdF9hY3QgIChjb3N0PTAuMDAuLjI3LjAwIHJvd3M9 MTM2MCB3aWR0aD00MCkKKGFjdHVhbCB0aW1lPTAuMDQwLi4wLjA0MCByb3dzPTEgbG9vcHM9MSkN CiAgICAtPiAgTWF0ZXJpYWxpemUgIChjb3N0PTAuMDAuLjEuMDUgcm93cz0zIHdpZHRoPTExNjgp IChhY3R1YWwKdGltZT0wLjAzMC4uMC4wMzMgcm93cz0zIGxvb3BzPTEpDQogICAgLT4gIFNlcSBT Y2FuIG9uIHN0Z3RibF8yNzk4Nzc4IHN0Z3RibCAgKGNvc3Q9MC4wMC4uMS4wNCByb3dzPTMKd2lk dGg9MTE2OCkgDQoJKGFjdHVhbCB0aW1lPTAuMDI3Li4wLjAyOCByb3dzPTMgbG9vcHM9MSkNCiAg ICAgICAgRmlsdGVyOiAoZXhlY3V0aW9uX2lkID0gMTAxNTkzOSkNClBsYW5uaW5nIFRpbWU6IDAu MTg3IG1zDQpFeGVjdXRpb24gVGltZTogMC4yMTcgbXMNCg0KU3RlcHMgdG8gcmVwcm9kdWNlOg0K UnVuIHRoZSBVUERBVEUgcXVlcnkgYXMgc3RhdGVkIGFib3ZlLg0KT2JzZXJ2ZSB0aGUgc2VxdWVu Y2UgdmFsdWVzIHJldHVybmVkIGZvciBlYWNoIHJlY29yZCBiZWZvcmUgVkFDVVVNIEFOQUxZWkUK aXMgZXhlY3V0ZWQuDQpSdW4gdGhlIFZBQ1VVTSBBTkFMWVpFIG9wZXJhdGlvbiBvbiB0aGUgdGFi bGUgc3RndGJsXzgzNzQ2NXI0Lg0KUmUtcnVuIHRoZSBzYW1lIFVQREFURSBxdWVyeS4NCk9ic2Vy dmUgdGhhdCB0aGUgc2VxdWVuY2UgcmV0dXJucyB0aGUgc2FtZSB2YWx1ZSAoZS5nLiwgNCkgZm9y IGFsbCB1cGRhdGVkCnJlY29yZHMuDQoNCktpbmRseSByZXZpZXcgdGhlIHNjZW5hcmlvIGFuZCBX aGF0IGNvdWxkIGNhdXNlIGRpc2NyZXBhbmNpZXMgaW4gdGhlIHJlc3VsdHMKZm9yIHRoZSBzYW1l IHVwZGF0ZSBzY3JpcHQ/IEFkZGl0aW9uYWxseSwgd2hhdCBhY3Rpb25zIHNob3VsZCBiZSB0YWtl biBpZgp0aGUgc2NyaXB0IHlpZWxkcyBpZGVudGljYWwgb3V0cHV0cyBpbiBib3RoIHNjZW5hcmlv cyAod2l0aCBhbmQgd2l0aG91dCB0aGUKVmFjdXVtIEFuYWx5emUgb3BlcmF0aW9uKT8gSXMgdGhl cmUgYW55IG9wdGlvbiB0byBoYXZlIHRoZSBzYW1lIHF1ZXJ5CnBsYW5uZXIgZm9yIGJvdGggdGhl IHNjZW5hcmlvcz8KCg== --===============8639455648310003330==--