On 21 August 2014 15:41, Victor d'Agostino
wrote:
> I'm updating this column (for more than 48 hours now) on a RAID5 server.
>
RAID5? That's probably the worst performing RAID configuration you can have
and is usually advised against on this list.
You would be better off with RAID 10, RAID 1+0
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 MYBIGTAB
On 08/21/2014 08:41 AM, Victor d'Agostino wrote:
UPDATE MYBIGTABLE SET date = (SELECT date FROM INDEXEDTABLE WHERE
INDEXEDTABLE.email_id=MYBIGTABLE.email_id) WHERE date is null;
I may be wrong here, but wouldn't this style of query force a nested
loop? Over several million rows, that would ta
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