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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly