Index file is growing when I drop a table. Why?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?

foo=# select * from pg_class where oid = 41533;
-[ RECORD 1 ]-------+----------
oid                 | 41533
relname             | i_bar_su1
relnamespace        | 2200

$ pwd
/var/lib/pgsql/15/data/base/16482
$ la -aFl 41533*
-rw------- 1 postgres postgres 1073741824 2023-11-16 11:15:06 41533
-rw------- 1 postgres postgres  189792256 2023-11-16 11:24:15 41533.1


Five minutes later, 41533.1 is 4.3MB larger.

$ dir 41533* 
-rw------- 1 postgres postgres 1073741824 2023-11-16 11:15:06 41533
-rw------- 1 postgres postgres  194101248 2023-11-16 11:29:44 41533.1


[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux