pgquarrel icon indicating copy to clipboard operation
pgquarrel copied to clipboard

1. table-partition option and 2. foreign key constraint query after table create query

Open hazardland opened this issue 3 years ago • 4 comments

table-partition [default true] option allows to ignore table partition and partition index compares which in big projects (where 90% of tables are partitions) boosts compare process speed dramatically (in our case 9 minutes scaled down to 39 seconds)

hazardland avatar Mar 30 '21 17:03 hazardland

Hm actually now it includes 2 fixes:

First 3 commit for this issue https://github.com/eulerto/pgquarrel/issues/97 Last 1 commit for this issue https://github.com/eulerto/pgquarrel/issues/98

hazardland avatar Mar 30 '21 20:03 hazardland

In last commit table-partition option has more optimized query and only works on specific pg version

hazardland avatar Apr 02 '21 18:04 hazardland

I pushed the foreign key commit.

eulerto avatar Apr 17 '21 13:04 eulerto

What's the status of this PR?

bompi88 avatar Dec 21 '21 15:12 bompi88