[postgis-users] Large Databases

[Graham Stewart]

Jim C. Nasby wrote:
> 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?
Presently we've got a Dual 3Ghz Xeon with 4 Gigs of ram running on
Windows 2003 Server. We have about half a terabyte free on the Raid
array - so it should be plenty powerful enough for our needs.

I presume the windows postgres should be as scalable as the *nix one?

Graham