[postgis-users] Large Databases

[Jim C. Nasby]

On Fri, Jun 09, 2006 at 10:54:34AM -0600, Graham Stewart wrote:
> Hi,
> 
> We've been using postgres on some relatively small  (~100k row)
> databases and it performs pretty well.
> 
> We're now considering loading detailed streetmap data for the entire US.
> I'm not exactly sure how large this dataset will be, but I wondered what
> experiences people have had and if there are any performance issues we
> need to be aware of.

Well, there's people running terabyte databases on PostgreSQL, so it's
really just a matter of tuning to support a large database. What kind of
hardware do you have?
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby at pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461