Received: from web12703.mail.yahoo.com (web12703.mail.yahoo.com [216.136.173.240]) by postgresql.org (8.11.3/8.11.4) with SMTP id g0BHdcB67601 for ; Fri, 11 Jan 2002 12:39:38 -0500 (EST) (envelope-from chestercyoung@yahoo.com) Message-ID: <20020111173943.69680.qmail@web12703.mail.yahoo.com> Received: from [207.188.162.30] by web12703.mail.yahoo.com via HTTP; Fri, 11 Jan 2002 09:39:43 PST Date: Fri, 11 Jan 2002 09:39:43 -0800 (PST) From: Chester Carlton Young Subject: Re: Resources To: pgsql-sql@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200201/92 X-Sequence-Number: 6181 In regards to not being able to change tables, a common trick (eg, in data warehousing) where tables are read only, is to have a trigger on the table populate a secondary table with good index info (like ripping street name out of the address) and the oid of the original row. The query is a little more complex, but very good performance. > You mention that it may be too late to change the tables, but I guess > that's > where I'd look next- I once had a similar situation when I worked for > an > electric utility & we ended up parsing the address lines to find road > names > & numbers and then loading them into special indexed fields just used > for > sorting. If you control the input app, maybe you could even have the > user > enter the fields you want to query on separately. > > > -Nick > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) __________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/