Re: text search: tablescan cost for a tsvector

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: text search: tablescan cost for a tsvector
Дата
Msg-id CA+TgmoZgQBeu2KN305hwDS+aXW7YP0YN9vZwBsbWA8Unst+cew@mail.gmail.com
обсуждение исходный текст
Ответ на text search: tablescan cost for a tsvector  ("Marc Mamin" <M.Mamin@intershop.de>)
Список pgsql-performance
Дерево обсуждения 
On Mon, Feb 6, 2012 at 6:05 AM, Marc Mamin <M.Mamin@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.9030906@krogh.cc

And here:

http://archives.postgresql.org/message-id/CANxtv6XiuiqEkXRJU2vk=xKAFXrLeP7uVhgR-XMCyjgQz29EFQ@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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Stefan Keller
Дата:
Сообщение: Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
Следующее
От: Robert Haas
Дата:
Сообщение: Re: How to improve insert speed with index on text column