On Thu, Nov 16, 2023 at 12:22 PM Achilleas Mantzios <a.mantzios@xxxxxxxxxxxxxxxxxxxx> 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.)
