Re: index on custom function; explain
Jan Aerts <jan.aerts@gmail.com>
From: "Jan Aerts" <jan.aerts@gmail.com>
To: pgsql-performance@postgresql.org
Date: 2005-10-04T10:10:28Z
Lists: 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.