Re: Tsearch2 Initial Search Speed

Поиск
Список
Период
Сортировка
От Howard Cole
Тема Re: Tsearch2 Initial Search Speed
Дата
Msg-id 4857BBF7.7070909@selestial.com
обсуждение исходный текст
Ответ на Re: Tsearch2 Initial Search Speed  (Matthew Wakeling <matthew@flymine.org>)
Список pgsql-performance
> Actually, the index returns page numbers in the table on disc which
> may contain one or more rows that are relevant. Postgres has to fetch
> the whole row to find out the email_id and any other information,
> including whether the row is visible in your current transaction
> (concurrency control complicates it all). Just having a page number
> isn't much use to you!
>
> Matthew
>
I learn something new every day.

Thanks Matthew.

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

Предыдущее
От: Matthew Wakeling
Дата:
Сообщение: Re: Migration Articles.. ???
Следующее
От: "Lionel"
Дата:
Сообщение: Which hardware ?