pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: RDS No free space
Date: Sun, 21 May 2023 14:57:43 -0500
Message-ID: <e0f0f66e-b0a9-2d93-c1c5-783b2d128daa@gmail.com> (raw)
In-Reply-To: <CADoTbHWRBPeXUFpusbCoWGgPEqHWxUx_aN6pvPmmkY6WCSGdWg@mail.gmail.com>
References: <CAOC+FBU-1aB8+ivHe+nttSiM08QsaJH=t7_rDHb7YNTwhmkf9Q@mail.gmail.com>
	<278448.1684689788@sss.pgh.pa.us>
	<CAOC+FBWihpHuv4U7f9FQXpMkXyngH=rt4FXOFEt4T7OF3+4u2g@mail.gmail.com>
	<CAB_5SRfhyHDXQppTv2HUvj7oTHgf=BLJrTjMFj-W4LWorX-YhQ@mail.gmail.com>
	<CAOC+FBW6yKx6Lcb-5MrjMNoU2LrQJGme57jNvMX7J+txx+Tb0Q@mail.gmail.com>
	<CADoTbHWRBPeXUFpusbCoWGgPEqHWxUx_aN6pvPmmkY6WCSGdWg@mail.gmail.com>

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.oliver@gmail.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@gmail.com> wrote:
>
>
>
>         On Sun, May 21, 2023 at 1:38 PM Wells Oliver
>         <wells.oliver@gmail.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.oliver@gmail.com <mailto:wellsoliver@gmail.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://twi...;
>
> <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.

view thread (15+ messages)  latest in thread

Message-ID: <e0f0f66e-b0a9-2d93-c1c5-783b2d128daa@gmail.com>
Permalink:  ../e0f0f66e-b0a9-2d93-c1c5-783b2d128daa@gmail.com/
Also on:    postgresql.org/message-id/e0f0f66e-b0a9-2d93-c1c5-783b2d128daa@gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: RDS No free space
  In-Reply-To: <e0f0f66e-b0a9-2d93-c1c5-783b2d128daa@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox