Clodoaldo escribió: 8.2: > Trigger for constraint datas: time=14231.240 calls=880691 > Total runtime: 356862.302 ms > (12 rows) > > Time: 357750.531 ms 8.3: > Trigger for constraint datas: time=33179.197 calls=877895 > Total runtime: 9546878.520 ms > (13 rows) So what's this constraint and why is it taking longer on the 8.3 server? -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
