| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Mikael Petterson <mikaelpetterson(at)hotmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Disk is filling up with large files. How can I clean? |
| Date: | 2024-10-09 15:24:38 |
| Message-ID: | 67caa2a7-38a7-4d2f-8902-79cb664cad67@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 10/8/24 04:06, Mikael Petterson wrote:
> Hi,
> I find our disk is filling up.
Query the pg_stat_activity view:
https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-PG-STAT-ACTIVITY-VIEW
and look for rows that have with state showing 'idle in transaction'.
Report back what you find.
You should also check out this post:
https://www.cybertec-postgresql.com/en/reasons-why-vacuum-wont-remove-dead-rows/
> What can I do to clean up. We are using pgsql 12.
> Br,
> //Mikael
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2024-10-09 16:01:17 | Re: Disk is filling up with large files. How can I clean? |
| Previous Message | Adrian Klaver | 2024-10-09 15:15:54 | Re: pg_dump throwing segfault error during backup |