arrays, inline to pointer

From: Marcus Engene <ehsmeng(at)bluewin(dot)ch>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: arrays, inline to pointer
Date: 2016-05-03 08:21:10
Message-ID: 57285F76.6040904@bluewin.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2016-05-03 08:36:05 Re: arrays, inline to pointer
Previous Message David G. Johnston 2016-05-03 05:21:28 Re: Function PostgreSQL 9.2