| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Edoardo Ceccarelli <eddy(at)axa(dot)it> |
| Cc: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Nick Barr <nicky(at)chuckie(dot)co(dot)uk>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: slow seqscan |
| Date: | 2004-04-21 18:20:25 |
| Message-ID: | 13305.1082571625@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Edoardo Ceccarelli <eddy(at)axa(dot)it> writes:
> I wasn't able to make this 2 field index with lower:
> dba400=# CREATE INDEX annuncio400_rubric_testo_idx ON
> annuncio400(rubric, LOWER(testo));
> ERROR: parser: parse error at or near "(" at character 71
> seems impossible to creat 2 field indexes with lower function.
You need 7.4 to do that; previous releases don't support multi-column
functional indexes.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-04-21 18:51:31 | Re: Wierd context-switching issue on Xeon |
| Previous Message | Paul Tuckfield | 2004-04-21 18:19:46 | Re: Wierd context-switching issue on Xeon |