{"action":"created","issue":{"url":"https://api.github.com/repos/citusdata/citus_docs/issues/7","repository_url":"https://api.github.com/repos/citusdata/citus_docs","labels_url":"https://api.github.com/repos/citusdata/citus_docs/issues/7/labels{/name}","comments_url":"https://api.github.com/repos/citusdata/citus_docs/issues/7/comments","events_url":"https://api.github.com/repos/citusdata/citus_docs/issues/7/events","html_url":"https://github.com/citusdata/citus_docs/issues/7","id":150493145,"number":7,"title":"Add section for PostGIS","user":{"login":"citus-github-bot","id":17053023,"avatar_url":"https://avatars.githubusercontent.com/u/17053023?v=3","gravatar_id":"","url":"https://api.github.com/users/citus-github-bot","html_url":"https://github.com/citus-github-bot","followers_url":"https://api.github.com/users/citus-github-bot/followers","following_url":"https://api.github.com/users/citus-github-bot/following{/other_user}","gists_url":"https://api.github.com/users/citus-github-bot/gists{/gist_id}","starred_url":"https://api.github.com/users/citus-github-bot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/citus-github-bot/subscriptions","organizations_url":"https://api.github.com/users/citus-github-bot/orgs","repos_url":"https://api.github.com/users/citus-github-bot/repos","events_url":"https://api.github.com/users/citus-github-bot/events{/privacy}","received_events_url":"https://api.github.com/users/citus-github-bot/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/citusdata/citus_docs/labels/enhancement","name":"enhancement","color":"84b6eb"},{"url":"https://api.github.com/repos/citusdata/citus_docs/labels/examples","name":"examples","color":"bfd4f2"},{"url":"https://api.github.com/repos/citusdata/citus_docs/labels/user%20guide","name":"user guide","color":"bfe5bf"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-04-22T23:23:14Z","updated_at":"2016-04-22T23:23:15Z","closed_at":null,"body":"<a href=\"https://github.com/samay-sharma\"><img src=\"https://avatars.githubusercontent.com/u/6285167?v=3\" align=\"left\" width=\"96\" height=\"96\" hspace=\"10\"></img></a> **Issue by [samay-sharma](https://github.com/samay-sharma)**\n_Friday Aug 07, 2015 at 00:19 GMT_\n_Originally opened as https://github.com/citusdata/citus_documentation_source/issues/5_\n\n----\n\nEither in user guide or in the Examples, we should add more information about using PostGIS with CitusDB.\n"},"comment":{"url":"https://api.github.com/repos/citusdata/citus_docs/issues/comments/213622901","html_url":"https://github.com/citusdata/citus_docs/issues/7#issuecomment-213622901","issue_url":"https://api.github.com/repos/citusdata/citus_docs/issues/7","id":213622901,"user":{"login":"citus-github-bot","id":17053023,"avatar_url":"https://avatars.githubusercontent.com/u/17053023?v=3","gravatar_id":"","url":"https://api.github.com/users/citus-github-bot","html_url":"https://github.com/citus-github-bot","followers_url":"https://api.github.com/users/citus-github-bot/followers","following_url":"https://api.github.com/users/citus-github-bot/following{/other_user}","gists_url":"https://api.github.com/users/citus-github-bot/gists{/gist_id}","starred_url":"https://api.github.com/users/citus-github-bot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/citus-github-bot/subscriptions","organizations_url":"https://api.github.com/users/citus-github-bot/orgs","repos_url":"https://api.github.com/users/citus-github-bot/repos","events_url":"https://api.github.com/users/citus-github-bot/events{/privacy}","received_events_url":"https://api.github.com/users/citus-github-bot/received_events","type":"User","site_admin":false},"created_at":"2016-04-22T23:23:15Z","updated_at":"2016-04-22T23:23:15Z","body":"<a href=\"https://github.com/samay-sharma\"><img src=\"https://avatars.githubusercontent.com/u/6285167?v=3\" align=\"left\" width=\"48\" height=\"48\" hspace=\"10\"></img></a> **Comment by [samay-sharma](https://github.com/samay-sharma)**\n_Thursday Apr 14, 2016 at 21:54 GMT_\n\n----\n\nAdding information about what works and what doesn't. It might be useful to include this when we work on this item.\r\n\r\nYou should be able to use PostGIS mostly as it is with Citus. The only thing that won't work out of the box are the PostGIS aggregate functions on the SELECT clause. This is because aggregate functions need some modification to be executed in parallel across multiple shards.\r\n\r\n A few examples from the documentation\r\nST_Accum - Aggregate. Constructs an array of geometries.\r\nST_Extent - an aggregate function that returns the bounding box that bounds rows of geometries.\r\nST_Extent3D - an aggregate function that returns the box3D bounding box that bounds rows of geometries.\r\nST_Polygonize - Aggregate. Creates a GeometryCollection containing possible polygons formed from the constituent linework of a set of geometries.\r\nST_Union - Returns a geometry that represents the point set union of the Geometries.\r\nNote that these functions should be supported in the WHERE clause.\r\n\r\nAlso, we see that in many cases it is possible to find meaningful workarounds which would help us support these aggregates because of the flexibility of Postgres and Citus. So, if there is a particular use case you have in mind, we'd be happy to look further into how that can be supported.\n"}}