Skip site navigation (1) Skip section navigation (2)

Re: XML index support

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Jean-Michel Pouré <jmpoure(at)free(dot)fr>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: XML index support
Date: 2008-06-28 05:33:34
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
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

Oleg Bartunov, Research Scientist, Head of AstroNet (,
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su,
phone: +007(495)939-16-83, +007(495)939-23-83

In response to


pgsql-hackers by date

Next:From: Jean-Michel PouréDate: 2008-06-28 07:44:50
Subject: Re: XML index support
Previous:From: Tom LaneDate: 2008-06-28 04:29:00
Subject: Re: XML index support

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group