yet another stupid question (index coverage)
От | Alex Pilosov |
---|---|
Тема | yet another stupid question (index coverage) |
Дата | |
Msg-id | Pine.BSO.4.10.10105171714160.7355-100000@spider.pilosoft.com обсуждение исходный текст |
Ответы |
Re: yet another stupid question (index coverage)
|
Список | pgsql-general |
Postgresql doesn't support index coverage, does it? Some stuff that really flied on [cough] other database seems very slow. Explain shows it is using index scan, however, it looks like database is fetching blocks from all over the disk, when all information necessary is already in index. For those unfamiliar with index coverage, it is used to avoid access to the main table when all necessary information can be found in index itself. (Example: select count(*) where condition, assume table has 1M rows, only 10k of them will be selected. Assume that page in main table covers 50 records and page in index covers 500 records. Total pages accessed without index coverage: ~10k, with coverage: ~20). Any chance of this feature getting on the wish list? :) I thought about coding that feature myself, but it seems to be quite involved: Apparently TupleTableSlot as it is _must_ have all information from the row... -alex
В списке pgsql-general по дате отправления: