Thank a lot, Merlin.
I will try to fill a sample of grids in a new table with different sizes of
subgrids in order to get the better relation between space and speed.
Regards
2009/7/22 Merlin Moncure
> On Tue, Jul 21, 2009 at 7:43 PM, Victor de Buen
> (Bayes) wrote:
> > Hi
> >
> > I'm storing
On Tue, Jul 21, 2009 at 7:43 PM, Victor de Buen
(Bayes) wrote:
> Hi
>
> 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:
>
> CREATE TABLE grid_f_data_i2 (
> //Specifies the variable and other
Thank you very much, Tom
I will try vector 'parallel' and 'vertical' strategies.
Regards
2009/7/22 Tom Lane
> "Victor de Buen (Bayes)" 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
> > tab
Thank you very much, Tom
I will try vector 'parallel' and 'vertical' strategies.
Regards
2009/7/22 Tom Lane
> "Victor de Buen (Bayes)" 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
> > tab
"Victor de Buen (Bayes)" 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 ac
Hi
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:
CREATE TABLE grid_f_data_i2 (
//Specifies the variable and other features of data
id_inventory integer REFERENCES grid_d_inventory(id_inve
Victor,
Just wondering why do you use array ?
Oleg
On Wed, 22 Jul 2009, Victor de Buen (Bayes) wrote:
Hi
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:
CREATE TABLE grid_f_data_i2 (
//Sp
Hi
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:
CREATE TABLE grid_f_data_i2 (
//Specifies the variable and other features of data
id_inventory integer REFERENCES grid_d_inventory(id_inve
