Re: Postgresql update op is very very slow

From: Rusty Conover <rconover(at)infogears(dot)com>
To: "jay" <jackem(dot)mojx(at)alibaba-inc(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Postgresql update op is very very slow
Date: 2008-06-25 05:02:04
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-performance

On Jun 24, 2008, at 9:12 PM, jay wrote:

> I've a table with about 34601755 rows ,when I execute 'update
> msg_table set
> type=0;' is very very slow, cost several hours, but still not
> complete?
> Why postgresql is so slowly? Is the PG MVCC problem?
> But I try it on Mysql, the same table and rows, it only cost about 340
> seconds.
> Any idea for the problem?
> My machine config:
> Memory 8G, 8 piece 15K disk , 2CPU(Quad-Core) AMD
> OS: Red Hat AS4
> My postgres.conf main parameter is following:

Hi Jay,

Is the "type" used in an index? Have you properly increased your
number of checkpoint segments? Any warnings in in your log file about
excessive checkpointing?


Rusty Conover
InfoGears Inc.

In response to


Browse pgsql-performance by date

  From Date Subject
Next Message bijayant kumar 2008-06-25 05:41:40 Re: [SOLVED] Postgresql is very slow
Previous Message jay 2008-06-25 03:12:03 Postgresql update op is very very slow