DROP TABLE IF EXISTS data_import;
CREATE TABLE data_import(aid int PRIMARY KEY, field000000000000000000000000000000001 int,field000000000000000000000000000000002 int,field000000000000000000000000000000003 int,field000000000000000000000000000000004 int,field000000000000000000000000000000005 int,field000000000000000000000000000000006 int,field000000000000000000000000000000007 int,field000000000000000000000000000000008 int,field000000000000000000000000000000009 int,field0000000000000000000000000000000010 int,field0000000000000000000000000000000011 int,field0000000000000000000000000000000012 int,field0000000000000000000000000000000013 int,field0000000000000000000000000000000014 int,field0000000000000000000000000000000015 int,field0000000000000000000000000000000016 int,field0000000000000000000000000000000017 int,field0000000000000000000000000000000018 int,field0000000000000000000000000000000019 int,field0000000000000000000000000000000020 int,field0000000000000000000000000000000021 int,field0000000000000000000000000000000022 int,field0000000000000000000000000000000023 int,field0000000000000000000000000000000024 int,field0000000000000000000000000000000025 int,field0000000000000000000000000000000026 int,field0000000000000000000000000000000027 int,field0000000000000000000000000000000028 int,field0000000000000000000000000000000029 int,field0000000000000000000000000000000030 int,field0000000000000000000000000000000031 int,field0000000000000000000000000000000032 int,field0000000000000000000000000000000033 int,field0000000000000000000000000000000034 int,field0000000000000000000000000000000035 int,field0000000000000000000000000000000036 int,field0000000000000000000000000000000037 int,field0000000000000000000000000000000038 int,field0000000000000000000000000000000039 int,field0000000000000000000000000000000040 int,field0000000000000000000000000000000041 int,field0000000000000000000000000000000042 int,field0000000000000000000000000000000043 int,field0000000000000000000000000000000044 int,field0000000000000000000000000000000045 int,field0000000000000000000000000000000046 int,field0000000000000000000000000000000047 int,field0000000000000000000000000000000048 int,field0000000000000000000000000000000049 int,field0000000000000000000000000000000050 int,field0000000000000000000000000000000051 int,field0000000000000000000000000000000052 int,field0000000000000000000000000000000053 int,field0000000000000000000000000000000054 int,field0000000000000000000000000000000055 int,field0000000000000000000000000000000056 int,field0000000000000000000000000000000057 int,field0000000000000000000000000000000058 int,field0000000000000000000000000000000059 int,field0000000000000000000000000000000060 int,field0000000000000000000000000000000061 int,field0000000000000000000000000000000062 int,field0000000000000000000000000000000063 int,field0000000000000000000000000000000064 int,field0000000000000000000000000000000065 int,field0000000000000000000000000000000066 int,field0000000000000000000000000000000067 int,field0000000000000000000000000000000068 int,field0000000000000000000000000000000069 int,field0000000000000000000000000000000070 int,field0000000000000000000000000000000071 int,field0000000000000000000000000000000072 int,field0000000000000000000000000000000073 int,field0000000000000000000000000000000074 int,field0000000000000000000000000000000075 int,field0000000000000000000000000000000076 int,field0000000000000000000000000000000077 int,field0000000000000000000000000000000078 int,field0000000000000000000000000000000079 int,field0000000000000000000000000000000080 int,field0000000000000000000000000000000081 int,field0000000000000000000000000000000082 int,field0000000000000000000000000000000083 int,field0000000000000000000000000000000084 int,field0000000000000000000000000000000085 int,field0000000000000000000000000000000086 int,field0000000000000000000000000000000087 int,field0000000000000000000000000000000088 int,field0000000000000000000000000000000089 int,field0000000000000000000000000000000090 int,field0000000000000000000000000000000091 int,field0000000000000000000000000000000092 int,field0000000000000000000000000000000093 int,field0000000000000000000000000000000094 int,field0000000000000000000000000000000095 int,field0000000000000000000000000000000096 int,field0000000000000000000000000000000097 int,field0000000000000000000000000000000098 int,field0000000000000000000000000000000099 int,field00000000000000000000000000000000100 int,field00000000000000000000000000000000101 int,field00000000000000000000000000000000102 int,field00000000000000000000000000000000103 int,field00000000000000000000000000000000104 int,field00000000000000000000000000000000105 int,field00000000000000000000000000000000106 int,field00000000000000000000000000000000107 int,field00000000000000000000000000000000108 int,field00000000000000000000000000000000109 int,field00000000000000000000000000000000110 int,field00000000000000000000000000000000111 int,field00000000000000000000000000000000112 int,field00000000000000000000000000000000113 int,field00000000000000000000000000000000114 int,field00000000000000000000000000000000115 int,field00000000000000000000000000000000116 int,field00000000000000000000000000000000117 int,field00000000000000000000000000000000118 int,field00000000000000000000000000000000119 int,field00000000000000000000000000000000120 int,field00000000000000000000000000000000121 int,field00000000000000000000000000000000122 int,field00000000000000000000000000000000123 int,field00000000000000000000000000000000124 int,field00000000000000000000000000000000125 int,field00000000000000000000000000000000126 int,field00000000000000000000000000000000127 int,field00000000000000000000000000000000128 int,field00000000000000000000000000000000129 int,field00000000000000000000000000000000130 int,field00000000000000000000000000000000131 int,field00000000000000000000000000000000132 int,field00000000000000000000000000000000133 int,field00000000000000000000000000000000134 int,field00000000000000000000000000000000135 int,field00000000000000000000000000000000136 int,field00000000000000000000000000000000137 int,field00000000000000000000000000000000138 int,field00000000000000000000000000000000139 int,field00000000000000000000000000000000140 int,field00000000000000000000000000000000141 int,field00000000000000000000000000000000142 int,field00000000000000000000000000000000143 int,field00000000000000000000000000000000144 int,field00000000000000000000000000000000145 int,field00000000000000000000000000000000146 int,field00000000000000000000000000000000147 int,field00000000000000000000000000000000148 int,field00000000000000000000000000000000149 int,field00000000000000000000000000000000150 int);
insert into data_import select generate_series(1, 10000);
vacuum freeze analyze data_import;
