Slow update statement

I have used an normal update statement by special column and it has index. But it take over one minute to do it and it is sometime so fast.
Plz help. My setting like that

My table have over 150.000.000 rows. Plz help.

Maybe you want to share your update statement? As well as an execution plan (explain (verbose, analyze, buffers)).

This topic was automatically closed after 30 days. New replies are no longer allowed.