Re: index on custom function; explain - Mailing list pgsql-performance

From Jan Aerts
Subject Re: index on custom function; explain
Date
Msg-id 1128420628.326795.158780@g47g2000cwa.googlegroups.com
Whole thread Raw
Responses Re: index on custom function; explain
List pgsql-performance
Some additional thoughts: what appears to take the most time (i.e.
account for the highest cost in the explain), is _not_ running the
function itself (cost=0.00..0.01), but comparing the result from that
function with the name1 column in the mappings table
(cost=0.00..35935.05). Am I right? (See EXPLAIN in previous post.) If
so: that's pretty strange, because the name1-column in the mappings
table is indexed...

jan.


pgsql-performance by date:

Previous
From: Gregory Maxwell
Date:
Subject: Re: [HACKERS] A Better External Sort?
Next
From: "Dann Corbit"
Date:
Subject: Re: [HACKERS] A Better External Sort?