Thread: xml performance

xml performance

From

Raju Angani

Date:

19 August 2012, 23:49:14

Hi,

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.

Thank you
Raju