Large table updates

Поиск
Список
Период
Сортировка
Искать
От
Chris Pizzo
Тема
Large table updates
Дата
Msg-id
5.2.0.9.1.20030403131153.00a7da70@216.162.64.162
Ответ на
Список
Дерево обсуждения
Translating Oracle CREATE TRIGGER statement Scott Cain <scain@safehooks.org>
Re: Translating Oracle CREATE TRIGGER statement Tom Lane <tgl@sss.pgh.pa.us>
Large table updates Chris Pizzo <chris@artinside.com>
Hi all,
I have a table with 3mill records of which 500K need updating.  If I run:
update fmstitm set dist = 't' where fmstitm.fitem = dist_its.fitem

does it update the entire table or one record at a time...

in other words I run
select count(*) from fmstitm where dist = 't';

as the update is running and i get o results.  Is this normal?  The update 
is taking a long time 1+ hours so far.
I just want to check that something might be wrong without any results 
returned by the count(*) query.

-Chris

В списке pgsql-novice по дате отправления
От: Scott Cain
Дата:
От: Tom Lane
Дата:
FAQ