[postgis-users] splitting a PostGIS db across multiple disks

[Raphaël Jacquot]

On Tue, 2010-04-06 at 09:33 -0500, P Kishor wrote:

> Suppose I have a table FOO0 that stores info about every state in the
> union. I know that some of these states will have mongo number of
> rows, but I don't have to build all the states immediately. So, I
> start with a few states' worth data, putting it in the default
> /usr/local/pgsql/data location.

you should use some form of hashing function to distribute the stuff
evenly