From: | Victor d'Agostino <victor(dot)d(dot)agostino(at)fiducial(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Does writing new records while massive update will generate lock ? |
Date: | 2014-08-21 13:41:59 |
Message-ID: | 53F5F727.5000000@fiducial.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi everybody,
I added a datetime column to a table with 51.10^6 entries.
ALTER TABLE MYBIGTABLE ADD COLUMN date timestamp without time zone;
I'm updating this column (for more than 48 hours now) on a RAID5 server.
UPDATE MYBIGTABLE SET date = (SELECT date FROM INDEXEDTABLE WHERE INDEXEDTABLE.email_id=MYBIGTABLE.email_id) WHERE date is null;
This transaction is still running and will end in several days. It only
uses 1 core.
My question is : Can I add new records in the table or will it generate
locks ?
I am using postgresql *8.4*
Thanks for your help !
Regards,
Victor
________________
Ce message et les eventuels documents joints peuvent contenir des informations confidentielles. Au cas ou il ne vous serait pas destine, nous vous remercions de bien vouloir le supprimer et en aviser immediatement l'expediteur. Toute utilisation de ce message non conforme a sa destination, toute diffusion ou publication, totale ou partielle et quel qu'en soit le moyen est formellement interdite. Les communications sur internet n'etant pas securisees, l'integrite de ce message n'est pas assuree et la societe emettrice ne peut etre tenue pour responsable de son contenu.
From | Date | Subject | |
---|---|---|---|
Next Message | Shaun Thomas | 2014-08-21 14:00:12 | Re: Does writing new records while massive update will generate lock ? |
Previous Message | Patrick Dung | 2014-08-21 09:36:24 | Re: Use of 'now' constant datatype in view to take advantage of partitioned table |