Re: [SQL] quest:optimization with indexes - Mailing list pgsql-sql

From Clayton Cottingham
Subject Re: [SQL] quest:optimization with indexes
Date
Msg-id 37B1B641.5AD0DC0C@smartt.com
Whole thread Raw
In response to quest:optimization with indexes  (Clayton Cottingham <drfrog@smartt.com>)
Responses Re: [SQL] quest:optimization with indexes
List pgsql-sql
thanks all, i actually was able to piece this all together last night!

what i did was create another column that had a nextval sequence
and im using that as an index, instead of over a thousand sec i am now getting
a index with 2 sec

thanks for all those 'like' tips i was wonderinng, would using regex be the
same as far as the indexing rules go?






pgsql-sql by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: [SQL] quest:optimization with indexes
Next
From: Tom Lane
Date:
Subject: Re: [SQL] quest:optimization with indexes