Dmytro Vorotyntsev
08/31/2022, 5:11 AMAn analysis of the cluster’s workload and database schema identified columns that will significantly benefit from using a different compression encoding.All suggested tables are those configured with Postgres CDC (Deduped History) And its suggestion
ALTER TABLE "public"."tatable_1_scd" ALTER COLUMN "_airbyte_unique_key_scd" ENCODE lzo;
ALTER TABLE "public"."table_2_scd" ALTER COLUMN "_airbyte_unique_key_scd" ENCODE lzo;
ALTER TABLE "public"."table_3_scd" ALTER COLUMN "_airbyte_unique_key_scd" ENCODE lzo;
ALTER TABLE "public"."tatable_1_scd" ALTER COLUMN "_airbyte_emitted_at" ENCODE az64;
ALTER TABLE "public"."table_3_scd" ALTER COLUMN "_airbyte_emitted_at" ENCODE az64;
ALTER TABLE "public"."table_4_scd" ALTER COLUMN "_airbyte_emitted_at" ENCODE az64;
Is it a relevant suggestion? Would it break the airbyte sync logic if encoding updated?
ThanksDmytro Vorotyntsev
08/31/2022, 5:12 AM