Postgresql and big multidimensional arrays

Question

i used to work with mysql and save my huge 3 dimensional arrays as blob files but now i'm using postgresql and it looks like it supports array datatype. does any fast method exist to store those big arrays into the postgre database? i mean each 3d array has to be saved in a single cell from the postgre table and not as a table. Im working with Matlab, where the data is in under the form of 176x144x1750 Int arrays, and i can directly connect to the database from matlab and execute queries. thanks for your help.

Vinicius Camargo · Accepted Answer · 2011-03-08 13:19:38Z

1

I would use a three-dimensional array.

For example: CREATE TABLE ( INTEGER id PRIMARY KEY, array INTEGER[][][] );

I think you will find more tips about postgres muldimensional arrays in this link http://www.chsd.com.br/index.php?option=Article&action=Show&view=Article&id=3

There is the PostgreSQL page too. http://www.postgresql.org/docs/9.0/static/arrays.html

answered Mar 8, 2011 at 13:19

Vinicius Camargo

261 bronze badge

Sign up to request clarification or add additional context in comments.

1 Comment

Mehdi Over a year ago

Thanks, do you know what are the limits for arrays in Postgre?i mean the highest number of elements that an array can have.

Collectives™ on Stack Overflow

Postgresql and big multidimensional arrays

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related