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 1s4g1b-000DSu-5M for pgsql-admin@arkaria.postgresql.org; Wed, 08 May 2024 12:03:55 +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 1s4g0a-000M79-B6 for pgsql-admin@arkaria.postgresql.org; Wed, 08 May 2024 12:02:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s4g0Z-000M71-RR for pgsql-admin@lists.postgresql.org; Wed, 08 May 2024 12:02:52 +0000 Received: from mout.gmx.net ([212.227.15.15]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s4g0U-0001Gq-Gq for pgsql-admin@lists.postgresql.org; Wed, 08 May 2024 12:02:51 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1715169765; x=1715774565; i=shammat@gmx.net; bh=dh4I+LCOdU5DsUtwVTa1t5eISw0tSy5/vxUfTRTXoLM=; h=X-UI-Sender-Class:Message-ID:Date:MIME-Version:Subject:To: References:From:In-Reply-To:Content-Type: Content-Transfer-Encoding:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=TYDR7/EZnrSf/dp0/QRg+tJ+834M755rj1Q11Qq1wQ85FRa//dm+riMQP8Uz75Eq PinKQQ8YKDdckPQ9UtKCHfrMRNeFyPuRgNnL6Ch1qebL0k7xPZp7H+j9k6ZOKZWMp 9rWm37b3kP0Jsd8Ti76MhtQdfAcaca+kaHYAJrNZKZKQ/lejfSmen25jyec05PJbE OnHzyllUom5HHhJkfZFCRgwLBxnkMjxyTt2dqcYKYxTrJCXHGZ3iP1T5Rj6xOAxzE BFZZd52dRqDt/kIy2uJmZVcilE32unz7CaiAff78pCevI4nGpB2zA/A4TpQIen4o+ 8bRXYCwtdAifijhKow== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.8.0.152] ([185.40.248.10]) by mail.gmx.net (mrgmx005 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MdvqW-1seZFr2mWM-00b18o for ; Wed, 08 May 2024 14:02:45 +0200 Message-ID: <8f36cff9-78aa-4e72-ab22-093a889a926d@gmx.net> Date: Wed, 8 May 2024 14:02:45 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Maintenance To: pgsql-admin@lists.postgresql.org References: Content-Language: de-DE, en-US From: Thomas Kellerer In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:lY6mOQhM9W2LP48/I2fB+AggQIPv6gUShu+tulpOyxcebsJFKYy VpFGJUpL0jAgIo97MyJDCnEumge+ZhdmFl/7AQxE3iXQdJ3iMMD/lbyc+2Gbr0HceUgmjfG cdpsAEQQDjH8ZE0TRy0yazykuIUtPoiFJWIiOAUaPVYxYbrs2Ie3TQftfGiozY1ePqwGvBb 05GcYbnI1VR0S7Edvaupw== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:HhV2errbQjM=;nmOfLeifZzcBIldAyBe30oira/5 duSGPcYCqKBVfkgPZeEPzAfc6bqCfhe9JZp3F3htCWzL9rDn+BFCGhaCUYtfsnY13RxKw3Iyi yP4p0lE9IB6orEHOeyfgv1SPrKL9LH0mInnMf0SvtVNg1TuX89VVA+i9JLjw+XesmH/CHD+HB FDLmVOlbmY5/KAVDZy+0zeuYfXLy9QduAuWFWxtWCho1L9rVsfkwHLaHwgWi6Do7yGmCoZut8 Ic31L619hUwEzit6JP3BYnhUCVMzXitLF5h4ZLegwsBeI2TOoTGDh/9nrXZJ/VQRbauLmsHgk To3kvBkvT2aCqRq3pScln7MzK9/4H98qiHUYiM3dellie3Mw8CJq6evgzdMJlh6eA5LmlR3oB +IKaxbTuir5SOqi38BQvWwVX3mmybsLs1q2N8rSLzuKMM4t1j6EHLb12Tsxvd4otSFjIvJeAe T+5shZggSQCfzejL63E/5+SENDqC/dcj4KxHe05tZa/J+oOCJl7AK2mn49rJPOnVna4+OsnMv 2ZFxYZVLavK5DhSGSrlsXNro7gK/M6Ei9TPkzY2n+jBXkt3KssOV+l7WCyAQWI50Seg7zsCHN WSOckUgBRqcg0hpFb/QjrpKG45thUJa6xcoxDc+5ytWTUzgaQk23w+Mnp75vxHna9Ya2XvqEj UE8U36X1ng9pu7XAsoyDXwD3RUN/m4zPW3fW2KlfNyS9AKsdLIYdlq6Gwi/ntusdhBqmOYWo3 8Sgjz/vQqOEnv5pnBw5gb/0IIFPKLy+w0TmrFE8I/RXzsfjui6Mhh4PZwZxGrX1/fH70iu6Fs PqDijQyaCSlLXHN+J6crbnunh2EaaZkjZ+1mXQApOYkaM= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Sunil Jadhav schrieb am 08.05.2024 um 11:17: > We have a 12TB db and one table having around 7 TB data , is there > any option we can removed the dead tuple and size also increase for > that partition without downtime . Vaccum full we can't do because of > exclusive lock in tables during processing. > > We have critical application so don't get the downtown so how to > achieve this please let us know Have a look at pg_squeeze or pg_repack but both will create a copy of the = table, so if you don't have enough free disk space neither is an option. You probably also want to investigate if making autovacuum more aggressive helps Did you validate that those dead tuples you see really are a problem and are not re-used?