Re: Effect of large text field data on queries

Поиск
Список
Период
Сортировка
От Alan Hodgson
Тема Re: Effect of large text field data on queries
Дата
Msg-id 200610261336.09011@hal.medialogik.com
обсуждение исходный текст
Ответ на Effect of large text field data on queries  (Glen Parker <glenebob@nwlink.com>)
Список pgsql-general
On Thursday 26 October 2006 12:51, Glen Parker <glenebob@nwlink.com> wrote:
> Why would very large text values effect the speed of a seq scan that
> does not actually evaluate those values?

Seq scan reads the whole table.  The limiting factor is the size of the
table on disk.

--
"If a nation expects to be ignorant and free, in a state of civilization,
it expects what never was and never will be." -- Thomas Jefferson


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

Предыдущее
От: Glen Parker
Дата:
Сообщение: Re: Effect of large text field data on queries
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Effect of large text field data on queries