Re: RDS No free space

This might help-
[+] https://repost.aws/knowledge-center/diskfull-error-rds-postgresql

On Sun, May 21, 2023 at 1:52 PM Lucio Chiessi <lucio(dot)chiessi(at)trustly(dot)com>
wrote:

> 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(dot)oliver(at)gmail(dot)com> 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(at)gmail(dot)com>
>> wrote:
>>
>>>
>>>
>>> On Sun, May 21, 2023 at 1:38 PM Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
>>> 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.
>>>
>>>
>>
>> --
>> Wells Oliver
>> wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>
>>
> --
>
> *Lucio Chiessi*
>
> Senior Database Administrator
>
> Trustly, Inc.
>
> M: +55 27 996360276
>
> <https://www.linkedin.com/company/trustly/>
> <https://www.facebook.com/trustly> <https://twitter.com/Trustly>
>
> <https://www.linkedin.com/company/trustly/>
> <https://www.facebook.com/trustly> <https://twitter.com/Trustly>
>
> <https://www.trustly.net/>
>
> PayWith*MyBank®* is now part of *Trustly*
>
> Please read our privacy policy *here
> <https://www.trustly.net/about-us/privacy-policy> *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