On Mon, Feb 6, 2012 at 6:05 AM, Marc Mamin <m.ma...@intershop.de> wrote: > without analyze: http://explain.depesz.com/s/6At > with analyze: http://explain.depesz.com/s/r3B
I think this is the same issue complained about here: http://archives.postgresql.org/message-id/4ed68eec.9030...@krogh.cc And here: http://archives.postgresql.org/message-id/CANxtv6XiuiqEkXRJU2vk=xkafxrlep7uvhgr-xmcyjgqz29...@mail.gmail.com The problem seems to be that the cost estimator doesn't know that detoasting is expensive. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
