On Mon, Aug 11, 2008 at 2:53 AM, Sabin Coanda <sabin.coanda@xxxxxxxxxxxxx> wrote: > No, I cannot use VACUUM inside the transaction, and it seems this is the > problem, although autovacuum is set. > > However I checked the following scenario to find a solution. I call the > 30000 statements without transaction. The performance it not changed. But > when I add VACUUM command after each 20 statement set, I got the linear > performance that I want. Unfortunatelly this is not possible inside a > transaction. > > Do you know how could I solve my problem, keeping the 30000 statements > inside a single transaction ? long running transactions can be evil. is there a reason why this has to run in a single transaction? merlin
