Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lGhfb-0002bc-06 for pgsql-bugs@arkaria.postgresql.org; Mon, 01 Mar 2021 12:29:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lGhfZ-0008L5-Up for pgsql-bugs@arkaria.postgresql.org; Mon, 01 Mar 2021 12:29:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lGhT7-0003Lt-KF for pgsql-bugs@lists.postgresql.org; Mon, 01 Mar 2021 12:16:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lGhT3-00053f-5G for pgsql-bugs@lists.postgresql.org; Mon, 01 Mar 2021 12:16:09 +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=2YiXO/jWkzAevGvj7b6fSACz+DzMBVs/QWjBKe1/jsY=; b=qI2kauyubtD5ZsUl3929zUrXzO 9fkTIMt3Fr/xd1eHUCHglSNYUFajgz2Omv5ezMSEi0q4DiLp5DdmJvs6CtauAfY3gLZkpzDvDNdCU 1mfbLYfywdF4g89Rh+BUjSeDz2uOXYJQDioz/52AoiCrfQ6D+TxAPqNYvSu82B+zsPIecZeYXWmyt /7ReLdjtMbq9U4ACZ9HFSPEU/YeoYICk+DesNeYWfpFUxu8NZmuCpfVHK0gEMvz23fAPhLBmJavrW W8pc3V/NnjsK93A1ji5fKEB17ZoW9jyCcDUsERuFO4zAA0bx2dxLwBQ4i39JWl5Yv1AOZ6+rdLnDs xcqE1bzg==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lGhT1-0000Ja-Td for pgsql-bugs@lists.postgresql.org; Mon, 01 Mar 2021 12:16:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lGhT0-0006oM-Kd for pgsql-bugs@lists.postgresql.org; Mon, 01 Mar 2021 12:16:02 +0000 Content-Type: multipart/mixed; boundary="===============3509237856393698790==" MIME-Version: 1.0 Subject: BUG #16907: Performance issue after big table drop and recreate To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: namdevrahul@gmail.com Reply-To: namdevrahul@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 01 Mar 2021 12:15:41 +0000 Message-ID: <16907-5d18e09e080a1bba@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============3509237856393698790== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjkwNwpMb2dnZWQgYnk6ICAgICAgICAgIFJhaHVsIE5hbWRlbwpFbWFp bCBhZGRyZXNzOiAgICAgIG5hbWRldnJhaHVsQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDEwLjE1Ck9wZXJhdGluZyBzeXN0ZW06ICAgTkFNRT0mcXVvdDtVYnVudHUmcXVvdDsgVkVSU0lP Tj0mcXVvdDsxOC4wNC4zIExUUyAoQmlvbmljIEJlYXZlcikKRGVzY3JpcHRpb246ICAgICAgICAK CjEuIFRvb2sgcGdfZHVtcCBvZiA1ODAgR0IgdGFibGUgd2l0aCBubyBkYXRhLg0KMi4gUmVuYW1l IHRoZSBvcmlnaW5hbCB0YWJsZSB0byBUQUJMRTFfb3JpZ2luYWwNCjMuIERyb3BwZWQgdGhlIGZp dmUgaW5kZXhlcyBhcHByb3ggMS4yIFRCIG9uIHRoaXMgdGFibGUuDQo0LiBEaWQgYSBwZ19yZXN0 b3JlIGZyb20gdGhlIGJhY2t1cCB0YWtlbi4gDQo1LiBDcmVhdGVkIHRoZSBpbmRleGVzIC8gY29u c3RyYWludHMgYW5kIHByb3ZpZGVkIGFsbCB0aGUgZ3JhbnRzIGFzCnJlcXVpcmVkLiANCjYgUnVu IHRoZSBBcHBsaWNhdGlvbiBwcm9jZXNzIGZvciByZXBvcnQgZ2VuZXJhdGlvbi4gSXQgdG9vayAy NSBtaW5zIGZvcgpzaW5nbGUgZGF5IHJlcG9ydCB3aGljaCB3YXMgZXhwZWN0ZWQgYmVoYXZpb3Iu IA0KNy4gSG93ZXZlciBhZnRlciAzLTQgZGF5cyBydW4gdGhlIHBlcmZvcm1hbmNlIHdhcyBkZWdy YWRlZCBhbmQgdGhlIHNhbWUKcmVwb3J0IG5vdyB0YWtlcyAyLjUgSG91cnMuIA0KDQpBbnkgaGVs cCB3aWxsIGJlIGFwcHJlY2lhdGVkLiBLaW5kbHkgc3VwcG9ydC4gDQoNCk5PVEU6IHRoZSBFbnZp cm9ubWVudCBpcyBvbiBBV1MgQ2xvdWQgU2VydmVyIGlzIE01LjR4TGFyZ2UgKDE2IENvcmUgNjEg R0IpCgo= --===============3509237856393698790==--