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

XML index support

From: Jean-Michel Pouré <jmpoure(at)free(dot)fr>
To: pgsql-hackers(at)postgresql(dot)org
Subject: XML index support
Date: 2008-06-27 21:45:30
Message-ID: 1214603130.4661.8.camel@debian (view raw or flat)
Thread:
Lists: pgsql-hackers
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.

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.

Kind regards,
Jean-Michel


pgsql-hackers by date

Next:From: Tom LaneDate: 2008-06-27 21:50:44
Subject: Re: Join Removal/ Vertical Partitioning
Previous:From: Josh BerkusDate: 2008-06-27 21:25:05
Subject: Re: gsoc, text search selectivity and dllist enhancments

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