Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #903

Update 500 Million row table

Show all headers | View raw

We are trying to update 4 columns on a 500 million row table with data from a Temp table.

I.E.

Update table1 a
SET a.column1 = b.column1
        a.column2 = b.column2
        a.column3 = b.column3
        a.column4 = b.column4
FROM table2 b
where a.column1 = b.column1;

The where clause is joining on a Unique index but the table has 16 indexes in total.

This was running for over 18 hours and had to be killed.

Back to comp.databases.postgresql | Previous | Next — Next in thread | Find similar

Thread

Update 500 Million row table Rich Ford <richford990@gmail.com> - 2022-03-09 16:37 -0800
  Re: Update 500 Million row table George Neuner <gneuner2@comcast.net> - 2022-03-11 10:52 -0500
    Re: Update 500 Million row table Andy Wallace <arwallace58@gmail.com> - 2022-05-04 15:25 -0700
      Re: Update 500 Million row table George Neuner <gneuner2@comcast.net> - 2022-05-06 10:05 -0400

csiph-web