"Victor de Buen (Bayes)" <vdebuen@xxxxxxxxxxxx> writes: > I'm storing historical meteorological gridded data from GFS ( > http://www.nco.ncep.noaa.gov/pmb/products/gfs/) into an array field in a > table like this: > vl_grid smallint[361][720], > - It's posible to tune some TOAST parameters to get faster atomic access > to large arrays? It might save a little bit to make the toast chunk size larger, but I'm not sure you could gain much from that. > - Using "EXTERNAL" strategy for storing TOAST-able columns could solve > the problem? Nope, wouldn't help --- AFAIR array access is not optimized for slice access. In any case, doing that would give up the compression savings that you were so happy about. If your normal access patterns involve "vertical" rather than "horizontal" scans of the data, maybe you should rethink the choice of table layout. Or maybe the compression is enough to allow you to consider storing the data twice, once in the current layout and once in a "vertical" format. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
