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

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Clodoaldo <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com>
Cc: Greg Smith <gsmith(at)gregsmith(dot)com>, PostgreSQL General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: Performance problem. Could it be related to 8.3-beta4?
Date: 2008-01-08 02:19:33
Message-ID: 20080108021933.GC1828@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2008-01-08 02:49:00 Re: Memory on 32bit machine
Previous Message Chris 2008-01-08 02:10:12 Re: Memory on 32bit machine