On Mon, Feb 6, 2012 at 6:05 AM, Marc Mamin <M.Mamin@xxxxxxxxxxxx> 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.9030906@xxxxxxxx And here: http://archives.postgresql.org/message-id/CANxtv6XiuiqEkXRJU2vk=xKAFXrLeP7uVhgR-XMCyjgQz29EFQ@xxxxxxxxxxxxxx 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
