Raw_email post field stores images as Base64 strings

This is going to sound a bit reductive, but that’s how images are sent over email. And since we’re storing the raw_email… that’s what we store.

Think of it like a 100MB Inbox. Which is a drop in the bucket for most sites.

You can find the storage size with:

select sum(pg_column_size(raw_email)) / 1048576 as raw_email_MB from posts;

We would no longer be storing the raw_email in that case… I suppose there’s an argument to made for stripping large base64 content from raw_emails over a certain age…

Not likely; it’ll sit on disk but should not be referenced unless you look at it.

:thinking: