Re: [postgis-users] Is my query planner failing me, or vice versa?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [postgis-users] Is my query planner failing me, or vice versa?
Дата
Msg-id 10011.1134624980@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [postgis-users] Is my query planner failing me, or vice versa?  ("Gregory S. Williamson" <gsw@globexplorer.com>)
Список pgsql-performance
"Gregory S. Williamson" <gsw@globexplorer.com> writes:
> Forgive the cross-posting, but I found myself wondering if might not
> be some way future way of telling the planner that a given table
> (column ?) has a high likelyhood of being TOASTed.

What would you expect the planner to do with the information, exactly?

We could certainly cause ANALYZE to record some estimate of this, but
I'm not too clear on what happens after that...

            regards, tom lane

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

Предыдущее
От: Gavin Sherry
Дата:
Сообщение: Re: PostgreSQL performance question.
Следующее
От: Kevin Brown
Дата:
Сообщение: Re: Simple Join