Database table Deletion
Is it possible for Neon to delete entries in a table in database for a free tier account to save storage space ?
4 Replies
flat-fuchsia•2mo ago
Absolutely! You can delete rows then run VACUUM FULL (blocking) or pg_repack (online).
On Neon, storage also includes retained WALs, so space won’t drop until the Instant Restore window ages out
automatic-azureOP•2mo ago
Thank you.
Ok, if i where to login to Neons user dashboard, to access a database and then manually select rows in a table to be deleted, is there an audit log that tracks this action ?
Also, please can i restore any deleted rows from a table ?
flat-fuchsia•2mo ago
You could individually select rows but that would take forever, you're better off writing a query to bulk delete them. As for audit log, yes, in the Monitoring tab there's a Query History section. You can also access them with
pg_stat_statements .
For restore, you don't choose deleted rows to restore, you chose either a LSN or a timestamp to restore from.automatic-azureOP•2mo ago
thank you