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
Message-ID: F70DB945-81FB-4725-84E4-D1A8A90B6490@infogears.com
Views: Raw Message | Whole Thread | Download mbox
Thread:
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?

Cheers,

Rusty
--
Rusty Conover
InfoGears Inc.
http://www.infogears.com

In response to

Responses

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