nur@Ainurs-MacBook-Pro ~/D/o/greenplum_tools (master)> python3 gp_cw.py  -s faa -t d_airports --host=172.16.70.128 --database=gpadmin                                                                                                 01:08:34
----- airportid -----
-- airportid RLE_TYPE 3 1240 bytes 100.0 %
-- airportid RLE_TYPE 4 1240 bytes 100.0 %
-- airportid RLE_TYPE 2 1264 bytes 101.94 %
-- airportid RLE_TYPE 1 2184 bytes 176.13 %
-- airportid ZLIB 1 2744 bytes 221.29 %
-- airportid ZLIB 5 2744 bytes 221.29 %
-- airportid ZLIB 9 2744 bytes 221.29 %
-- airportid QUICKLZ 1 5688 bytes 458.71 %
----- longitude -----
-- longitude ZLIB 5 12 kB 100.0 %
-- longitude ZLIB 9 12 kB 100.0 %
-- longitude RLE_TYPE 3 12 kB 100.13 %
-- longitude RLE_TYPE 4 12 kB 100.13 %
-- longitude ZLIB 1 12 kB 100.33 %
-- longitude RLE_TYPE 2 12 kB 100.6 %
-- longitude QUICKLZ 1 13 kB 113.42 %
-- longitude RLE_TYPE 1 13 kB 114.35 %
----- timezoneoffset -----
-- timezoneoffset RLE_TYPE 4 880 bytes 100.0 %
-- timezoneoffset ZLIB 9 888 bytes 100.91 %
-- timezoneoffset RLE_TYPE 3 928 bytes 105.45 %
-- timezoneoffset ZLIB 5 984 bytes 111.82 %
-- timezoneoffset RLE_TYPE 2 1160 bytes 131.82 %
-- timezoneoffset ZLIB 1 1272 bytes 144.55 %
-- timezoneoffset QUICKLZ 1 2344 bytes 266.36 %
-- timezoneoffset RLE_TYPE 1 7816 bytes 888.18 %
----- airport_code -----
-- airport_code ZLIB 9 3752 bytes 100.0 %
-- airport_code ZLIB 1 3760 bytes 100.21 %
-- airport_code ZLIB 5 3760 bytes 100.21 %
-- airport_code RLE_TYPE 2 3816 bytes 101.71 %
-- airport_code RLE_TYPE 3 3824 bytes 101.92 %
-- airport_code RLE_TYPE 4 3824 bytes 101.92 %
-- airport_code QUICKLZ 1 6160 bytes 164.18 %
-- airport_code RLE_TYPE 1 6160 bytes 164.18 %
----- icoa_code -----
-- icoa_code ZLIB 9 3800 bytes 100.0 %
-- icoa_code ZLIB 5 3824 bytes 100.63 %
-- icoa_code RLE_TYPE 4 3848 bytes 101.26 %
-- icoa_code RLE_TYPE 3 3856 bytes 101.47 %
-- icoa_code RLE_TYPE 2 3976 bytes 104.63 %
-- icoa_code ZLIB 1 3984 bytes 104.84 %
-- icoa_code QUICKLZ 1 5832 bytes 153.47 %
-- icoa_code RLE_TYPE 1 7168 bytes 188.63 %
----- altitude -----
-- altitude ZLIB 9 3880 bytes 100.0 %
-- altitude RLE_TYPE 4 3952 bytes 101.86 %
-- altitude ZLIB 5 4008 bytes 103.3 %
-- altitude RLE_TYPE 3 4080 bytes 105.15 %
-- altitude ZLIB 1 4288 bytes 110.52 %
-- altitude RLE_TYPE 2 4352 bytes 112.16 %
-- altitude QUICKLZ 1 4968 bytes 128.04 %
-- altitude RLE_TYPE 1 13 kB 341.86 %
----- city -----
-- city ZLIB 5 9304 bytes 100.0 %
-- city ZLIB 9 9312 bytes 100.09 %
-- city RLE_TYPE 3 9352 bytes 100.52 %
-- city RLE_TYPE 4 9368 bytes 100.69 %
-- city ZLIB 1 9608 bytes 103.27 %
-- city RLE_TYPE 2 9664 bytes 103.87 %
-- city QUICKLZ 1 12 kB 135.51 %
-- city RLE_TYPE 1 17 kB 185.73 %
----- dst_flag -----
-- dst_flag RLE_TYPE 2 192 bytes 100.0 %
-- dst_flag RLE_TYPE 3 192 bytes 100.0 %
-- dst_flag RLE_TYPE 4 192 bytes 100.0 %
-- dst_flag ZLIB 9 200 bytes 104.17 %
-- dst_flag ZLIB 5 224 bytes 116.67 %
-- dst_flag ZLIB 1 256 bytes 133.33 %
-- dst_flag RLE_TYPE 1 376 bytes 195.83 %
-- dst_flag QUICKLZ 1 384 bytes 200.0 %
----- tz -----
-- tz RLE_TYPE 4 1160 bytes 100.0 %
-- tz ZLIB 9 1240 bytes 106.9 %
-- tz RLE_TYPE 3 1320 bytes 113.79 %
-- tz ZLIB 5 1512 bytes 130.34 %
-- tz RLE_TYPE 2 1608 bytes 138.62 %
-- tz ZLIB 1 1960 bytes 168.97 %
-- tz QUICKLZ 1 2856 bytes 246.21 %
-- tz RLE_TYPE 1 15 kB 1341.38 %
----- latitude -----
-- latitude ZLIB 5 12 kB 100.0 %
-- latitude ZLIB 9 12 kB 100.0 %
-- latitude RLE_TYPE 3 12 kB 100.2 %
-- latitude RLE_TYPE 4 12 kB 100.2 %
-- latitude ZLIB 1 12 kB 100.47 %
-- latitude RLE_TYPE 2 12 kB 100.67 %
-- latitude QUICKLZ 1 13 kB 113.72 %
-- latitude RLE_TYPE 1 13 kB 114.59 %
----- country -----
-- country RLE_TYPE 3 72 bytes 100.0 %
-- country RLE_TYPE 4 72 bytes 100.0 %
-- country RLE_TYPE 1 80 bytes 111.11 %
-- country RLE_TYPE 2 80 bytes 111.11 %
-- country ZLIB 5 128 bytes 177.78 %
-- country ZLIB 9 128 bytes 177.78 %
-- country ZLIB 1 216 bytes 300.0 %
-- country QUICKLZ 1 368 bytes 511.11 %
----- name -----
-- name ZLIB 9 15 kB 100.0 %
-- name RLE_TYPE 4 15 kB 100.57 %
-- name ZLIB 5 15 kB 100.68 %
-- name RLE_TYPE 3 15 kB 100.99 %
-- name RLE_TYPE 2 16 kB 108.52 %
-- name ZLIB 1 16 kB 108.58 %
-- name QUICKLZ 1 20 kB 134.93 %
-- name RLE_TYPE 1 35 kB 229.83 %

        SET search_path TO faa;

        CREATE TABLE d_airports_new_type (
          LIKE d_airports,
          COLUMN airportid ENCODING (compresstype=RLE_TYPE, COMPRESSLEVEL=2),
COLUMN timezoneoffset ENCODING (compresstype=ZLIB, COMPRESSLEVEL=9),
COLUMN dst_flag ENCODING (compresstype=ZLIB, COMPRESSLEVEL=9),
COLUMN tz ENCODING (compresstype=ZLIB, COMPRESSLEVEL=9),
COLUMN name ENCODING (compresstype=ZLIB, COMPRESSLEVEL=1),
COLUMN city ENCODING (compresstype=ZLIB, COMPRESSLEVEL=1),
COLUMN country ENCODING (compresstype=RLE_TYPE, COMPRESSLEVEL=1),
COLUMN airport_code ENCODING (compresstype=ZLIB, COMPRESSLEVEL=1),
COLUMN icoa_code ENCODING (compresstype=ZLIB, COMPRESSLEVEL=1),
COLUMN latitude ENCODING (compresstype=ZLIB, COMPRESSLEVEL=1),
COLUMN longitude ENCODING (compresstype=ZLIB, COMPRESSLEVEL=1),
COLUMN altitude ENCODING (compresstype=ZLIB, COMPRESSLEVEL=1)
        )
        WITH (
          appendonly=true,
          orientation=column,
          compresstype=RLE_TYPE,
          COMPRESSLEVEL=3
        );
        INSERT INTO d_airports_new_type SELECT * FROM d_airports;
        ANALYZE d_airports_new_type;


        --CHECK INDEXES
        BEGIN;
        ALTER TABLE d_airports RENAME TO d_airports_old;
        ALTER TABLE d_airports_new_type RENAME TO d_airports;
        COMMIT;