Re: PG index architecture
От
Tom Lane
Тема
Re: PG index architecture
Дата
Msg-id
11451.1405457514@sss.pgh.pa.us
Ответ на
PG index architecture (Andy Colson)
Список
Дерево обсуждения
PG index architecture Andy Colson <andy@squeakycode.net>
Re: PG index architecture Tom Lane <tgl@sss.pgh.pa.us>
Re: PG index architecture John R Pierce <pierce@hogranch.com>
Re: PG index architecture Andy Colson <andy@squeakycode.net>
Re: PG index architecture John R Pierce <pierce@hogranch.com>
Re: PG index architecture Igor Neyman <ineyman@perceptron.com>
Andy Colson writes: > As I understand indexes, they are a key value pair, that contain a value > and a position. You lookup the value then use the position to seek into > the database to load the record. > Do we, or could we, load all the the matching index records, then sort > them by position? (maybe not all, maybe large batches) This is more or less what a "bitmap index scan" does. regards, tom lane
В списке pgsql-general по дате отправления
