Re: [PERFORM] Re: Indexes with condition using immutable functions applied to column not used

2011-02-11 Thread Nick Lello
know the reason why the planner is not able to use indexes which have immutable functions applied to the column in their condition ? Regards. -- Sylvain Rabot sylv...@abstraction.fr -- Nick Lello | Web Architect o +44 (0) 8433309374 | m +44 (0) 7917 138319 Email: nick.lello

Re: [HACKERS] [PERFORM] Slow count(*) again...

2011-02-06 Thread Nick Lello
list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance -- Nick Lello | Web Architect o +44 (0) 8433309374 | m +44 (0) 7917 138319 Email: nick.lello at rentrak.com RENTRAK | www.rentrak.com | NASDAQ: RENT