Hi All,
I am checking if there is a way to process quickly large datasets such as
census blocks in PostGIS and also by leveraging big data platform. I have few
questions in this regard.
1) When I try intersect for sample census blocks with another polygon layer,
PostGIS 2.2(on Postgres 9.4)
Hi Ravi,
On 18/01/2016 19:14, Ravi Pavuluri wrote:
> Hi All,
>
> I am checking if there is a way to process quickly large datasets such
> as census blocks in PostGIS and also by leveraging big data platform. I
> have few questions in this regard.
>
> 1) When I try intersect for sample census
Hey,
if you have one beefy server you can parallelize throwing several queries
working on sub set of your data.
(aka parallel processing trough data partition).
One conceptual example : you want to process the world, you create 20
workers, a list of countries, and then make the worker process the
We have a 750GB production database that was originally created on PostgreSQL
9.0 and has an unpackaged implementation of PostGIS 2.0.7. We’re now on
PostgreSQL 9.4, and we’re still running the unpackaged PostGIS 2.0.7. We need
to get to a packaged (extensions) implementation of PostGIS 2.1.8.
There are two conferences coming up which are looking for speakers and
should have PostGIS content. They are the following:
1) FOSS4G NA 2016 - Raleigh, North Carolina May 2-5th, 2016
https://2016.foss4g-na.org/
Deadline for Early bird submissions - January 22nd, 2016
Final Deadline for
Vincent and Remi,
Thank you both for your inputs. I have combined two things in one thread.
Parallelization is a secondary need and I will look into "Postgresql-Xc,
Greenplum or custom code approach".
Regarding the PostGIS performance on intersecting geometries, I am not able to
see any
