Re: RDS No free space

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


You can check if you having some strong queries that were generating a lot of temp files, that will can eat all off free space.

On Sun, 21 May 2023 at 14:48 Wells Oliver <wells.oliver@xxxxxxxxx> wrote:
I'm not too familiar with that. Can you point me in the direction of some config settings and maybe queries to execute?

On Sun, May 21, 2023 at 10:43 AM Jim Mlodgenski <jimmy76@xxxxxxxxx> wrote:

On Sun, May 21, 2023 at 1:38 PM Wells Oliver <wells.oliver@xxxxxxxxx> wrote:
So we run on RDS, and we clearly used up all of our provisioned storage. However, I am baffled, and while I am emailing our AWS support, I wondered if this list might point me in some direction too.

Our provisioned storage was 15TB. The size of our database -- shown in pg_database -- is only 6TB. What in the world could be using that remaining space? I am at a loss, that's a _ton_ of space being used up. Is it some temporary allocation during script execution (seems ginormous, impossible)? It it some WAL log thing?

A fairly common cause of this is orphan replication slots so WAL files are retained. Check
to see if there is an inactive slot that may be preventing the files to be removed.


Lucio Chiessi

Senior Database Administrator

Trustly, Inc.

M: +55 27 996360276



PayWithMyBank® is now part of Trustly

Please read our privacy policy here on how we process your personal data in accordance with the General Data Protection Regulation (EU) 2016/679 (the “GDPR”) and other applicable data protection legislation

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux