xml performance

From: Raju Angani <angani(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: xml performance
Date: 2012-08-19 20:48:48
Message-ID: CAJ-04Oo4eovMLXr7YXOOKzepXqFWchujr_2TT=XfPrdA7hS3WA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2012-08-19 21:37:41 Re: Ignore hash indices on replicas
Previous Message fashouri 2012-08-19 14:49:43 importing updated files into a database