Postgres Pro
Downloads
Home   >   mailing lists

Re: Interesting speed anomaly - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Interesting speed anomaly
Date
Msg-id 19749.1134575285@sss.pgh.pa.us
Whole thread Raw
In response to Interesting speed anomaly  (Zoltan Boszormenyi <zboszor@dunaweb.hu>)
Responses Re: Interesting speed anomaly  (Zoltan Boszormenyi <zboszor@dunaweb.hu>)
List pgsql-hackers
Tree view 
Zoltan Boszormenyi <zboszor@dunaweb.hu> writes:
> $ time echo "select * from v_invoice_browse where code||inv_no = 'CARO200000020'" | dbaccess db

> Is there a way to speed this operation up?

Make an expression index on "code||inv_no", if you think this case is
important enough to be worth maintaining an extra index for.

(This is not on-topic for -hackers, IMHO.  Try pgsql-perform.)
        regards, tom lane

pgsql-hackers by date:

Previous
From: Zoltan Boszormenyi
Date:
Subject: Interesting speed anomaly
Next
From: Richard Huxton
Date:
Subject: Re: Immodest Proposal: pg_catalog.pg_ddl