Re: GiST index on data types that require compression

Поиск
Список
Период
Сортировка
От Dave Blasby
Тема Re: GiST index on data types that require compression
Дата
Msg-id 3B0EABE6.93AC0025@refractions.net
обсуждение исходный текст
Ответ на Re: GiST index on data types that require compression  (Oleg Bartunov <oleg@sai.msu.su>)
Список pgsql-hackers
I took your (Tom, Oleg, and Teodor's) advice and changed my GiST code so
it compresses a normal GEOMETRY into a BOX3D-only-GEOMETRY by striping
out the actual geometric information.  This way, everything is
consistent.

I now appear to be able to create and use a GiST index (well, it works
on my 1 test case ;^) ).

Unfortunately, when I issue the CREATE INDEX command, it takes a really
long time.  The system goes to about 80% iowait (according to top), or
mostly idle.  There's lots of memory free.   Any ideas why?

dave


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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: plpgsql update bug?
Следующее
От: Lamar Owen
Дата:
Сообщение: Re: Not released yet, but could someone take a quick peak ...