I have been looking into Postgres for last 1 month. I was wondering if there is a easy wy to store xml data in Postgres and not have any performance impact.
Few properties of the XML doc that are stored in the table
1) Each doc could be 1mb in size. 2) Need to update few attributes with the document. 3) It could be 4 level nested document. 4) Insert/Select are the majority operations.
Could you please help me with any pointers, currently I'm using xDB, an EMC product.