SQL Diff ?

From: Kevin Kempter <kevin(at)kevinkempterllc(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: SQL Diff ?
Date: 2007-08-26 02:51:59
Message-ID: 200708252051.59528.kevin@kevinkempterllc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi List;

I have a very large table (52million rows) - I'm creating a copy of it to rid
it of 35G worth of dead space, then I'll do a sync, drop the original table
and rename table2.

Once I have the table2 as a copy of table1 what's the best way to select all
rows that have been changed, modified in table1 since the initial laod from
table1 into table2?

Also I'll need to delete any rows in table2 that no longer remain in table1.

There is no change date column
I could do something like select * from table1 where col1 || col2 || col3 etc
not in (select col1 || col2 || col3 etc from table2)

but this would be ineffecient & slow.

Anyone have a suggestion to do this in an efficient manner?

Thanks in advance

/Kevin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2007-08-26 03:10:19 Re: SQL Diff ?
Previous Message Max Zorloff 2007-08-25 22:32:59 Re: Shared memory usage