Skip site navigation (1) Skip section navigation (2)

Re: slow seqscan

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: (view raw, whole thread or download thread mbox)
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

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2004-04-21 18:51:31
Subject: Re: Wierd context-switching issue on Xeon
Previous:From: Paul TuckfieldDate: 2004-04-21 18:19:46
Subject: Re: Wierd context-switching issue on Xeon

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group