Sanjay,
> Also forgot to ask earlier
> Will Postgres easily handle the 100GB+ database
Depends on what you mean by "easily". I'd be very cautious about a 100GB+
database on Windows. We simply don't have much performance experience on
that platform.
That said, I know dozens of PG DBAs who are running 200GB or more databases on
Linux, BSD and Solaris.
--
Josh Berkus
Aglio Database Solutions
San Francisco