Re: Slow update query - Mailing list pgsql-performance

From Robert Haas
Subject Re: Slow update query
Date
Msg-id 603c8f071001220705t3aa61c3eibfb62172c0eb644d@mail.gmail.com
Whole thread Raw
In response to Slow update query  ("elias ghanem" <e.ghanem@acteos.com>)
List pgsql-performance
On Thu, Jan 21, 2010 at 11:14 AM, elias ghanem <e.ghanem@acteos.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

pgsql-performance by date:

Previous
From: "elias ghanem"
Date:
Subject: Slow update query
Next
From: DM
Date:
Subject: Re: Fragmentation/Vacuum, Analyze, Re-Index