Re: Slow update query

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: elias ghanem <e(dot)ghanem(at)acteos(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow update query
Date: 2010-01-22 15:05:38
Message-ID: 603c8f071001220705t3aa61c3eibfb62172c0eb644d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Jan 21, 2010 at 11:14 AM, elias ghanem <e(dot)ghanem(at)acteos(dot)com> wrote:
> So the average execution time of the function is around 2.5 mins, meaning
> that the update query (+ the vacuum) takes 2.5 mins to execute. So is this a
> normal behavior? (The same function in oracle with the same environment
> (with our vacuum obviously) is executed in 11 second).

Does Oracle get slower if you actually change something?

...Robert

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message DM 2010-01-22 17:10:48 Re: Fragmentation/Vacuum, Analyze, Re-Index
Previous Message elias ghanem 2010-01-22 12:42:39 Slow update query