sing songs_artist_key on songs (cost=0.00..10804.11 rows=4341
width=14) (actual time=0.027..103.448 rows=25207 loops=1)
Total runtime: 135.697 ms
Of course I can just take the number of rows from the latter query, but I'm
still wondering why it can't use indexes with functions.
Thanks
--
Shi
uffers = 65536 # min max_connections*2 or 16, 8KB each
sort_mem = 16384 # min 64, size in KB
effective_cache_size = 327680# typically 8KB each
random_page_cost = 1.5 # 4 # units are one sequential page fetch cost
--
Shiar - http://www.shiar.org
> Mi devas forfughi antau flu
