Hello again,
El jueves 6 de junio de 2013 a las 12:23, Jorge Arévalo escribió:
Hello,
El miércoles 5 de junio de 2013 a las 20:31, Paul Ramsey escribió:
Well, your objects are larger than the page size, so you're getting them
out of the toast tables, not directly out of main
Hello,
El miércoles 5 de junio de 2013 a las 20:31, Paul Ramsey escribió:
Well, your objects are larger than the page size, so you're getting them out
of the toast tables, not directly out of main storage. You may also have your
type declared as 'main' storage, which means it's zipped up,
Hello,
I'm running this PostGIS Raster query
select
st_scalex(rast),
st_scaley(rast),
st_skewx(rast),
st_skewy(rast),
st_width(rast),
st_height(rast),
rid,
st_upperleftx(rast),
st_upperlefty(rast),
st_numbands(rast)
from
my_postgis_raster_table
I want to remark that, even when
Well, your objects are larger than the page size, so you're getting them out of
the toast tables, not directly out of main storage. You may also have your type
declared as 'main' storage, which means it's zipped up, so it's being unzipped
before you can access it, that's also an overhead.