Re: Another idea for index-only scans

Поиск
Список
Период
Сортировка
От James Mansion
Тема Re: Another idea for index-only scans
Дата
Msg-id 46C6D5BE.2030100@mansionfamily.plus.com
обсуждение исходный текст
Ответ на Re: Another idea for index-only scans  (Decibel! <decibel@decibel.org>)
Список pgsql-hackers
Decibel! wrote:
> The advantage to Bruce's idea is that it sounds pretty simple to 
> implement. While it wouldn't be of use for many general cases, it 
> *would* be useful for read-only tables, ie: old partitions.

Wouldn't the mostcommon case by foreign key checks against tables that 
essentially map application enums to display strings?  This is a rather 
common scenario.  It would be nice if such tables (which are typically 
small) could be retained in each backend process with a simple check 
that the cached data is still valid.

James



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

Предыдущее
От: "Trevor Talbot"
Дата:
Сообщение: Re: tsearch2 in PostgreSQL 8.3?
Следующее
От: Gregory Stark
Дата:
Сообщение: "It'd be better if there were not an implicit cast from int8 to text..."