pgquarrel
pgquarrel copied to clipboard
1. table-partition option and 2. foreign key constraint query after table create query
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)
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
In last commit table-partition option has more optimized query and only works on specific pg version
I pushed the foreign key commit.
What's the status of this PR?