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 1ti7K6-00BZZ7-Nf for pgsql-admin@arkaria.postgresql.org; Wed, 12 Feb 2025 07:38:18 +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 1ti7K4-006F31-Q7 for pgsql-admin@arkaria.postgresql.org; Wed, 12 Feb 2025 07:38:17 +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 1ti7K4-006F2s-CR for pgsql-admin@lists.postgresql.org; Wed, 12 Feb 2025 07:38:17 +0000 Received: from mout.gmx.net ([212.227.17.20]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1ti7K2-000P2P-2z for pgsql-admin@lists.postgresql.org; Wed, 12 Feb 2025 07:38:16 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1739345894; x=1739950694; i=shammat@gmx.net; bh=M1cE46OruU1s+rOYHh/O7/JazlpMxK/E7jxxKu05QSA=; 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=qXi7O97ajIPramuojQO0P5sAq+AoNpsQHILkYtQJnX+5CXkN98neVqkwj6yjSfZm mMsbqJ0iUf8E6lzoEFtV0gptj1/A5sVaCNpN5ISkaAhH5j/5Q0NgCQhhmvqNdgk/L 69nzZ8beCea7VDisNQS1BPQlFny6VIhINfaJxx3DmnfAa8VGY44ugnvaHD+IAzc+v kMblb5MZGbrxydSgtVzZKOl5esEBYo9e+Fy6PZy0EXcx9APERwF9PKsypzG2iCCNV mcmyc2PlaNHCGpT8MFF5dmkkuHKImGHKvQ/Clcb5EChEAL8lhtMRMbO74fn33ZYx3 a5ZN60wXZNU0U8401Q== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.8.0.17] ([185.40.248.10]) by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1M2f9b-1tfcss3htf-00BIof for ; Wed, 12 Feb 2025 08:38:13 +0100 Message-ID: <2f93346f-645f-46a0-9cad-c913537b5eed@gmx.net> Date: Wed, 12 Feb 2025 08:38:13 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Table size is constantly growing and causing performance problems To: pgsql-admin@lists.postgresql.org References: Content-Language: de-DE From: shammat@gmx.net In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:DhUEXsNTVdWEZ994AM9Qlc0SUbP6ZXjQfre5BGb+X5doyr8K6Hv Lrkp156KBWd58n/idtk+Xb/U/1wR8SR/KaCWESyYPF9Ynd7sONk/2hayUDgtI8ZzVp4lCHR eM8jD+C5zr0K4Tmaoo4YonBL32rfAdSbdp3Ddro24uFCEJyXeLZVCyyEoUJCQSVuK18JRf4 ev23gDE6BjIkh0fBZ2r5A== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:H8QPNrdZg9c=;98v4n0l+zGgtkoF10C23fWSEraJ IIWyQOWnqtsMcXthnfdOVIE0Hxl+pPG3BrvLh03M7Y1qM0p4Gjufik2h5v0dDnErC+oGEnyHF QQJGjHEPK5G3T+pE8xqN2USLPqtkoqv+4OPFfSsRWBr8ouO9/o2iUNhKOjKOMOPhiiDqoM8Fv IcuTDrDJjXyLl6u22sNer57h4KsC71CMSyrBSSqIDSS8+9c0L9tv5LoVzT2kU4I1C/1CKQeZs tVcc37OQA3CIDufixMpfiBEh2PnJeZADMHXJYRH4i8e/JJgBlFUihPFD8jjntFGHzU3of0ev2 YX65Hk84I+WprspyFpAmXD9o35vZbWHe7/dS16QOrtE9dfavSr+Hldcb9YSMdr+aMYdoXxlD+ /YEIEoYnpapSQF/LE4MJiudEDMtHTdSoZ7T+9b9PjUcr+ESHlUrDo5yE04S41s55eVyjxraxh wYSl16FruhXLFvTrI+E6Anyk2INmIyLb1qqN97n213W5yVw8Fu+BmuM1JxjYYB9Z9WK2TBo3h TYrqw7Fjc1+rGxpxN9TdSwdVFm46YN3gbAxh8RrsZkoO9Vl/agIWa/rP4m64yEFcEl4TQUzqh 8hzurhD2kWSutSfBgY1FKLumrvuzcaf6ysCRmdsi8SU7r/kxd1yXhcaQVghTDS8Ki4K3gJypp 4Zxh9+ldm3yA3wF1UI7IHtRBTOJFYzuSdwAwMOWeZVUFYxkbpbMRqUE2O+YUlv9FYlrDcyB86 r8wUBb8kRjQb10j6Mt5a1x61hRsTI7+1Stl5frxAQGuq0FL+X9GAZPxfK/aI1XCahSZ2yOKbE a70JZTeTikCVTZHGAUMgATYTGORypSwAnxq6sz9nRGNBWP/ODqdBInw40a7w6+7mfqQar1ifh gyQaf5BO1aFdccm119yQkp9Ap3fyxkMTi5yUnXnJ4RPRqPUbGMllEWUWXC/ufqFjkYsjz5Li6 Ad1Vnt2fPF/j0/gT83v6X/mUf6tgX4v7chNrhZk+jMzDe04ikXbQu7bF/EuNBjbSxX6WCjDHs 9fAJAPIsI8nWJVeRRnd0GPmDT6zu/qsrccA0t2NRj6c/A3sav/qQNv2AeRWvX6kNrFMZwchlm c08Vi62Z7w9/xDIZ4mz+x4qkI8ZfYKIqNhnZA+70qDZf61vIjUETovK3MUhWMUoCtziUxzL5u V3opF280/3OTSXwZYvU/ebYs/snxyCgXO3JILp7/Lqb5GhPOlqI1TXKGS+nqi9QRJNgzncRoO ljer2d3CQxgK9BdVJ4rt3dlmCtTNQrmS9WcvI+L05zft6E/n+5zCbVSu/QBNNU7kJwQkESmIY AEK8vQABLXPEwGrPy1OTz8Iy33hpeCWU/JQpy9ux9d/VoBnNGXZYE9d6MDkov6JTC544IfeZe BslcT0kfnswI2ElCo5QmYjXPQSoxqm4owmdtyVI1uxRIEdFKVam4aWpC6E List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk srinivasan s schrieb am 12.02.2025 um 05:44: > One of the tables in our database suddenly started growing very > fast without any changes to the environment. it has grown over 10GB > in the last week and this is causing performance issues. We ended up > adding an index to solve the performance problem but the table > growth didn't stop. It is growing continuously. we are using > postgres version 12 on ubuntu > > 3. Also noticed that there is a auto vacuum=C2=A0job running on the tabl= e with (to prevent wraparound) Do you have any connections with the state "idle in transaction"? They wou= ld prevent (auto) vacuum.