[postgis-users] Better storage strategy for 1 million tile of 50*50 pixels, 24 bands?

[Rémi Cura]

Hey Dear List,

I would appreciate some advice about the best way to store my raster :

1 million tiles,
50*50 pixels each (1 m2 or less in real world), around 24 bands (mostly
doubles)
,in db.

About half the pixels are empty, some tiles overlaps, but most are
regularly spaced.

I would query it mainly by localisation (intersects), and also based on id
of the tile.

The use would be fast visualisation with qgis (and latest gdal),
interpolation, classification, matching and so.

What is the best strategy?
1 table with many lines and indexes, indb,
1 table, out db
1 table, 1 line
multiple tables, heritage?


Thanks for inputs!
Cheers,

Rémi-C
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140310/74d09317/attachment.html>