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 -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
