| From: | Varun Kacholia <varunk(at)cse(dot)iitb(dot)ac(dot)in> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Partial indexing |
| Date: | 2002-06-16 22:02:54 |
| Message-ID: | 20020617033536.C11708@voxel.cse.iitb.ac.in |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> Isnt the following query supported in postgresql (it is surely useful and
> > supported in MySQL )
> > CREATE INDEX t_index ON (NAME(20) , ID);
> I can't see any particular value in that myself, but Postgres supports
> a generic approach to weird indexing requirements: functional indexes.
Well, i think that partial indexing (on a column) can save a disk
space as well as, a lot of time.In my opinion the query above
is much better than the one below (in terms of time) :
> > CREATE INDEX t_index ON (NAME(200) , ID);
--
------
Varun
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff MacDonald | 2002-06-17 01:27:52 | Re: read this and puke |
| Previous Message | Stephan Szabo | 2002-06-16 20:36:31 | Re: Creating database cluster |