Re: RDS No free space

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?

I know this is part AWS RDS and part PG but it's difficult to track down.
Welcome to any ideas to dig into.

On Sun, May 21, 2023 at 10:23 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Wells Oliver <wells(dot)oliver(at)gmail(dot)com> writes:
> > I am seeing a lot of this morning:
> > ERROR: could not extend file "base/16411/616989679.62": No space left on
> > devi2023-05-21 17:11:45 UTC::@:[386]:LOG: all server processes
> terminated;
> > reinitializing
>
> *Something* is preventing PG from using more disk space. Check ulimit,
> cgroups, container limits, etc.
>
> regards, tom lane
>

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>