Wagner,
> If there is anyone that can give me some tweak parameters or design
> help on this, it would be ridiculously appreciated. I have already
> created this in Oracle and it works, but we don't want to have to pay
> the monster if something as wonderful as Postgres can handle it.
In addition to Rod's advice, please increase your checkpoint_segments and
checkpoint_timeout parameters and make sure that the pg_xlog is on a seperate
disk resource from the database.
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco