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

eulerto / pgquarrel

pgquarrel compares PostgreSQL database schemas (DDL)

BSD 3-Clause "New" or "Revised" License

389 stars 42 forks source link

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

Open hazardland opened 3 years ago

hazardland commented 3 years ago

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 commented 3 years ago

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 commented 3 years ago

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

eulerto commented 3 years ago

I pushed the foreign key commit.

bompi88 commented 2 years ago

What's the status of this PR?