Re: Indexes on functions - Mailing list pgsql-sql

From Michael Richards
Subject Re: Indexes on functions
Date
Msg-id 3BCE35D6.00000B.93192@frodo.searchcanada.ca
Whole thread Raw
List pgsql-sql
I'm going to write a function in C that parses XML. Is there any way 
to index the output of this function? I've got 10,000,000 rows that 
contain XML data and I need to efficiently find the ones that contain 
the proper keys. I tried pulling the values I want from the data and 
putting it in its own table but with an average of 20 items that just 
grows to an unmanageable size.

-Michael
_________________________________________________________________    http://fastmail.ca/ - Fast Free Web Email for
Canadians

pgsql-sql by date:

Previous
From: Oleg Lebedev
Date:
Subject: SQL parser and/or optimizer
Next
From: CoL
Date:
Subject: Re: index problem