From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | Victor d'Agostino <victor(dot)d(dot)agostino(at)fiducial(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Does writing new records while massive update will generate lock ? |
Date: | 2014-08-21 14:48:24 |
Message-ID: | 53F606B8.4040604@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 21/08/2014 14:41, Victor d'Agostino wrote:
> 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*
Not that this helps your issue, but you may not be aware that 8.4 is now
end-of-life and so is no longer supported:
http://www.postgresql.org/support/versioning
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2014-08-21 15:00:02 | Re: Does writing new records while massive update will generate lock ? |
Previous Message | Shaun Thomas | 2014-08-21 14:00:12 | Re: Does writing new records while massive update will generate lock ? |