Re: Slow table update - Mailing list pgsql-performance

From Laszlo Nagy
Subject Re: Slow table update
Date
Msg-id 494F7B48.6070204@shopzeus.com
Whole thread Raw
In response to Slow table update  (Laszlo Nagy <gandalf@shopzeus.com>)
List 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


pgsql-performance by date:

Previous
From: Laszlo Nagy
Date:
Subject: Slow table update
Next
From: "Gregory Williamson"
Date:
Subject: Re: Slow table update