Postgres Pro
Downloads
Home   >   mailing lists

Re: Index file is growing when I drop a table. Why? - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Index file is growing when I drop a table. Why?
Date
Msg-id CANzqJaCOqyoy+W33NdQ4TM+_64tpi-NvXivDFcrMa9QeML6gTA@mail.gmail.com
Whole thread Raw
In response to Re: Index file is growing when I drop a table. Why?  (Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>)
List pgsql-admin
Tree view
On Thu, Nov 16, 2023 at 12:22 PM Achilleas Mantzios <a.mantzios@cloud.gatewaynet.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.) 

pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: Index file is growing when I drop a table. Why?
Next
From: Yee Yee ( 舒兰）
Date:
Subject: GSSAPI authentication on Redhat8 and PostgreSQL15/16