Re: RDS No free space

On 5/21/23 12:52, Lucio Chiessi 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.

That was my first thought.

>
> 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 <mailto: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 accordancewiththeGeneral Data Protection Regulation(EU)
> 2016/679 (the “GDPR”) and other applicable data protection legislation

--
Born in Arizona, moved to Babylonia.