- there is definitely one dilemma here

- if you split the rss document into its "items" i am not sure if you can store each item separately inside postgres using that XML data type

- if you store the whole document, you end up with a problem when say the feed partially updates after a few minutes

- one suggestion i hear from r/PostgreSQL is that you store the XML blob somewhere else like hstore or something and somehow index it back to postgres. I wonder how that works conceptually / architecturally speaking