Re: Performance problem. Could it be related to 8.3-beta4?

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