well there is truncate for that. (not mvcc safe) | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		merb on Oct 12, 2020 \| parent \| context \| favorite \| on: Zheap – Reinvented PostgreSQL Storage well there is truncate for that. (not mvcc safe)

teej on Oct 12, 2020 [–]

The table needed to never be visible as empty, so truncate wasn't a short term option.

takeda on Oct 12, 2020 | [–]

I solved this by using partitions (at the time it was done through inheritance, where you could make one table made out of several smaller ones), and just dropping a table with unneeded data.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact