Re: Bitmap index thoughts

Поиск
Список
Период
Сортировка
От Gavin Sherry
Тема Re: Bitmap index thoughts
Дата
Msg-id Pine.LNX.4.58.0702090327120.31875@linuxworld.com.au
обсуждение исходный текст
Ответ на Re: Bitmap index thoughts  (Heikki Linnakangas <heikki@enterprisedb.com>)
Список pgsql-hackers
On Thu, 8 Feb 2007, Heikki Linnakangas wrote:

> Gavin Sherry wrote:
> > I will update the code tomorrow. The focus will be cleaning up the
> > executor modifications. Please look else where for now.
>
> I'm getting a segfault with this test script:
>
> --------
> CREATE TABLE bmtest (i int);
>
> INSERT INTO bmtest SELECT 1 FROM generate_series(1,100000) a;
> INSERT INTO bmtest SELECT 10 FROM generate_series(1,100) a;
> DELETE FROM bmtest WHERE i = 1;
> VACUUM bmtest;
>
> CREATE INDEX i_bmtest ON bmtest USING bitmap (i);
>
> INSERT INTO bmtest SELECT 10 FROM generate_series(1,100000) a;
> --------
>

Hmm... this triggers a bug in the newly rewritten update code I think.
I'll post a fix soon.

Thanks for testing!

Gavin


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

Предыдущее
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: Re: [COMMITTERS] pgsql: Reduce WAL activity for page splits: > Currently, an index split
Следующее
От: Marc Munro
Дата:
Сообщение: Re: referential Integrity and SHARE locks