I did it in pgadmin, without begin commit.
On Sat, Apr 13, 2019 at 4:24 PM Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 4/13/19 7:10 AM, Paul van der Linden wrote: > > It was just 99 files of 1GB each for each id, and no I didn't vacuum. > > I did see disk usage dropping quite a lot after dropping those tables > > though, so I expected postgres to delete all unneccesary files for all > > the tables. > > > > However when checking just now I saw that the files I was referring to > > were indeed deleted somehow (don't have an autovacuum running). > > So not sure how or why, but my problem is solved > > Did you DROP the tables in a transaction and look at the the directory > previously before you issued COMMIT? > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
