Re: HOT for PostgreSQL 8.3

Поиск
Список
Период
Сортировка
От Pavan Deolasee
Тема Re: HOT for PostgreSQL 8.3
Дата
Msg-id 2e78013d0702130737w70d19fa8l9155ec0b275eaf11@mail.gmail.com
обсуждение исходный текст
Ответ на Re: HOT for PostgreSQL 8.3  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers


On 2/13/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Heikki Linnakangas <heikki@enterprisedb.com> writes:
> Hannu Krosing wrote:
>> Are we actually doing that ? I.E are null bitmaps really allocated in 1
>> byte steps nowadays ?

> Yes.

Not really; we still have to MAXALIGN at the end of the bitmap.  The
point is that you can get 8 bits in there before paying the first
additional MAXALIGN increment.

It's all moot anyway since 8 bits isn't enough for a pointer ...


We could live with 8 bits actually. We can store only the least
significant 8 bits of the pointer. It would point to a set of tuples and
we may need to search within that set to find the required tuple.
This would still be better than scanning the entire page.

But I agree that utilizing those 8 bits would result in a penalty
for tables with few columns.

Thanks,
Pavan

--

EnterpriseDB     http://www.enterprisedb.com

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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Variable length varlena headers redux
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: XML changes broke assert-enabled vcbuild