Re: RDS No free space
| От | Wells Oliver |
|---|---|
| Тема | Re: RDS No free space |
| Дата | |
| Msg-id | CAOC+FBWihpHuv4U7f9FQXpMkXyngH=rt4FXOFEt4T7OF3+4u2g@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: RDS No free space (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: RDS No free space
|
| Список | pgsql-admin |
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@sss.pgh.pa.us> wrote:
Wells Oliver <wells.oliver@gmail.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.oliver@gmail.com
wells.oliver@gmail.com
В списке pgsql-admin по дате отправления: