Re: XML index support

On Fri, 27 Jun 2008, Jean-Michel Pour? wrote:

> Dear friends,
>
> You may know me as I worked a long time ago on pgAdmin I with Dave.
>
> ЪЪAs this is an XML related question and XML is quite new, I am posting
> on hackers ML. If any solution is being developped, please inform us.
>
> We would like to develop a free REST database (real-estate standard)
> based on a PostgreSQL schema. This is a free solution for free data
> also, released under BSD or GPL license. We are charity.
>
> This is supposed to a "killer application", so we need to drive down
> queries to 3ms to 5ms to allow hundreds of simultaneous queries.
>
> Php will probably be part of the package.
>
> What is in your opinion the best way to achive this :
> * develop a traditional databe and implement materialized views in PL
> OR
> * implement the new XML type with some index (GIST) designed for
> PostgreSQL. Which one?
> OR
> * write triggers behind XML tables to pullulate a traditionnal database,
> add indexes and query traditionnal database.

Hmm, why do you need XML here ? I'd use standard relational
approach with our contrib/hstore module for storing specific content,
which is a probable reason you want XML. Table inheritance would be also
useful.

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru)
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83