On Thu, 2023-03-16 at 13:20 +0000, Dolan, Sean wrote: > I messed up and confused issues. The error is : > ERROR: Could not extend pg_tblspc/16555/PG_13_20200/xxxx/xxxx No space left on device > HINT: Check free disk space > > So the schema is "full" and the offender is this one table. > I can't TRUNCATE as there needs to be space to perform the action. > Is there a way to see if there is a transaction on that table like you allude to? Ah, that's different. If you don't have enough space to run TRUNCATE, and you don't feel like extending the disk space, DROP TABLE would be a convenient alternative. Yours, Laurenz Albe
