arrays, inline to pointer

Поиск
Список
Период
Сортировка
От Marcus Engene
Тема arrays, inline to pointer
Дата
Msg-id 57285F76.6040904@bluewin.ch
обсуждение исходный текст
Ответы Re: arrays, inline to pointer  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
Hi,

I have some whopper tables for machine learning. One table has a handful
of 200-500 double precision arrays (representing feature vectors). It's
a 9.5 on a SSD (over USB3). Each table has 5-15M rows in them.

For each array I've added, and populated, any dealings with the table
has become way way slower. I can only assume this is because the array
data is inline in the datablock on disk that stores the row.

Is it possible to "have a pointer instead", or is the only workaround a
child table with vector only in it?

Best regards,
Marcus



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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Function PostgreSQL 9.2
Следующее
От: John R Pierce
Дата:
Сообщение: Re: arrays, inline to pointer