<html><body><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000"><div data-marker="__QUOTED_TEXT__">Dear list members,<br data-mce-bogus="1"></div><div data-marker="__QUOTED_TEXT__"><br data-mce-bogus="1"></div><div data-marker="__QUOTED_TEXT__">I have a table with 35 billion rows containing point geometries (SRID 31467) and use it for intersections with <!--StartFragment-->multiple <!--EndFragment--> polygon datasets. To <!--StartFragment-->improve <!--EndFragment--> performance I would like to use declarative partitioning to split the point table into sensible table partitions. Because of the <!--StartFragment-->intended <!--EndFragment--> use with ST_Intersects, I thought it <!--StartFragment-->would <!--StartFragment-->somehow <!--EndFragment--> be best<!--EndFragment--> to use geometric location as the basis for partitioning. List and range partitioning are not really applicable to the geom column, so that leaves hash partitioning. But I get the feeling that hash partioning won't work for the geometry data type either.<br data-mce-bogus="1"></div><div data-marker="__QUOTED_TEXT__"><br data-mce-bogus="1"></div><div data-marker="__QUOTED_TEXT__">All posts I found on the internet about partitioning PostGIS tables were mostly outdated and used inheritance partioning with check constraints.<br data-mce-bogus="1"></div><div data-marker="__QUOTED_TEXT__"><br data-mce-bogus="1"></div><div data-marker="__QUOTED_TEXT__">Has <!--StartFragment-->anyone <!--EndFragment--> used declarative partitioning on PostGIS geometry tables or can otherwise tell me why this might be impossible without using an <!--StartFragment-->additional <!--EndFragment--> column?<br data-mce-bogus="1"></div><div data-marker="__QUOTED_TEXT__"><br data-mce-bogus="1"></div><div data-marker="__QUOTED_TEXT__">Help would be very much appreciated :-)<br data-mce-bogus="1"></div><div data-marker="__QUOTED_TEXT__"><br data-mce-bogus="1"></div><div data-marker="__QUOTED_TEXT__">Thanks a lot and kind regards<br data-mce-bogus="1"></div><div data-marker="__QUOTED_TEXT__">Birgit<br data-mce-bogus="1"></div><div data-marker="__QUOTED_TEXT__"><br data-mce-bogus="1"></div></div></body></html>