Re: Idle sessions keep deleted files open

2020-03-29 Thread Andres Freund
Hi, On 2020-03-30 00:49:13 +0200, Peter J. Holzer wrote: > I noticed this with PostgreSQL 11.7 on Linux: > > I did a «vacuum full» on a table which had become quite bloated (size > before the vacuum: 392 GB, after: 291 GB). I expected the disk usage to > increase as the new table was written and

Idle sessions keep deleted files open

2020-03-29 Thread Peter J. Holzer
I noticed this with PostgreSQL 11.7 on Linux: I did a «vacuum full» on a table which had become quite bloated (size before the vacuum: 392 GB, after: 291 GB). I expected the disk usage to increase as the new table was written and then drop sharply after the vacuum was finished. However, that didn