Skip to content

Instantly share code, notes, and snippets.

@didip

didip/re-inserting-to-partitioned-table.sql

Created February 10, 2014 19:45
Show Gist options
  • Save didip/8922810 to your computer and use it in GitHub Desktop.
Save didip/8922810 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
re-inserting-to-partitioned-table.sql
begin;
insert into table select * from only table where id between 1 and 10000000;
delete from only table where id between 1 and 10000000;
commit;
begin;
insert into table select * from only table where id between 10000001 and 20000000;
delete from only table where id between 10000001 and 20000000;
commit;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment