geospatial
geospatial copied to clipboard
greenplum-db
PostGIS for Greenplum
There are some problems during compiling the project. ``` rtpg_inout.c: In function ‘RASTER_recv’: rtpg_inout.c:132:2: error: unknown type name ‘StringInfo’; did you mean ‘fmStringInfo’? StringInfo buf = (StringInfo) PG_GETARG_POINTER(0); ^~~~~~~~~~ fmStringInfo...
Hello! I've developed a manual and a set of scripts for building PostGIS on the Debian platform. I'd be delighted if people could utilize my work within their GreenPlum clusters....
When store the geometric attributes in the pages, we firstly try to keep them in main tuple uncompressed, and stored compressed inline when the tuple doesn't fit into a page....
https://github.com/greenplum-db/gpdb/blob/c07c06f5572e9e2b362cfa126e383fa8fdb1274c/src/include/access/htup.h#L68 greenplum has delete t_tableOid at 6.x in struct HeapTupleData https://github.com/greenplum-db/gpdb/blob/6.19.x/src/include/access/htup.h#L68 CDB: t_tableOid deleted. Instead, use tts_tableOid in TupleTableSlot when compile with gp 6.x throw error: ``` mvt.c: In function...
ST_Union 聚合函数并没有在segment上面将geometry数据聚合之后，再发送到master节点上面，之后由master节点Gather Motion explain 结果如下： ```sql postgres=# explain analyze select st_union(geom) from world ; QUERY PLAN -------------------------------------------------------------------------------------------------------------------------------------- Aggregate (cost=0.00..432.56 rows=1 width=8) (actual time=209.767..209.769 rows=1 loops=1) -> Gather Motion 3:1 (slice1;...
Hello! I'm trying to install, but there's no configure file...just a configure.ac cd postgis/build/postgis-2.5.4/ ./configure --with-pgconfig=$GPHOME/bin/pg_config --with-raster --without-topology --prefix=$GPHOME -bash: ./configure: No such file or directory Missing something?? Kind regards
when create postgis extention ,i get some error: [gpadmin@gpdb1 ~]$ psql -d postgres -c 'CREATE EXTENSION postgis;' ERROR: function unnest(double precision[]) is not unique LINE 1: SELECT COUNT(DISTINCT unnest)::float FROM...
