Re: COUNT(*) and index-only scans

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: COUNT(*) and index-only scans
Дата
Msg-id CAM-w4HNpbKyqFMmH3ZahRTP_htK+42OGMbjMpY7ur30xSSKbCg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: COUNT(*) and index-only scans  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: COUNT(*) and index-only scans  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Mon, Nov 21, 2011 at 6:43 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> In buffer fill mode, we scan the index and add matching tuples and
> their CTIDs to the buffer.  When the buffer is full or the index AM
> reports that there are no more tuples in the scan, we switch to buffer
> drain mode.

Instead you could do the two phases concurrently the way tuplesort
implements the tapesort from Knuth. You keep a heap of ctids with an
epoch. You fill the heap then you return the first one. Whenever you
return one you read the next one and add it to the heap. If it falls
before the last returned value you insert it with the next epoch but
if it falls afterwards you can insert it into the heap in its correct
position.




--
greg


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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: pg_dump --exclude-table-data
Следующее
От: Pavan Deolasee
Дата:
Сообщение: Re: Race condition in HEAD, possibly due to PGPROC splitup