News for hackers. Stuff that matters.
Re:Building a distributed time-series database on PostgreSQL by enordstr on Thursday August 22, 2019 @03:31AM (#20765534)
It basically boils down to deleting a bunch of files on disk. The fact that it is distributed doesn't affect efficiency too much; it is basically a delete sent to all nodes, followed by a two-phase commit.

The upside of deleting entire tables (chunks) like this is that you don't pay the same PostgreSQL vacuuming cost normally associated with row-by-row deletes.

Re:Building a distributed time-series database on PostgreSQL by truth_seeker on Thursday August 22, 2019 @04:21AM (#20765837)
Thanks.