LisPi on Nostr: I actually intended to use PostgreSQL's large blob storage originally. But as it so ...

I actually intended to use PostgreSQL's large blob storage originally.

But as it so happens, that's implemented as a single table per database which means it has exactly the same storage limits as ordinary unpartitioned tables.

If used to store media, one would rather rapidly hit the limit.

It's very unfortunate, because the fact that *is* bound to the transactionality and rollback properties of everything else made it a very attractive option.