| From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | Achilleas Mantzios <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Index file is growing when I drop a table. Why? |
| Date: | 2023-11-16 20:37:38 |
| Message-ID: | CANzqJaCOqyoy+W33NdQ4TM+_64tpi-NvXivDFcrMa9QeML6gTA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, Nov 16, 2023 at 12:22 PM Achilleas Mantzios <
a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com> wrote:
> Στις 16/11/23 18:32, ο/η Ron Johnson έγραψε:
>
> Pg 15.4
>
> I'm dropping the large table "bar" in a test database, and it's taking a
> *long* time. Thus, I thought I'd watch it deleting files.
>
> To my surprise, though, the files that store the index are growing.
> What's up with that?
>
> What does pg_locks show ?
>
> SELECT blocked_locks.pid AS blocked_pid,
> blocked_activity.usename AS blocked_user,
> [snip]
>
> I was the only user in that database. (Also, the drop finished before I
saw your email.)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | 舒兰） <sweety.soul7@gmail.com> | 2023-11-17 06:57:15 | GSSAPI authentication on Redhat8 and PostgreSQL15/16 |
| Previous Message | Achilleas Mantzios | 2023-11-16 17:22:20 | Re: Index file is growing when I drop a table. Why? |