Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance problem. Could it be related to 8.3-beta4? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Performance problem. Could it be related to 8.3-beta4?
Date
Msg-id 20080108021933.GC1828@alvh.no-ip.org
Whole thread Raw
In response to Re: Performance problem. Could it be related to 8.3-beta4?  (Clodoaldo <clodoaldo.pinto.neto@gmail.com>)
Responses Re: Performance problem. Could it be related to 8.3-beta4?
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Chris
Date:
Subject: Re: Memory on 32bit machine
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Memory on 32bit machine