Re: Slow table update

From: Laszlo Nagy <gandalf(at)shopzeus(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Slow table update
Date: 2008-12-22 11:34:32
Message-ID: 494F7B48.6070204@shopzeus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Laszlo Nagy wrote:
> SQL:
>
> update product set sz_category_id=null where am_style_kw1 is not null
> and sz_category_id is not null
Hmm, this query:

select count(*) from product where am_style_kw1 is not null and
sz_category_id is not null and sz_category_id<>4809

opens in 10 seconds. The update would not finish in 2600 seconds. I
don't understand.

L

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Gregory Williamson 2008-12-22 11:45:11 Re: Slow table update
Previous Message Laszlo Nagy 2008-12-22 11:06:02 Slow table update