wish help you to fix your issue As noted in the documentation, you should first install PostGIS, then execute postgis/sfcgal.sql to make available all sfcgal functions in postgresql. Read the README.txt file at the root directory of the zip you've downloaded, it describes everything that should be done in order to be able to CREATE EXTENSION postgis under windows.
Postgresql windows server ssl compression not working
I hope this helps . Building my own openssl including ZLIB, enabled compression on the postgresql server backend. And with a C++ client using libpq and connecting using sslcompression=1 in connectionstring it uses compression. A select query taking 10MB of data transmission, was reduced to about 1MB with ssl compression.
Postgresql sharding with citus extension not working
wish helps you Within Citus at this time you cannot have a unique constraint that doesn't include they column you are partitioning on. In this case, it'd be possible to enforce addresses were unique to the person id, but not globally unique. To do that you could:
CREATE TABLE person
pid bigint NOT NULL,
name character varying(100),
address_pid bigint NOT NULL,
address_type character varying(100),
CONSTRAINT id_pkey PRIMARY KEY (pid),
CONSTRAINT addr_id UNIQUE (pid, address_pid),
CONSTRAINT addr_type_id UNIQUE (pid, address_type, address_pid)