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 1pcnXb-0007km-Q3 for pgsql-general@arkaria.postgresql.org; Thu, 16 Mar 2023 13:21:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pcnXa-0006Vy-By for pgsql-general@arkaria.postgresql.org; Thu, 16 Mar 2023 13:21:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pcnXZ-0006Vo-ON for pgsql-general@lists.postgresql.org; Thu, 16 Mar 2023 13:21:10 +0000 Received: from mailfo02.lmco.com ([192.35.35.12]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pcnXT-0001f8-Pn for pgsql-general@lists.postgresql.org; Thu, 16 Mar 2023 13:21:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=lmco.com; h=from : to : subject : date : message-id : references : in-reply-to : content-type : content-transfer-encoding : mime-version; s=corpgw220615; bh=VTk6UkOgco5s5sF9SSHHySdO5ESW9jtx8Kd68pBjcNQ=; b=SuIV9J/JVAqt/+dDZx1ISZzKT1L3NhhrzcetFEgKBHYFWfoOWh7nDxtHoH9fprVjlYDo YIclUvFJgOynTUvwCMtF0kh3APVv07zKtETh+lsXCVRl7e8l68Stgt3YoqlYn5IscKnD sfJP9DUiAdSlQ/ryIZm8jtZprFkVVAKN+IRW3Z4AcLreu1/6MKTC3syopWCksAVQ2f/B DDl98PuNwHcWU1H2U+2fU9HWdiRw+lo3dMMhOwtHk70PsqyyMEfzaW6smWXGrkPj0cEO bbWZfeUnCNOTyippzAH4VyhqKNi/UzcAnICT0B1MIVpSRummq5lLQlM8whNz3BJnojWl Dw== Received: from lmxpdend09w06.us.lmco.com (lmxpdend09w06.ems.lmco.com [172.23.20.61]) by mailfo02.lmco.com (8.16.0.42/8.16.0.42) with ESMTP id 32GDKwrs086884; Thu, 16 Mar 2023 13:20:58 GMT Received: from lmxpdend09w04.us.lmco.com (172.23.20.59) by lmxpdend09w06.us.lmco.com (172.23.20.61) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P256) id 15.1.2308.27; Thu, 16 Mar 2023 07:20:57 -0600 Received: from lmxpdend09w04.us.lmco.com ([172.23.20.59]) by lmxpdend09w04.us.lmco.com ([172.23.20.59]) with mapi id 15.01.2308.027; Thu, 16 Mar 2023 07:20:57 -0600 From: "Dolan, Sean" To: Laurenz Albe , "pgsql-general@lists.postgresql.org" Subject: RE: EXTERNAL: Re: "No Free extents", table using all allocated space but no rows! Thread-Topic: EXTERNAL: Re: "No Free extents", table using all allocated space but no rows! Thread-Index: AdlXqoMc6GppTpkMSYGlXxQf6GrBDwAUkhIAAAMot0A= Date: Thu, 16 Mar 2023 13:20:57 +0000 Message-ID: <6eec8fc3dfa743ff9b19d8ce0e87763d@lmco.com> References: <0eda9b7d13e34cc786d30c602510f3e4@lmco.com> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [172.23.20.7] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Proofpoint-GUID: 6_GvXKLlvvGYEShwcGcmuOjHa-NgrJz3 X-Proofpoint-ORIG-GUID: 6_GvXKLlvvGYEShwcGcmuOjHa-NgrJz3 X-LM-Outbound: External 172.23.20.61 cntry=** g=6_GvXKLlvvGYEShwcGcmuOjHa-NgrJz3 q=32GDKwrs086884 m=1 X-LM-OBSENDER: sean.dolan@lmco.com X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10434:6.0.573,18.0.942 definitions=2023-03-16_08:2023-03-16,2023-03-16 signatures=0 X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 spamscore=0 suspectscore=0 mlxlogscore=900 mlxscore=0 phishscore=0 adultscore=0 malwarescore=0 bulkscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.12.0-2303150002 definitions=main-2303160109 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SSBtZXNzZWQgdXAgYW5kIGNvbmZ1c2VkIGlzc3Vlcy4gICBUaGUgZXJyb3IgaXMgOiAgDQpFUlJP UjogQ291bGQgbm90IGV4dGVuZCBwZ190YmxzcGMvMTY1NTUvUEdfMTNfMjAyMDAveHh4eC94eHh4 ICBObyBzcGFjZSBsZWZ0IG9uIGRldmljZQ0KSElOVDogQ2hlY2sgZnJlZSBkaXNrIHNwYWNlDQoN ClNvIHRoZSBzY2hlbWEgaXMgImZ1bGwiIGFuZCB0aGUgb2ZmZW5kZXIgaXMgdGhpcyBvbmUgdGFi bGUuICAgSSBjYW4ndCBUUlVOQ0FURSBhcyB0aGVyZSBuZWVkcyB0byBiZSBzcGFjZSB0byBwZXJm b3JtIHRoZSBhY3Rpb24uICAgSXMgdGhlcmUgYSB3YXkgdG8gc2VlIGlmIHRoZXJlIGlzIGEgdHJh bnNhY3Rpb24gb24gdGhhdCB0YWJsZSBsaWtlIHlvdSBhbGx1ZGUgdG8/DQoNCi0tLS0tT3JpZ2lu YWwgTWVzc2FnZS0tLS0tDQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRl Yy5hdD4gDQpTZW50OiBXZWRuZXNkYXksIE1hcmNoIDE1LCAyMDIzIDExOjQ1IFBNDQpUbzogRG9s YW4sIFNlYW4gKFVTIE4tSVNZUyBUZWNobm9sb2dpZXMgSW5jLikgPHNlYW4uZG9sYW5AbG1jby5j b20+OyBwZ3NxbC1nZW5lcmFsQGxpc3RzLnBvc3RncmVzcWwub3JnDQpTdWJqZWN0OiBFWFRFUk5B TDogUmU6ICJObyBGcmVlIGV4dGVudHMiLCB0YWJsZSB1c2luZyBhbGwgYWxsb2NhdGVkIHNwYWNl IGJ1dCBubyByb3dzIQ0KDQpPbiBUaHUsIDIwMjMtMDMtMTYgYXQgMDE6NTggKzAwMDAsIERvbGFu LCBTZWFuIHdyb3RlOg0KPiBFbnZpcm9ubWVudDogUG9zdEdyZXMgMTMgb24gUmVkSGF0IDcuOS4N Cj4gwqANCj4gSSBhbSB1c2luZyBsb2dpY2FsIHJlcGxpY2F0aW9uIChwdWJsaXNoZXIvc3Vic2Ny aWJlcikgYmV0d2VlbiB0d28gDQo+IGRhdGFiYXNlcyBhbmQgdGhlcmUgYXJlIHRpbWVzIHdoZXJl IG9uZSBvZiBvdXIgc2NoZW1hcyBnZXRzIHRvIDEwMCUgb2YgYWxsb2NhdGVkIHNwYWNlIChObyBG cmVlIEV4dGVudHMpLg0KPiBJIHdlbnQgaW50byB0aGUgc2NoZW1hIGFuZCBkaWQgYSBcZHQrIHRv IHNlZSB0aGUgYW1vdW50IG9mIHNpemUgYmVpbmcgDQo+IHVzZWQgYW5kIEkgY291bGQgc2VlIG9u ZSBvZiB0aGUgdGFibGVzIHNvbWVob3cgc2hvd3MgMTZHQiwgZXNzZW50aWFsbHkgdGhlIGFtb3Vu dCBvZiBhbGxvY2F0ZWQgc2l6ZS4NCj4gV2FudGluZyB0byBzZWUgd2hhdCBpcyBpbiB0aGF0IHRh YmxlLCBJIGRpZCBhIHNpbXBsZSBzZWxlY3QgKiBmcm9tIHRoZSANCj4gdGFibGUgYW5kIGl0IHJl dHVybnMgbm8gcm93cy7CoCBEb2luZyBhIGNvdW50KCopIGFsc28gcmV0dXJucyAwIHJvd3MuDQo+ IMKgDQo+IEhvdyBjYW4gdGhlIHRhYmxlIGJlIHVzaW5nIGFsbCB0aGF0IHNwYWNlIGJ1dCB0aGVy ZSBpcyBub3RoaW5nIOKAnGlu4oCdIHRoZSB0YWJsZT8NCj4gSSBkb27igJl0IGNhcmUgYWJvdXQg dGhlIGRhdGEgKGFzIEkgYW0gdGVzdGluZykgc28gSSBjYW4gZHJvcCBhbmQgcmVjcmVhdGUgdGhh dCBvbmUgdGFibGUuDQo+IFxkdCsgd291bGQgdGhlbiBzaG93IDAgYnl0ZXMuwqDCoMKgIExhdGVy LCBJIHdpbGwgdGhlbiBjcmVhdGUgYSANCj4gc3Vic2NyaXB0aW9uIGFuZCB0aGVuIEkgd2lsbCBn ZXQgYSBObyBGcmVlIEV4dGVudHMgZXJyb3IgYWdhaW4gYW5kIGFnYWluIHRoZSB0YWJsZSBoYXMg ZmlsbGVkIHVwLg0KPiDCoA0KPiBXaGF0IGNhbiBJIGxvb2sgZm9yPw0KDQpJIGRvbid0IHRoaW5r IHRoYXQgdGhlcmUgaXMgYW4gZXJyb3IgbWVzc2FnZSAibm8gZnJlZSBleHRlbnRzIi4NCg0KSXQg Y2FuIGVhc2lseSBoYXBwZW4gdGhhdCBhIHRhYmxlIGlzIGxhcmdlLCBidXQgU0VMRUNUIGNvdW50 KCopIHJldHVybnMgMC4NClRoYXQgd291bGQgbWVhbiB0aGF0IGVpdGhlciB0aGUgdGFibGUgaXMg ZW1wdHkgYW5kIFZBQ1VVTSB0cnVuY2F0aW9uIGRpZG4ndCB3b3JrLCBvciB0aGF0IHRoZSB0YWJs ZSBjb250YWlucyB0dXBsZXMgdGhhdCBhcmUgbm90IHZpc2libGUgdG8geW91ciB1c2VyLCBlaXRo ZXIgYmVjYXVzZSBWQUNVVU0gZGlkbid0IHByb2Nlc3MgdGhlIHRhYmxlIHlldCwgb3IgYmVjYXVz ZSB5b3VyIHNuYXBzaG90IGlzIHRvbyBvbGQgdG8gc2VlIHRoZSBkYXRhLCBvciBiZWNhdXNlIHRo ZSB0cmFuc2FjdGlvbiB0aGF0IGNyZWF0ZWQgdGhlIHJvd3MgaXMgc3RpbGwgb3Blbi4NCg0KSWYg eW91IGRvbid0IGNhcmUgYWJvdXQgdGhlIGRhdGEsIHlvdXIgZWFzaWVzdCBvcHRpb24gaXMgdG8g VFJVTkNBVEUgdGhlIHRhYmxlLg0KSWYgVFJVTkNBVEUgaXMgYmxvY2tlZCwga2lsbCBhbGwgdHJh bnNhY3Rpb25zIHRoYXQgYmxvY2sgaXQuDQoNCllvdXJzLA0KTGF1cmVueiBBbGJlDQo=