Notion employee here. We don't put images themselves in Postgres- we use s3 to store them. The article is referring to image blocks, which are effectively pointers to the image.

I... Don't think they are? If you look at the URL for images in notion, you can see the S3 hostname.