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
> * implement the new XML type with some index (GIST) designed for
> PostgreSQL. Which one?
> * 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 (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
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 Lane||Date: 2008-06-28 04:29:00|
|Subject: Re: XML index support |