[postgis-users] Optimizing PostGIS/Geoserver schema for huge dataset

[Andy Colson]

On 03/31/2017 09:33 PM, Andy Colson wrote:
>
> This says 1000 is too many:
> http://dba.stackexchange.com/questions/95977/maximum-partitioning-postgresql

Drat.  That says for 400K records you dont need 1000 partitions.  Sorry, I did't read that well, ignore this one.

I found another bit of interesting reading for partitions:
http://www.postgresql-archive.org/What-s-a-reasonable-maximum-number-for-table-partitions-td5837767.html

-Andy