Rodrigo, > I need to insert 500.000 records on a table frequently. Itīs a bulk > insertion from my applicatoin. > I am with a very poor performance. PostgreSQL insert very fast until the > tuple 200.000 and after it the insertion starts to be really slow. > I am seeing on the log and there is a lot of transaction logs, something
In addition to what Chris Browne asked: What's your transaction log setup? Are your database transaction logs on a seperate disk resource? What is checkpoint_segments and checkpoint_timeout set to? -- Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]