hi :wave: I’ve setup a connection from Postgres to...
# advice-data-warehouses
d
hi 👋 I’ve setup a connection from Postgres to Amazon Redshift, the Redshift has a mechanism to Improve Query Performance and Optimize Storage with Compression Encoding It observed
An 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
Copy code
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? Thanks