BUG #14137: 'insert into' never returns when toast's oids are exhausted
| От | furukawa.nagisa@live.jp |
|---|---|
| Тема | BUG #14137: 'insert into' never returns when toast's oids are exhausted |
| Дата | |
| Msg-id | 20160513223202.2844.31638@wrigleys.postgresql.org обсуждение исходный текст |
| Список | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14137
Logged by: Sogo Mineo
Email address: furukawa.nagisa@live.jp
PostgreSQL version: 9.6beta1
Operating system: Cent OS 7
Description:
I was suffering from a problem that 'insert into' didn't finish
in two or three months.
I attached gdb to the backend process,
and I found that the process was trapped in a loop
in GetNewOidWithIndex(). The backtrace is:
#0 0x00000000004a8ae1 in index_fetch_heap ()
#1 0x00000000004a8c30 in index_getnext ()
#2 0x00000000004a8299 in systable_getnext ()
#3 0x00000000004e9ca8 in GetNewOidWithIndex ()
#4 0x00000000004a4cfe in toast_save_datum.isra.2 ()
#5 0x00000000004a66ad in toast_insert_or_update ()
#6 0x000000000049b7b6 in heap_insert ()
#7 0x00000000005cade3 in ExecModifyTable ()
#8 0x00000000005b2078 in ExecProcNode ()
#9 0x00000000005ae4fb in standard_ExecutorRun ()
#10 0x00000000006b5b0e in ProcessQuery ()
#11 0x00000000006b5d3c in PortalRunMulti ()
#12 0x00000000006b6789 in PortalRun ()
#13 0x00000000006b4646 in PostgresMain ()
#14 0x000000000046acd8 in ServerLoop ()
#15 0x000000000065bab6 in PostmasterMain ()
#16 0x000000000046b7b0 in main ()
(To say the truth, this backtrace is from the test I will describe below,
but I had got similar backtraces in the actual situation)
The backtrace reads that the backend process wanted to insert
a new row in the toast table, and wanted a new oid for the new row,
and called GetNewOidWithIndex().
In backend/catalog/catalog.c:
Oid
GetNewOidWithIndex(Relation relation, Oid indexId, AttrNumber
oidcolumn)
{
...
do
{
...
newOid = GetNewObjectId();
...
collides = HeapTupleIsValid(systable_getnext(scan));
...
} while (collides);
return newOid;
}
I suspect that the 'do...while()' loop above does not break
if there are already 2^32 rows in a toast table.
To confirm this speculation, I ran the script attached at the
bottom of message. (Note that I had to do it in a freshly installed
postgres in order to avoid frequent oid "collision" to speed up
the test process)
After the test script output "9 Mi entries written",
the backend process stopped writing things, and still the
"insert into" query continued running.
The backtrace above was obtained here.
To explain this: the script created a table with 448 array columns
that were all driven out to the toast table. Therefore, after
2**32 / 448 = 9*(2**20) + 149796 rows were inserted,
the backend process was trapped in the infinite loop.
/* * * The test script * * */
/* Create a table with lots of toasted fields. */
CREATE TABLE test (
pad001 Bigint DEFAULT 0, pad002 Bigint DEFAULT 0,
pad003 Bigint DEFAULT 0, pad004 Bigint DEFAULT 0,
pad005 Bigint DEFAULT 0, pad006 Bigint DEFAULT 0,
pad007 Bigint DEFAULT 0, pad008 Bigint DEFAULT 0,
pad009 Bigint DEFAULT 0,
arr000 Integer[], arr001 Integer[], arr002 Integer[], arr003 Integer[],
arr004 Integer[], arr005 Integer[], arr006 Integer[], arr007 Integer[],
arr008 Integer[], arr009 Integer[], arr00a Integer[], arr00b Integer[],
arr00c Integer[], arr00d Integer[], arr00e Integer[], arr00f Integer[],
arr010 Integer[], arr011 Integer[], arr012 Integer[], arr013 Integer[],
arr014 Integer[], arr015 Integer[], arr016 Integer[], arr017 Integer[],
arr018 Integer[], arr019 Integer[], arr01a Integer[], arr01b Integer[],
arr01c Integer[], arr01d Integer[], arr01e Integer[], arr01f Integer[],
arr020 Integer[], arr021 Integer[], arr022 Integer[], arr023 Integer[],
arr024 Integer[], arr025 Integer[], arr026 Integer[], arr027 Integer[],
arr028 Integer[], arr029 Integer[], arr02a Integer[], arr02b Integer[],
arr02c Integer[], arr02d Integer[], arr02e Integer[], arr02f Integer[],
arr030 Integer[], arr031 Integer[], arr032 Integer[], arr033 Integer[],
arr034 Integer[], arr035 Integer[], arr036 Integer[], arr037 Integer[],
arr038 Integer[], arr039 Integer[], arr03a Integer[], arr03b Integer[],
arr03c Integer[], arr03d Integer[], arr03e Integer[], arr03f Integer[],
arr040 Integer[], arr041 Integer[], arr042 Integer[], arr043 Integer[],
arr044 Integer[], arr045 Integer[], arr046 Integer[], arr047 Integer[],
arr048 Integer[], arr049 Integer[], arr04a Integer[], arr04b Integer[],
arr04c Integer[], arr04d Integer[], arr04e Integer[], arr04f Integer[],
arr050 Integer[], arr051 Integer[], arr052 Integer[], arr053 Integer[],
arr054 Integer[], arr055 Integer[], arr056 Integer[], arr057 Integer[],
arr058 Integer[], arr059 Integer[], arr05a Integer[], arr05b Integer[],
arr05c Integer[], arr05d Integer[], arr05e Integer[], arr05f Integer[],
arr060 Integer[], arr061 Integer[], arr062 Integer[], arr063 Integer[],
arr064 Integer[], arr065 Integer[], arr066 Integer[], arr067 Integer[],
arr068 Integer[], arr069 Integer[], arr06a Integer[], arr06b Integer[],
arr06c Integer[], arr06d Integer[], arr06e Integer[], arr06f Integer[],
arr070 Integer[], arr071 Integer[], arr072 Integer[], arr073 Integer[],
arr074 Integer[], arr075 Integer[], arr076 Integer[], arr077 Integer[],
arr078 Integer[], arr079 Integer[], arr07a Integer[], arr07b Integer[],
arr07c Integer[], arr07d Integer[], arr07e Integer[], arr07f Integer[],
arr080 Integer[], arr081 Integer[], arr082 Integer[], arr083 Integer[],
arr084 Integer[], arr085 Integer[], arr086 Integer[], arr087 Integer[],
arr088 Integer[], arr089 Integer[], arr08a Integer[], arr08b Integer[],
arr08c Integer[], arr08d Integer[], arr08e Integer[], arr08f Integer[],
arr090 Integer[], arr091 Integer[], arr092 Integer[], arr093 Integer[],
arr094 Integer[], arr095 Integer[], arr096 Integer[], arr097 Integer[],
arr098 Integer[], arr099 Integer[], arr09a Integer[], arr09b Integer[],
arr09c Integer[], arr09d Integer[], arr09e Integer[], arr09f Integer[],
arr0a0 Integer[], arr0a1 Integer[], arr0a2 Integer[], arr0a3 Integer[],
arr0a4 Integer[], arr0a5 Integer[], arr0a6 Integer[], arr0a7 Integer[],
arr0a8 Integer[], arr0a9 Integer[], arr0aa Integer[], arr0ab Integer[],
arr0ac Integer[], arr0ad Integer[], arr0ae Integer[], arr0af Integer[],
arr0b0 Integer[], arr0b1 Integer[], arr0b2 Integer[], arr0b3 Integer[],
arr0b4 Integer[], arr0b5 Integer[], arr0b6 Integer[], arr0b7 Integer[],
arr0b8 Integer[], arr0b9 Integer[], arr0ba Integer[], arr0bb Integer[],
arr0bc Integer[], arr0bd Integer[], arr0be Integer[], arr0bf Integer[],
arr0c0 Integer[], arr0c1 Integer[], arr0c2 Integer[], arr0c3 Integer[],
arr0c4 Integer[], arr0c5 Integer[], arr0c6 Integer[], arr0c7 Integer[],
arr0c8 Integer[], arr0c9 Integer[], arr0ca Integer[], arr0cb Integer[],
arr0cc Integer[], arr0cd Integer[], arr0ce Integer[], arr0cf Integer[],
arr0d0 Integer[], arr0d1 Integer[], arr0d2 Integer[], arr0d3 Integer[],
arr0d4 Integer[], arr0d5 Integer[], arr0d6 Integer[], arr0d7 Integer[],
arr0d8 Integer[], arr0d9 Integer[], arr0da Integer[], arr0db Integer[],
arr0dc Integer[], arr0dd Integer[], arr0de Integer[], arr0df Integer[],
arr0e0 Integer[], arr0e1 Integer[], arr0e2 Integer[], arr0e3 Integer[],
arr0e4 Integer[], arr0e5 Integer[], arr0e6 Integer[], arr0e7 Integer[],
arr0e8 Integer[], arr0e9 Integer[], arr0ea Integer[], arr0eb Integer[],
arr0ec Integer[], arr0ed Integer[], arr0ee Integer[], arr0ef Integer[],
arr0f0 Integer[], arr0f1 Integer[], arr0f2 Integer[], arr0f3 Integer[],
arr0f4 Integer[], arr0f5 Integer[], arr0f6 Integer[], arr0f7 Integer[],
arr0f8 Integer[], arr0f9 Integer[], arr0fa Integer[], arr0fb Integer[],
arr0fc Integer[], arr0fd Integer[], arr0fe Integer[], arr0ff Integer[],
arr100 Integer[], arr101 Integer[], arr102 Integer[], arr103 Integer[],
arr104 Integer[], arr105 Integer[], arr106 Integer[], arr107 Integer[],
arr108 Integer[], arr109 Integer[], arr10a Integer[], arr10b Integer[],
arr10c Integer[], arr10d Integer[], arr10e Integer[], arr10f Integer[],
arr110 Integer[], arr111 Integer[], arr112 Integer[], arr113 Integer[],
arr114 Integer[], arr115 Integer[], arr116 Integer[], arr117 Integer[],
arr118 Integer[], arr119 Integer[], arr11a Integer[], arr11b Integer[],
arr11c Integer[], arr11d Integer[], arr11e Integer[], arr11f Integer[],
arr120 Integer[], arr121 Integer[], arr122 Integer[], arr123 Integer[],
arr124 Integer[], arr125 Integer[], arr126 Integer[], arr127 Integer[],
arr128 Integer[], arr129 Integer[], arr12a Integer[], arr12b Integer[],
arr12c Integer[], arr12d Integer[], arr12e Integer[], arr12f Integer[],
arr130 Integer[], arr131 Integer[], arr132 Integer[], arr133 Integer[],
arr134 Integer[], arr135 Integer[], arr136 Integer[], arr137 Integer[],
arr138 Integer[], arr139 Integer[], arr13a Integer[], arr13b Integer[],
arr13c Integer[], arr13d Integer[], arr13e Integer[], arr13f Integer[],
arr140 Integer[], arr141 Integer[], arr142 Integer[], arr143 Integer[],
arr144 Integer[], arr145 Integer[], arr146 Integer[], arr147 Integer[],
arr148 Integer[], arr149 Integer[], arr14a Integer[], arr14b Integer[],
arr14c Integer[], arr14d Integer[], arr14e Integer[], arr14f Integer[],
arr150 Integer[], arr151 Integer[], arr152 Integer[], arr153 Integer[],
arr154 Integer[], arr155 Integer[], arr156 Integer[], arr157 Integer[],
arr158 Integer[], arr159 Integer[], arr15a Integer[], arr15b Integer[],
arr15c Integer[], arr15d Integer[], arr15e Integer[], arr15f Integer[],
arr160 Integer[], arr161 Integer[], arr162 Integer[], arr163 Integer[],
arr164 Integer[], arr165 Integer[], arr166 Integer[], arr167 Integer[],
arr168 Integer[], arr169 Integer[], arr16a Integer[], arr16b Integer[],
arr16c Integer[], arr16d Integer[], arr16e Integer[], arr16f Integer[],
arr170 Integer[], arr171 Integer[], arr172 Integer[], arr173 Integer[],
arr174 Integer[], arr175 Integer[], arr176 Integer[], arr177 Integer[],
arr178 Integer[], arr179 Integer[], arr17a Integer[], arr17b Integer[],
arr17c Integer[], arr17d Integer[], arr17e Integer[], arr17f Integer[],
arr180 Integer[], arr181 Integer[], arr182 Integer[], arr183 Integer[],
arr184 Integer[], arr185 Integer[], arr186 Integer[], arr187 Integer[],
arr188 Integer[], arr189 Integer[], arr18a Integer[], arr18b Integer[],
arr18c Integer[], arr18d Integer[], arr18e Integer[], arr18f Integer[],
arr190 Integer[], arr191 Integer[], arr192 Integer[], arr193 Integer[],
arr194 Integer[], arr195 Integer[], arr196 Integer[], arr197 Integer[],
arr198 Integer[], arr199 Integer[], arr19a Integer[], arr19b Integer[],
arr19c Integer[], arr19d Integer[], arr19e Integer[], arr19f Integer[],
arr1a0 Integer[], arr1a1 Integer[], arr1a2 Integer[], arr1a3 Integer[],
arr1a4 Integer[], arr1a5 Integer[], arr1a6 Integer[], arr1a7 Integer[],
arr1a8 Integer[], arr1a9 Integer[], arr1aa Integer[], arr1ab Integer[],
arr1ac Integer[], arr1ad Integer[], arr1ae Integer[], arr1af Integer[],
arr1b0 Integer[], arr1b1 Integer[], arr1b2 Integer[], arr1b3 Integer[],
arr1b4 Integer[], arr1b5 Integer[], arr1b6 Integer[], arr1b7 Integer[],
arr1b8 Integer[], arr1b9 Integer[], arr1ba Integer[], arr1bb Integer[],
arr1bc Integer[], arr1bd Integer[], arr1be Integer[], arr1bf Integer[]
);
/* Insert 1024*1024 rows. Each row is: ('{null}','{null}',...,'{null}')*/
INSERT INTO test (
arr000, arr001, arr002, arr003, arr004, arr005, arr006, arr007, arr008,
arr009, arr00a, arr00b, arr00c, arr00d, arr00e, arr00f,
arr010, arr011, arr012, arr013, arr014, arr015, arr016, arr017, arr018,
arr019, arr01a, arr01b, arr01c, arr01d, arr01e, arr01f,
arr020, arr021, arr022, arr023, arr024, arr025, arr026, arr027, arr028,
arr029, arr02a, arr02b, arr02c, arr02d, arr02e, arr02f,
arr030, arr031, arr032, arr033, arr034, arr035, arr036, arr037, arr038,
arr039, arr03a, arr03b, arr03c, arr03d, arr03e, arr03f,
arr040, arr041, arr042, arr043, arr044, arr045, arr046, arr047, arr048,
arr049, arr04a, arr04b, arr04c, arr04d, arr04e, arr04f,
arr050, arr051, arr052, arr053, arr054, arr055, arr056, arr057, arr058,
arr059, arr05a, arr05b, arr05c, arr05d, arr05e, arr05f,
arr060, arr061, arr062, arr063, arr064, arr065, arr066, arr067, arr068,
arr069, arr06a, arr06b, arr06c, arr06d, arr06e, arr06f,
arr070, arr071, arr072, arr073, arr074, arr075, arr076, arr077, arr078,
arr079, arr07a, arr07b, arr07c, arr07d, arr07e, arr07f,
arr080, arr081, arr082, arr083, arr084, arr085, arr086, arr087, arr088,
arr089, arr08a, arr08b, arr08c, arr08d, arr08e, arr08f,
arr090, arr091, arr092, arr093, arr094, arr095, arr096, arr097, arr098,
arr099, arr09a, arr09b, arr09c, arr09d, arr09e, arr09f,
arr0a0, arr0a1, arr0a2, arr0a3, arr0a4, arr0a5, arr0a6, arr0a7, arr0a8,
arr0a9, arr0aa, arr0ab, arr0ac, arr0ad, arr0ae, arr0af,
arr0b0, arr0b1, arr0b2, arr0b3, arr0b4, arr0b5, arr0b6, arr0b7, arr0b8,
arr0b9, arr0ba, arr0bb, arr0bc, arr0bd, arr0be, arr0bf,
arr0c0, arr0c1, arr0c2, arr0c3, arr0c4, arr0c5, arr0c6, arr0c7, arr0c8,
arr0c9, arr0ca, arr0cb, arr0cc, arr0cd, arr0ce, arr0cf,
arr0d0, arr0d1, arr0d2, arr0d3, arr0d4, arr0d5, arr0d6, arr0d7, arr0d8,
arr0d9, arr0da, arr0db, arr0dc, arr0dd, arr0de, arr0df,
arr0e0, arr0e1, arr0e2, arr0e3, arr0e4, arr0e5, arr0e6, arr0e7, arr0e8,
arr0e9, arr0ea, arr0eb, arr0ec, arr0ed, arr0ee, arr0ef,
arr0f0, arr0f1, arr0f2, arr0f3, arr0f4, arr0f5, arr0f6, arr0f7, arr0f8,
arr0f9, arr0fa, arr0fb, arr0fc, arr0fd, arr0fe, arr0ff,
arr100, arr101, arr102, arr103, arr104, arr105, arr106, arr107, arr108,
arr109, arr10a, arr10b, arr10c, arr10d, arr10e, arr10f,
arr110, arr111, arr112, arr113, arr114, arr115, arr116, arr117, arr118,
arr119, arr11a, arr11b, arr11c, arr11d, arr11e, arr11f,
arr120, arr121, arr122, arr123, arr124, arr125, arr126, arr127, arr128,
arr129, arr12a, arr12b, arr12c, arr12d, arr12e, arr12f,
arr130, arr131, arr132, arr133, arr134, arr135, arr136, arr137, arr138,
arr139, arr13a, arr13b, arr13c, arr13d, arr13e, arr13f,
arr140, arr141, arr142, arr143, arr144, arr145, arr146, arr147, arr148,
arr149, arr14a, arr14b, arr14c, arr14d, arr14e, arr14f,
arr150, arr151, arr152, arr153, arr154, arr155, arr156, arr157, arr158,
arr159, arr15a, arr15b, arr15c, arr15d, arr15e, arr15f,
arr160, arr161, arr162, arr163, arr164, arr165, arr166, arr167, arr168,
arr169, arr16a, arr16b, arr16c, arr16d, arr16e, arr16f,
arr170, arr171, arr172, arr173, arr174, arr175, arr176, arr177, arr178,
arr179, arr17a, arr17b, arr17c, arr17d, arr17e, arr17f,
arr180, arr181, arr182, arr183, arr184, arr185, arr186, arr187, arr188,
arr189, arr18a, arr18b, arr18c, arr18d, arr18e, arr18f,
arr190, arr191, arr192, arr193, arr194, arr195, arr196, arr197, arr198,
arr199, arr19a, arr19b, arr19c, arr19d, arr19e, arr19f,
arr1a0, arr1a1, arr1a2, arr1a3, arr1a4, arr1a5, arr1a6, arr1a7, arr1a8,
arr1a9, arr1aa, arr1ab, arr1ac, arr1ad, arr1ae, arr1af,
arr1b0, arr1b1, arr1b2, arr1b3, arr1b4, arr1b5, arr1b6, arr1b7, arr1b8,
arr1b9, arr1ba, arr1bb, arr1bc, arr1bd, arr1be, arr1bf
)
WITH t AS (SELECT '{null}'::Integer[] AS v)
SELECT
t000.v, t001.v, t002.v, t003.v, t004.v, t005.v, t006.v, t007.v, t008.v,
t009.v, t00a.v, t00b.v, t00c.v, t00d.v, t00e.v, t00f.v,
t010.v, t011.v, t012.v, t013.v, t014.v, t015.v, t016.v, t017.v, t018.v,
t019.v, t01a.v, t01b.v, t01c.v, t01d.v, t01e.v, t01f.v,
t020.v, t021.v, t022.v, t023.v, t024.v, t025.v, t026.v, t027.v, t028.v,
t029.v, t02a.v, t02b.v, t02c.v, t02d.v, t02e.v, t02f.v,
t030.v, t031.v, t032.v, t033.v, t034.v, t035.v, t036.v, t037.v, t038.v,
t039.v, t03a.v, t03b.v, t03c.v, t03d.v, t03e.v, t03f.v,
t040.v, t041.v, t042.v, t043.v, t044.v, t045.v, t046.v, t047.v, t048.v,
t049.v, t04a.v, t04b.v, t04c.v, t04d.v, t04e.v, t04f.v,
t050.v, t051.v, t052.v, t053.v, t054.v, t055.v, t056.v, t057.v, t058.v,
t059.v, t05a.v, t05b.v, t05c.v, t05d.v, t05e.v, t05f.v,
t060.v, t061.v, t062.v, t063.v, t064.v, t065.v, t066.v, t067.v, t068.v,
t069.v, t06a.v, t06b.v, t06c.v, t06d.v, t06e.v, t06f.v,
t070.v, t071.v, t072.v, t073.v, t074.v, t075.v, t076.v, t077.v, t078.v,
t079.v, t07a.v, t07b.v, t07c.v, t07d.v, t07e.v, t07f.v,
t080.v, t081.v, t082.v, t083.v, t084.v, t085.v, t086.v, t087.v, t088.v,
t089.v, t08a.v, t08b.v, t08c.v, t08d.v, t08e.v, t08f.v,
t090.v, t091.v, t092.v, t093.v, t094.v, t095.v, t096.v, t097.v, t098.v,
t099.v, t09a.v, t09b.v, t09c.v, t09d.v, t09e.v, t09f.v,
t0a0.v, t0a1.v, t0a2.v, t0a3.v, t0a4.v, t0a5.v, t0a6.v, t0a7.v, t0a8.v,
t0a9.v, t0aa.v, t0ab.v, t0ac.v, t0ad.v, t0ae.v, t0af.v,
t0b0.v, t0b1.v, t0b2.v, t0b3.v, t0b4.v, t0b5.v, t0b6.v, t0b7.v, t0b8.v,
t0b9.v, t0ba.v, t0bb.v, t0bc.v, t0bd.v, t0be.v, t0bf.v,
t0c0.v, t0c1.v, t0c2.v, t0c3.v, t0c4.v, t0c5.v, t0c6.v, t0c7.v, t0c8.v,
t0c9.v, t0ca.v, t0cb.v, t0cc.v, t0cd.v, t0ce.v, t0cf.v,
t0d0.v, t0d1.v, t0d2.v, t0d3.v, t0d4.v, t0d5.v, t0d6.v, t0d7.v, t0d8.v,
t0d9.v, t0da.v, t0db.v, t0dc.v, t0dd.v, t0de.v, t0df.v,
t0e0.v, t0e1.v, t0e2.v, t0e3.v, t0e4.v, t0e5.v, t0e6.v, t0e7.v, t0e8.v,
t0e9.v, t0ea.v, t0eb.v, t0ec.v, t0ed.v, t0ee.v, t0ef.v,
t0f0.v, t0f1.v, t0f2.v, t0f3.v, t0f4.v, t0f5.v, t0f6.v, t0f7.v, t0f8.v,
t0f9.v, t0fa.v, t0fb.v, t0fc.v, t0fd.v, t0fe.v, t0ff.v,
t100.v, t101.v, t102.v, t103.v, t104.v, t105.v, t106.v, t107.v, t108.v,
t109.v, t10a.v, t10b.v, t10c.v, t10d.v, t10e.v, t10f.v,
t110.v, t111.v, t112.v, t113.v, t114.v, t115.v, t116.v, t117.v, t118.v,
t119.v, t11a.v, t11b.v, t11c.v, t11d.v, t11e.v, t11f.v,
t120.v, t121.v, t122.v, t123.v, t124.v, t125.v, t126.v, t127.v, t128.v,
t129.v, t12a.v, t12b.v, t12c.v, t12d.v, t12e.v, t12f.v,
t130.v, t131.v, t132.v, t133.v, t134.v, t135.v, t136.v, t137.v, t138.v,
t139.v, t13a.v, t13b.v, t13c.v, t13d.v, t13e.v, t13f.v,
t140.v, t141.v, t142.v, t143.v, t144.v, t145.v, t146.v, t147.v, t148.v,
t149.v, t14a.v, t14b.v, t14c.v, t14d.v, t14e.v, t14f.v,
t150.v, t151.v, t152.v, t153.v, t154.v, t155.v, t156.v, t157.v, t158.v,
t159.v, t15a.v, t15b.v, t15c.v, t15d.v, t15e.v, t15f.v,
t160.v, t161.v, t162.v, t163.v, t164.v, t165.v, t166.v, t167.v, t168.v,
t169.v, t16a.v, t16b.v, t16c.v, t16d.v, t16e.v, t16f.v,
t170.v, t171.v, t172.v, t173.v, t174.v, t175.v, t176.v, t177.v, t178.v,
t179.v, t17a.v, t17b.v, t17c.v, t17d.v, t17e.v, t17f.v,
t180.v, t181.v, t182.v, t183.v, t184.v, t185.v, t186.v, t187.v, t188.v,
t189.v, t18a.v, t18b.v, t18c.v, t18d.v, t18e.v, t18f.v,
t190.v, t191.v, t192.v, t193.v, t194.v, t195.v, t196.v, t197.v, t198.v,
t199.v, t19a.v, t19b.v, t19c.v, t19d.v, t19e.v, t19f.v,
t1a0.v, t1a1.v, t1a2.v, t1a3.v, t1a4.v, t1a5.v, t1a6.v, t1a7.v, t1a8.v,
t1a9.v, t1aa.v, t1ab.v, t1ac.v, t1ad.v, t1ae.v, t1af.v,
t1b0.v, t1b1.v, t1b2.v, t1b3.v, t1b4.v, t1b5.v, t1b6.v, t1b7.v, t1b8.v,
t1b9.v, t1ba.v, t1bb.v, t1bc.v, t1bd.v, t1be.v, t1bf.v
FROM
generate_series(1, 1024*1024),
t t000, t t001, t t002, t t003, t t004, t t005, t t006, t t007, t t008,
t t009, t t00a, t t00b, t t00c, t t00d, t t00e, t t00f,
t t010, t t011, t t012, t t013, t t014, t t015, t t016, t t017, t t018,
t t019, t t01a, t t01b, t t01c, t t01d, t t01e, t t01f,
t t020, t t021, t t022, t t023, t t024, t t025, t t026, t t027, t t028,
t t029, t t02a, t t02b, t t02c, t t02d, t t02e, t t02f,
t t030, t t031, t t032, t t033, t t034, t t035, t t036, t t037, t t038,
t t039, t t03a, t t03b, t t03c, t t03d, t t03e, t t03f,
t t040, t t041, t t042, t t043, t t044, t t045, t t046, t t047, t t048,
t t049, t t04a, t t04b, t t04c, t t04d, t t04e, t t04f,
t t050, t t051, t t052, t t053, t t054, t t055, t t056, t t057, t t058,
t t059, t t05a, t t05b, t t05c, t t05d, t t05e, t t05f,
t t060, t t061, t t062, t t063, t t064, t t065, t t066, t t067, t t068,
t t069, t t06a, t t06b, t t06c, t t06d, t t06e, t t06f,
t t070, t t071, t t072, t t073, t t074, t t075, t t076, t t077, t t078,
t t079, t t07a, t t07b, t t07c, t t07d, t t07e, t t07f,
t t080, t t081, t t082, t t083, t t084, t t085, t t086, t t087, t t088,
t t089, t t08a, t t08b, t t08c, t t08d, t t08e, t t08f,
t t090, t t091, t t092, t t093, t t094, t t095, t t096, t t097, t t098,
t t099, t t09a, t t09b, t t09c, t t09d, t t09e, t t09f,
t t0a0, t t0a1, t t0a2, t t0a3, t t0a4, t t0a5, t t0a6, t t0a7, t t0a8,
t t0a9, t t0aa, t t0ab, t t0ac, t t0ad, t t0ae, t t0af,
t t0b0, t t0b1, t t0b2, t t0b3, t t0b4, t t0b5, t t0b6, t t0b7, t t0b8,
t t0b9, t t0ba, t t0bb, t t0bc, t t0bd, t t0be, t t0bf,
t t0c0, t t0c1, t t0c2, t t0c3, t t0c4, t t0c5, t t0c6, t t0c7, t t0c8,
t t0c9, t t0ca, t t0cb, t t0cc, t t0cd, t t0ce, t t0cf,
t t0d0, t t0d1, t t0d2, t t0d3, t t0d4, t t0d5, t t0d6, t t0d7, t t0d8,
t t0d9, t t0da, t t0db, t t0dc, t t0dd, t t0de, t t0df,
t t0e0, t t0e1, t t0e2, t t0e3, t t0e4, t t0e5, t t0e6, t t0e7, t t0e8,
t t0e9, t t0ea, t t0eb, t t0ec, t t0ed, t t0ee, t t0ef,
t t0f0, t t0f1, t t0f2, t t0f3, t t0f4, t t0f5, t t0f6, t t0f7, t t0f8,
t t0f9, t t0fa, t t0fb, t t0fc, t t0fd, t t0fe, t t0ff,
t t100, t t101, t t102, t t103, t t104, t t105, t t106, t t107, t t108,
t t109, t t10a, t t10b, t t10c, t t10d, t t10e, t t10f,
t t110, t t111, t t112, t t113, t t114, t t115, t t116, t t117, t t118,
t t119, t t11a, t t11b, t t11c, t t11d, t t11e, t t11f,
t t120, t t121, t t122, t t123, t t124, t t125, t t126, t t127, t t128,
t t129, t t12a, t t12b, t t12c, t t12d, t t12e, t t12f,
t t130, t t131, t t132, t t133, t t134, t t135, t t136, t t137, t t138,
t t139, t t13a, t t13b, t t13c, t t13d, t t13e, t t13f,
t t140, t t141, t t142, t t143, t t144, t t145, t t146, t t147, t t148,
t t149, t t14a, t t14b, t t14c, t t14d, t t14e, t t14f,
t t150, t t151, t t152, t t153, t t154, t t155, t t156, t t157, t t158,
t t159, t t15a, t t15b, t t15c, t t15d, t t15e, t t15f,
t t160, t t161, t t162, t t163, t t164, t t165, t t166, t t167, t t168,
t t169, t t16a, t t16b, t t16c, t t16d, t t16e, t t16f,
t t170, t t171, t t172, t t173, t t174, t t175, t t176, t t177, t t178,
t t179, t t17a, t t17b, t t17c, t t17d, t t17e, t t17f,
t t180, t t181, t t182, t t183, t t184, t t185, t t186, t t187, t t188,
t t189, t t18a, t t18b, t t18c, t t18d, t t18e, t t18f,
t t190, t t191, t t192, t t193, t t194, t t195, t t196, t t197, t t198,
t t199, t t19a, t t19b, t t19c, t t19d, t t19e, t t19f,
t t1a0, t t1a1, t t1a2, t t1a3, t t1a4, t t1a5, t t1a6, t t1a7, t t1a8,
t t1a9, t t1aa, t t1ab, t t1ac, t t1ad, t t1ae, t t1af,
t t1b0, t t1b1, t t1b2, t t1b3, t t1b4, t t1b5, t t1b6, t t1b7, t t1b8,
t t1b9, t t1ba, t t1bb, t t1bc, t t1bd, t t1be, t t1bf
;
SELECT '1 Mi entries written'::text;
/*
* We iterate 10 times the same insertion as above
*/
INSERT INTO test (
arr000, arr001, arr002, arr003, arr004, arr005, arr006, arr007, arr008,
arr009, arr00a, arr00b, arr00c, arr00d, arr00e, arr00f,
arr010, arr011, arr012, arr013, arr014, arr015, arr016, arr017, arr018,
arr019, arr01a, arr01b, arr01c, arr01d, arr01e, arr01f,
arr020, arr021, arr022, arr023, arr024, arr025, arr026, arr027, arr028,
arr029, arr02a, arr02b, arr02c, arr02d, arr02e, arr02f,
arr030, arr031, arr032, arr033, arr034, arr035, arr036, arr037, arr038,
arr039, arr03a, arr03b, arr03c, arr03d, arr03e, arr03f,
arr040, arr041, arr042, arr043, arr044, arr045, arr046, arr047, arr048,
arr049, arr04a, arr04b, arr04c, arr04d, arr04e, arr04f,
arr050, arr051, arr052, arr053, arr054, arr055, arr056, arr057, arr058,
arr059, arr05a, arr05b, arr05c, arr05d, arr05e, arr05f,
arr060, arr061, arr062, arr063, arr064, arr065, arr066, arr067, arr068,
arr069, arr06a, arr06b, arr06c, arr06d, arr06e, arr06f,
arr070, arr071, arr072, arr073, arr074, arr075, arr076, arr077, arr078,
arr079, arr07a, arr07b, arr07c, arr07d, arr07e, arr07f,
arr080, arr081, arr082, arr083, arr084, arr085, arr086, arr087, arr088,
arr089, arr08a, arr08b, arr08c, arr08d, arr08e, arr08f,
arr090, arr091, arr092, arr093, arr094, arr095, arr096, arr097, arr098,
arr099, arr09a, arr09b, arr09c, arr09d, arr09e, arr09f,
arr0a0, arr0a1, arr0a2, arr0a3, arr0a4, arr0a5, arr0a6, arr0a7, arr0a8,
arr0a9, arr0aa, arr0ab, arr0ac, arr0ad, arr0ae, arr0af,
arr0b0, arr0b1, arr0b2, arr0b3, arr0b4, arr0b5, arr0b6, arr0b7, arr0b8,
arr0b9, arr0ba, arr0bb, arr0bc, arr0bd, arr0be, arr0bf,
arr0c0, arr0c1, arr0c2, arr0c3, arr0c4, arr0c5, arr0c6, arr0c7, arr0c8,
arr0c9, arr0ca, arr0cb, arr0cc, arr0cd, arr0ce, arr0cf,
arr0d0, arr0d1, arr0d2, arr0d3, arr0d4, arr0d5, arr0d6, arr0d7, arr0d8,
arr0d9, arr0da, arr0db, arr0dc, arr0dd, arr0de, arr0df,
arr0e0, arr0e1, arr0e2, arr0e3, arr0e4, arr0e5, arr0e6, arr0e7, arr0e8,
arr0e9, arr0ea, arr0eb, arr0ec, arr0ed, arr0ee, arr0ef,
arr0f0, arr0f1, arr0f2, arr0f3, arr0f4, arr0f5, arr0f6, arr0f7, arr0f8,
arr0f9, arr0fa, arr0fb, arr0fc, arr0fd, arr0fe, arr0ff,
arr100, arr101, arr102, arr103, arr104, arr105, arr106, arr107, arr108,
arr109, arr10a, arr10b, arr10c, arr10d, arr10e, arr10f,
arr110, arr111, arr112, arr113, arr114, arr115, arr116, arr117, arr118,
arr119, arr11a, arr11b, arr11c, arr11d, arr11e, arr11f,
arr120, arr121, arr122, arr123, arr124, arr125, arr126, arr127, arr128,
arr129, arr12a, arr12b, arr12c, arr12d, arr12e, arr12f,
arr130, arr131, arr132, arr133, arr134, arr135, arr136, arr137, arr138,
arr139, arr13a, arr13b, arr13c, arr13d, arr13e, arr13f,
arr140, arr141, arr142, arr143, arr144, arr145, arr146, arr147, arr148,
arr149, arr14a, arr14b, arr14c, arr14d, arr14e, arr14f,
arr150, arr151, arr152, arr153, arr154, arr155, arr156, arr157, arr158,
arr159, arr15a, arr15b, arr15c, arr15d, arr15e, arr15f,
arr160, arr161, arr162, arr163, arr164, arr165, arr166, arr167, arr168,
arr169, arr16a, arr16b, arr16c, arr16d, arr16e, arr16f,
arr170, arr171, arr172, arr173, arr174, arr175, arr176, arr177, arr178,
arr179, arr17a, arr17b, arr17c, arr17d, arr17e, arr17f,
arr180, arr181, arr182, arr183, arr184, arr185, arr186, arr187, arr188,
arr189, arr18a, arr18b, arr18c, arr18d, arr18e, arr18f,
arr190, arr191, arr192, arr193, arr194, arr195, arr196, arr197, arr198,
arr199, arr19a, arr19b, arr19c, arr19d, arr19e, arr19f,
arr1a0, arr1a1, arr1a2, arr1a3, arr1a4, arr1a5, arr1a6, arr1a7, arr1a8,
arr1a9, arr1aa, arr1ab, arr1ac, arr1ad, arr1ae, arr1af,
arr1b0, arr1b1, arr1b2, arr1b3, arr1b4, arr1b5, arr1b6, arr1b7, arr1b8,
arr1b9, arr1ba, arr1bb, arr1bc, arr1bd, arr1be, arr1bf
)
WITH t AS (SELECT '{null}'::Integer[] AS v)
SELECT
t000.v, t001.v, t002.v, t003.v, t004.v, t005.v, t006.v, t007.v, t008.v,
t009.v, t00a.v, t00b.v, t00c.v, t00d.v, t00e.v, t00f.v,
t010.v, t011.v, t012.v, t013.v, t014.v, t015.v, t016.v, t017.v, t018.v,
t019.v, t01a.v, t01b.v, t01c.v, t01d.v, t01e.v, t01f.v,
t020.v, t021.v, t022.v, t023.v, t024.v, t025.v, t026.v, t027.v, t028.v,
t029.v, t02a.v, t02b.v, t02c.v, t02d.v, t02e.v, t02f.v,
t030.v, t031.v, t032.v, t033.v, t034.v, t035.v, t036.v, t037.v, t038.v,
t039.v, t03a.v, t03b.v, t03c.v, t03d.v, t03e.v, t03f.v,
t040.v, t041.v, t042.v, t043.v, t044.v, t045.v, t046.v, t047.v, t048.v,
t049.v, t04a.v, t04b.v, t04c.v, t04d.v, t04e.v, t04f.v,
t050.v, t051.v, t052.v, t053.v, t054.v, t055.v, t056.v, t057.v, t058.v,
t059.v, t05a.v, t05b.v, t05c.v, t05d.v, t05e.v, t05f.v,
t060.v, t061.v, t062.v, t063.v, t064.v, t065.v, t066.v, t067.v, t068.v,
t069.v, t06a.v, t06b.v, t06c.v, t06d.v, t06e.v, t06f.v,
t070.v, t071.v, t072.v, t073.v, t074.v, t075.v, t076.v, t077.v, t078.v,
t079.v, t07a.v, t07b.v, t07c.v, t07d.v, t07e.v, t07f.v,
t080.v, t081.v, t082.v, t083.v, t084.v, t085.v, t086.v, t087.v, t088.v,
t089.v, t08a.v, t08b.v, t08c.v, t08d.v, t08e.v, t08f.v,
t090.v, t091.v, t092.v, t093.v, t094.v, t095.v, t096.v, t097.v, t098.v,
t099.v, t09a.v, t09b.v, t09c.v, t09d.v, t09e.v, t09f.v,
t0a0.v, t0a1.v, t0a2.v, t0a3.v, t0a4.v, t0a5.v, t0a6.v, t0a7.v, t0a8.v,
t0a9.v, t0aa.v, t0ab.v, t0ac.v, t0ad.v, t0ae.v, t0af.v,
t0b0.v, t0b1.v, t0b2.v, t0b3.v, t0b4.v, t0b5.v, t0b6.v, t0b7.v, t0b8.v,
t0b9.v, t0ba.v, t0bb.v, t0bc.v, t0bd.v, t0be.v, t0bf.v,
t0c0.v, t0c1.v, t0c2.v, t0c3.v, t0c4.v, t0c5.v, t0c6.v, t0c7.v, t0c8.v,
t0c9.v, t0ca.v, t0cb.v, t0cc.v, t0cd.v, t0ce.v, t0cf.v,
t0d0.v, t0d1.v, t0d2.v, t0d3.v, t0d4.v, t0d5.v, t0d6.v, t0d7.v, t0d8.v,
t0d9.v, t0da.v, t0db.v, t0dc.v, t0dd.v, t0de.v, t0df.v,
t0e0.v, t0e1.v, t0e2.v, t0e3.v, t0e4.v, t0e5.v, t0e6.v, t0e7.v, t0e8.v,
t0e9.v, t0ea.v, t0eb.v, t0ec.v, t0ed.v, t0ee.v, t0ef.v,
t0f0.v, t0f1.v, t0f2.v, t0f3.v, t0f4.v, t0f5.v, t0f6.v, t0f7.v, t0f8.v,
t0f9.v, t0fa.v, t0fb.v, t0fc.v, t0fd.v, t0fe.v, t0ff.v,
t100.v, t101.v, t102.v, t103.v, t104.v, t105.v, t106.v, t107.v, t108.v,
t109.v, t10a.v, t10b.v, t10c.v, t10d.v, t10e.v, t10f.v,
t110.v, t111.v, t112.v, t113.v, t114.v, t115.v, t116.v, t117.v, t118.v,
t119.v, t11a.v, t11b.v, t11c.v, t11d.v, t11e.v, t11f.v,
t120.v, t121.v, t122.v, t123.v, t124.v, t125.v, t126.v, t127.v, t128.v,
t129.v, t12a.v, t12b.v, t12c.v, t12d.v, t12e.v, t12f.v,
t130.v, t131.v, t132.v, t133.v, t134.v, t135.v, t136.v, t137.v, t138.v,
t139.v, t13a.v, t13b.v, t13c.v, t13d.v, t13e.v, t13f.v,
t140.v, t141.v, t142.v, t143.v, t144.v, t145.v, t146.v, t147.v, t148.v,
t149.v, t14a.v, t14b.v, t14c.v, t14d.v, t14e.v, t14f.v,
t150.v, t151.v, t152.v, t153.v, t154.v, t155.v, t156.v, t157.v, t158.v,
t159.v, t15a.v, t15b.v, t15c.v, t15d.v, t15e.v, t15f.v,
t160.v, t161.v, t162.v, t163.v, t164.v, t165.v, t166.v, t167.v, t168.v,
t169.v, t16a.v, t16b.v, t16c.v, t16d.v, t16e.v, t16f.v,
t170.v, t171.v, t172.v, t173.v, t174.v, t175.v, t176.v, t177.v, t178.v,
t179.v, t17a.v, t17b.v, t17c.v, t17d.v, t17e.v, t17f.v,
t180.v, t181.v, t182.v, t183.v, t184.v, t185.v, t186.v, t187.v, t188.v,
t189.v, t18a.v, t18b.v, t18c.v, t18d.v, t18e.v, t18f.v,
t190.v, t191.v, t192.v, t193.v, t194.v, t195.v, t196.v, t197.v, t198.v,
t199.v, t19a.v, t19b.v, t19c.v, t19d.v, t19e.v, t19f.v,
t1a0.v, t1a1.v, t1a2.v, t1a3.v, t1a4.v, t1a5.v, t1a6.v, t1a7.v, t1a8.v,
t1a9.v, t1aa.v, t1ab.v, t1ac.v, t1ad.v, t1ae.v, t1af.v,
t1b0.v, t1b1.v, t1b2.v, t1b3.v, t1b4.v, t1b5.v, t1b6.v, t1b7.v, t1b8.v,
t1b9.v, t1ba.v, t1bb.v, t1bc.v, t1bd.v, t1be.v, t1bf.v
FROM
generate_series(1, 1024*1024),
t t000, t t001, t t002, t t003, t t004, t t005, t t006, t t007, t t008,
t t009, t t00a, t t00b, t t00c, t t00d, t t00e, t t00f,
t t010, t t011, t t012, t t013, t t014, t t015, t t016, t t017, t t018,
t t019, t t01a, t t01b, t t01c, t t01d, t t01e, t t01f,
t t020, t t021, t t022, t t023, t t024, t t025, t t026, t t027, t t028,
t t029, t t02a, t t02b, t t02c, t t02d, t t02e, t t02f,
t t030, t t031, t t032, t t033, t t034, t t035, t t036, t t037, t t038,
t t039, t t03a, t t03b, t t03c, t t03d, t t03e, t t03f,
t t040, t t041, t t042, t t043, t t044, t t045, t t046, t t047, t t048,
t t049, t t04a, t t04b, t t04c, t t04d, t t04e, t t04f,
t t050, t t051, t t052, t t053, t t054, t t055, t t056, t t057, t t058,
t t059, t t05a, t t05b, t t05c, t t05d, t t05e, t t05f,
t t060, t t061, t t062, t t063, t t064, t t065, t t066, t t067, t t068,
t t069, t t06a, t t06b, t t06c, t t06d, t t06e, t t06f,
t t070, t t071, t t072, t t073, t t074, t t075, t t076, t t077, t t078,
t t079, t t07a, t t07b, t t07c, t t07d, t t07e, t t07f,
t t080, t t081, t t082, t t083, t t084, t t085, t t086, t t087, t t088,
t t089, t t08a, t t08b, t t08c, t t08d, t t08e, t t08f,
t t090, t t091, t t092, t t093, t t094, t t095, t t096, t t097, t t098,
t t099, t t09a, t t09b, t t09c, t t09d, t t09e, t t09f,
t t0a0, t t0a1, t t0a2, t t0a3, t t0a4, t t0a5, t t0a6, t t0a7, t t0a8,
t t0a9, t t0aa, t t0ab, t t0ac, t t0ad, t t0ae, t t0af,
t t0b0, t t0b1, t t0b2, t t0b3, t t0b4, t t0b5, t t0b6, t t0b7, t t0b8,
t t0b9, t t0ba, t t0bb, t t0bc, t t0bd, t t0be, t t0bf,
t t0c0, t t0c1, t t0c2, t t0c3, t t0c4, t t0c5, t t0c6, t t0c7, t t0c8,
t t0c9, t t0ca, t t0cb, t t0cc, t t0cd, t t0ce, t t0cf,
t t0d0, t t0d1, t t0d2, t t0d3, t t0d4, t t0d5, t t0d6, t t0d7, t t0d8,
t t0d9, t t0da, t t0db, t t0dc, t t0dd, t t0de, t t0df,
t t0e0, t t0e1, t t0e2, t t0e3, t t0e4, t t0e5, t t0e6, t t0e7, t t0e8,
t t0e9, t t0ea, t t0eb, t t0ec, t t0ed, t t0ee, t t0ef,
t t0f0, t t0f1, t t0f2, t t0f3, t t0f4, t t0f5, t t0f6, t t0f7, t t0f8,
t t0f9, t t0fa, t t0fb, t t0fc, t t0fd, t t0fe, t t0ff,
t t100, t t101, t t102, t t103, t t104, t t105, t t106, t t107, t t108,
t t109, t t10a, t t10b, t t10c, t t10d, t t10e, t t10f,
t t110, t t111, t t112, t t113, t t114, t t115, t t116, t t117, t t118,
t t119, t t11a, t t11b, t t11c, t t11d, t t11e, t t11f,
t t120, t t121, t t122, t t123, t t124, t t125, t t126, t t127, t t128,
t t129, t t12a, t t12b, t t12c, t t12d, t t12e, t t12f,
t t130, t t131, t t132, t t133, t t134, t t135, t t136, t t137, t t138,
t t139, t t13a, t t13b, t t13c, t t13d, t t13e, t t13f,
t t140, t t141, t t142, t t143, t t144, t t145, t t146, t t147, t t148,
t t149, t t14a, t t14b, t t14c, t t14d, t t14e, t t14f,
t t150, t t151, t t152, t t153, t t154, t t155, t t156, t t157, t t158,
t t159, t t15a, t t15b, t t15c, t t15d, t t15e, t t15f,
t t160, t t161, t t162, t t163, t t164, t t165, t t166, t t167, t t168,
t t169, t t16a, t t16b, t t16c, t t16d, t t16e, t t16f,
t t170, t t171, t t172, t t173, t t174, t t175, t t176, t t177, t t178,
t t179, t t17a, t t17b, t t17c, t t17d, t t17e, t t17f,
t t180, t t181, t t182, t t183, t t184, t t185, t t186, t t187, t t188,
t t189, t t18a, t t18b, t t18c, t t18d, t t18e, t t18f,
t t190, t t191, t t192, t t193, t t194, t t195, t t196, t t197, t t198,
t t199, t t19a, t t19b, t t19c, t t19d, t t19e, t t19f,
t t1a0, t t1a1, t t1a2, t t1a3, t t1a4, t t1a5, t t1a6, t t1a7, t t1a8,
t t1a9, t t1aa, t t1ab, t t1ac, t t1ad, t t1ae, t t1af,
t t1b0, t t1b1, t t1b2, t t1b3, t t1b4, t t1b5, t t1b6, t t1b7, t t1b8,
t t1b9, t t1ba, t t1bb, t t1bc, t t1bd, t t1be, t t1bf
;
SELECT '2 Mi entries written'::text;
INSERT INTO test (
arr000, arr001, arr002, arr003, arr004, arr005, arr006, arr007, arr008,
arr009, arr00a, arr00b, arr00c, arr00d, arr00e, arr00f,
arr010, arr011, arr012, arr013, arr014, arr015, arr016, arr017, arr018,
arr019, arr01a, arr01b, arr01c, arr01d, arr01e, arr01f,
arr020, arr021, arr022, arr023, arr024, arr025, arr026, arr027, arr028,
arr029, arr02a, arr02b, arr02c, arr02d, arr02e, arr02f,
arr030, arr031, arr032, arr033, arr034, arr035, arr036, arr037, arr038,
arr039, arr03a, arr03b, arr03c, arr03d, arr03e, arr03f,
arr040, arr041, arr042, arr043, arr044, arr045, arr046, arr047, arr048,
arr049, arr04a, arr04b, arr04c, arr04d, arr04e, arr04f,
arr050, arr051, arr052, arr053, arr054, arr055, arr056, arr057, arr058,
arr059, arr05a, arr05b, arr05c, arr05d, arr05e, arr05f,
arr060, arr061, arr062, arr063, arr064, arr065, arr066, arr067, arr068,
arr069, arr06a, arr06b, arr06c, arr06d, arr06e, arr06f,
arr070, arr071, arr072, arr073, arr074, arr075, arr076, arr077, arr078,
arr079, arr07a, arr07b, arr07c, arr07d, arr07e, arr07f,
arr080, arr081, arr082, arr083, arr084, arr085, arr086, arr087, arr088,
arr089, arr08a, arr08b, arr08c, arr08d, arr08e, arr08f,
arr090, arr091, arr092, arr093, arr094, arr095, arr096, arr097, arr098,
arr099, arr09a, arr09b, arr09c, arr09d, arr09e, arr09f,
arr0a0, arr0a1, arr0a2, arr0a3, arr0a4, arr0a5, arr0a6, arr0a7, arr0a8,
arr0a9, arr0aa, arr0ab, arr0ac, arr0ad, arr0ae, arr0af,
arr0b0, arr0b1, arr0b2, arr0b3, arr0b4, arr0b5, arr0b6, arr0b7, arr0b8,
arr0b9, arr0ba, arr0bb, arr0bc, arr0bd, arr0be, arr0bf,
arr0c0, arr0c1, arr0c2, arr0c3, arr0c4, arr0c5, arr0c6, arr0c7, arr0c8,
arr0c9, arr0ca, arr0cb, arr0cc, arr0cd, arr0ce, arr0cf,
arr0d0, arr0d1, arr0d2, arr0d3, arr0d4, arr0d5, arr0d6, arr0d7, arr0d8,
arr0d9, arr0da, arr0db, arr0dc, arr0dd, arr0de, arr0df,
arr0e0, arr0e1, arr0e2, arr0e3, arr0e4, arr0e5, arr0e6, arr0e7, arr0e8,
arr0e9, arr0ea, arr0eb, arr0ec, arr0ed, arr0ee, arr0ef,
arr0f0, arr0f1, arr0f2, arr0f3, arr0f4, arr0f5, arr0f6, arr0f7, arr0f8,
arr0f9, arr0fa, arr0fb, arr0fc, arr0fd, arr0fe, arr0ff,
arr100, arr101, arr102, arr103, arr104, arr105, arr106, arr107, arr108,
arr109, arr10a, arr10b, arr10c, arr10d, arr10e, arr10f,
arr110, arr111, arr112, arr113, arr114, arr115, arr116, arr117, arr118,
arr119, arr11a, arr11b, arr11c, arr11d, arr11e, arr11f,
arr120, arr121, arr122, arr123, arr124, arr125, arr126, arr127, arr128,
arr129, arr12a, arr12b, arr12c, arr12d, arr12e, arr12f,
arr130, arr131, arr132, arr133, arr134, arr135, arr136, arr137, arr138,
arr139, arr13a, arr13b, arr13c, arr13d, arr13e, arr13f,
arr140, arr141, arr142, arr143, arr144, arr145, arr146, arr147, arr148,
arr149, arr14a, arr14b, arr14c, arr14d, arr14e, arr14f,
arr150, arr151, arr152, arr153, arr154, arr155, arr156, arr157, arr158,
arr159, arr15a, arr15b, arr15c, arr15d, arr15e, arr15f,
arr160, arr161, arr162, arr163, arr164, arr165, arr166, arr167, arr168,
arr169, arr16a, arr16b, arr16c, arr16d, arr16e, arr16f,
arr170, arr171, arr172, arr173, arr174, arr175, arr176, arr177, arr178,
arr179, arr17a, arr17b, arr17c, arr17d, arr17e, arr17f,
arr180, arr181, arr182, arr183, arr184, arr185, arr186, arr187, arr188,
arr189, arr18a, arr18b, arr18c, arr18d, arr18e, arr18f,
arr190, arr191, arr192, arr193, arr194, arr195, arr196, arr197, arr198,
arr199, arr19a, arr19b, arr19c, arr19d, arr19e, arr19f,
arr1a0, arr1a1, arr1a2, arr1a3, arr1a4, arr1a5, arr1a6, arr1a7, arr1a8,
arr1a9, arr1aa, arr1ab, arr1ac, arr1ad, arr1ae, arr1af,
arr1b0, arr1b1, arr1b2, arr1b3, arr1b4, arr1b5, arr1b6, arr1b7, arr1b8,
arr1b9, arr1ba, arr1bb, arr1bc, arr1bd, arr1be, arr1bf
)
WITH t AS (SELECT '{null}'::Integer[] AS v)
SELECT
t000.v, t001.v, t002.v, t003.v, t004.v, t005.v, t006.v, t007.v, t008.v,
t009.v, t00a.v, t00b.v, t00c.v, t00d.v, t00e.v, t00f.v,
t010.v, t011.v, t012.v, t013.v, t014.v, t015.v, t016.v, t017.v, t018.v,
t019.v, t01a.v, t01b.v, t01c.v, t01d.v, t01e.v, t01f.v,
t020.v, t021.v, t022.v, t023.v, t024.v, t025.v, t026.v, t027.v, t028.v,
t029.v, t02a.v, t02b.v, t02c.v, t02d.v, t02e.v, t02f.v,
t030.v, t031.v, t032.v, t033.v, t034.v, t035.v, t036.v, t037.v, t038.v,
t039.v, t03a.v, t03b.v, t03c.v, t03d.v, t03e.v, t03f.v,
t040.v, t041.v, t042.v, t043.v, t044.v, t045.v, t046.v, t047.v, t048.v,
t049.v, t04a.v, t04b.v, t04c.v, t04d.v, t04e.v, t04f.v,
t050.v, t051.v, t052.v, t053.v, t054.v, t055.v, t056.v, t057.v, t058.v,
t059.v, t05a.v, t05b.v, t05c.v, t05d.v, t05e.v, t05f.v,
t060.v, t061.v, t062.v, t063.v, t064.v, t065.v, t066.v, t067.v, t068.v,
t069.v, t06a.v, t06b.v, t06c.v, t06d.v, t06e.v, t06f.v,
t070.v, t071.v, t072.v, t073.v, t074.v, t075.v, t076.v, t077.v, t078.v,
t079.v, t07a.v, t07b.v, t07c.v, t07d.v, t07e.v, t07f.v,
t080.v, t081.v, t082.v, t083.v, t084.v, t085.v, t086.v, t087.v, t088.v,
t089.v, t08a.v, t08b.v, t08c.v, t08d.v, t08e.v, t08f.v,
t090.v, t091.v, t092.v, t093.v, t094.v, t095.v, t096.v, t097.v, t098.v,
t099.v, t09a.v, t09b.v, t09c.v, t09d.v, t09e.v, t09f.v,
t0a0.v, t0a1.v, t0a2.v, t0a3.v, t0a4.v, t0a5.v, t0a6.v, t0a7.v, t0a8.v,
t0a9.v, t0aa.v, t0ab.v, t0ac.v, t0ad.v, t0ae.v, t0af.v,
t0b0.v, t0b1.v, t0b2.v, t0b3.v, t0b4.v, t0b5.v, t0b6.v, t0b7.v, t0b8.v,
t0b9.v, t0ba.v, t0bb.v, t0bc.v, t0bd.v, t0be.v, t0bf.v,
t0c0.v, t0c1.v, t0c2.v, t0c3.v, t0c4.v, t0c5.v, t0c6.v, t0c7.v, t0c8.v,
t0c9.v, t0ca.v, t0cb.v, t0cc.v, t0cd.v, t0ce.v, t0cf.v,
t0d0.v, t0d1.v, t0d2.v, t0d3.v, t0d4.v, t0d5.v, t0d6.v, t0d7.v, t0d8.v,
t0d9.v, t0da.v, t0db.v, t0dc.v, t0dd.v, t0de.v, t0df.v,
t0e0.v, t0e1.v, t0e2.v, t0e3.v, t0e4.v, t0e5.v, t0e6.v, t0e7.v, t0e8.v,
t0e9.v, t0ea.v, t0eb.v, t0ec.v, t0ed.v, t0ee.v, t0ef.v,
t0f0.v, t0f1.v, t0f2.v, t0f3.v, t0f4.v, t0f5.v, t0f6.v, t0f7.v, t0f8.v,
t0f9.v, t0fa.v, t0fb.v, t0fc.v, t0fd.v, t0fe.v, t0ff.v,
t100.v, t101.v, t102.v, t103.v, t104.v, t105.v, t106.v, t107.v, t108.v,
t109.v, t10a.v, t10b.v, t10c.v, t10d.v, t10e.v, t10f.v,
t110.v, t111.v, t112.v, t113.v, t114.v, t115.v, t116.v, t117.v, t118.v,
t119.v, t11a.v, t11b.v, t11c.v, t11d.v, t11e.v, t11f.v,
t120.v, t121.v, t122.v, t123.v, t124.v, t125.v, t126.v, t127.v, t128.v,
t129.v, t12a.v, t12b.v, t12c.v, t12d.v, t12e.v, t12f.v,
t130.v, t131.v, t132.v, t133.v, t134.v, t135.v, t136.v, t137.v, t138.v,
t139.v, t13a.v, t13b.v, t13c.v, t13d.v, t13e.v, t13f.v,
t140.v, t141.v, t142.v, t143.v, t144.v, t145.v, t146.v, t147.v, t148.v,
t149.v, t14a.v, t14b.v, t14c.v, t14d.v, t14e.v, t14f.v,
t150.v, t151.v, t152.v, t153.v, t154.v, t155.v, t156.v, t157.v, t158.v,
t159.v, t15a.v, t15b.v, t15c.v, t15d.v, t15e.v, t15f.v,
t160.v, t161.v, t162.v, t163.v, t164.v, t165.v, t166.v, t167.v, t168.v,
t169.v, t16a.v, t16b.v, t16c.v, t16d.v, t16e.v, t16f.v,
t170.v, t171.v, t172.v, t173.v, t174.v, t175.v, t176.v, t177.v, t178.v,
t179.v, t17a.v, t17b.v, t17c.v, t17d.v, t17e.v, t17f.v,
t180.v, t181.v, t182.v, t183.v, t184.v, t185.v, t186.v, t187.v, t188.v,
t189.v, t18a.v, t18b.v, t18c.v, t18d.v, t18e.v, t18f.v,
t190.v, t191.v, t192.v, t193.v, t194.v, t195.v, t196.v, t197.v, t198.v,
t199.v, t19a.v, t19b.v, t19c.v, t19d.v, t19e.v, t19f.v,
t1a0.v, t1a1.v, t1a2.v, t1a3.v, t1a4.v, t1a5.v, t1a6.v, t1a7.v, t1a8.v,
t1a9.v, t1aa.v, t1ab.v, t1ac.v, t1ad.v, t1ae.v, t1af.v,
t1b0.v, t1b1.v, t1b2.v, t1b3.v, t1b4.v, t1b5.v, t1b6.v, t1b7.v, t1b8.v,
t1b9.v, t1ba.v, t1bb.v, t1bc.v, t1bd.v, t1be.v, t1bf.v
FROM
generate_series(1, 1024*1024),
t t000, t t001, t t002, t t003, t t004, t t005, t t006, t t007, t t008,
t t009, t t00a, t t00b, t t00c, t t00d, t t00e, t t00f,
t t010, t t011, t t012, t t013, t t014, t t015, t t016, t t017, t t018,
t t019, t t01a, t t01b, t t01c, t t01d, t t01e, t t01f,
t t020, t t021, t t022, t t023, t t024, t t025, t t026, t t027, t t028,
t t029, t t02a, t t02b, t t02c, t t02d, t t02e, t t02f,
t t030, t t031, t t032, t t033, t t034, t t035, t t036, t t037, t t038,
t t039, t t03a, t t03b, t t03c, t t03d, t t03e, t t03f,
t t040, t t041, t t042, t t043, t t044, t t045, t t046, t t047, t t048,
t t049, t t04a, t t04b, t t04c, t t04d, t t04e, t t04f,
t t050, t t051, t t052, t t053, t t054, t t055, t t056, t t057, t t058,
t t059, t t05a, t t05b, t t05c, t t05d, t t05e, t t05f,
t t060, t t061, t t062, t t063, t t064, t t065, t t066, t t067, t t068,
t t069, t t06a, t t06b, t t06c, t t06d, t t06e, t t06f,
t t070, t t071, t t072, t t073, t t074, t t075, t t076, t t077, t t078,
t t079, t t07a, t t07b, t t07c, t t07d, t t07e, t t07f,
t t080, t t081, t t082, t t083, t t084, t t085, t t086, t t087, t t088,
t t089, t t08a, t t08b, t t08c, t t08d, t t08e, t t08f,
t t090, t t091, t t092, t t093, t t094, t t095, t t096, t t097, t t098,
t t099, t t09a, t t09b, t t09c, t t09d, t t09e, t t09f,
t t0a0, t t0a1, t t0a2, t t0a3, t t0a4, t t0a5, t t0a6, t t0a7, t t0a8,
t t0a9, t t0aa, t t0ab, t t0ac, t t0ad, t t0ae, t t0af,
t t0b0, t t0b1, t t0b2, t t0b3, t t0b4, t t0b5, t t0b6, t t0b7, t t0b8,
t t0b9, t t0ba, t t0bb, t t0bc, t t0bd, t t0be, t t0bf,
t t0c0, t t0c1, t t0c2, t t0c3, t t0c4, t t0c5, t t0c6, t t0c7, t t0c8,
t t0c9, t t0ca, t t0cb, t t0cc, t t0cd, t t0ce, t t0cf,
t t0d0, t t0d1, t t0d2, t t0d3, t t0d4, t t0d5, t t0d6, t t0d7, t t0d8,
t t0d9, t t0da, t t0db, t t0dc, t t0dd, t t0de, t t0df,
t t0e0, t t0e1, t t0e2, t t0e3, t t0e4, t t0e5, t t0e6, t t0e7, t t0e8,
t t0e9, t t0ea, t t0eb, t t0ec, t t0ed, t t0ee, t t0ef,
t t0f0, t t0f1, t t0f2, t t0f3, t t0f4, t t0f5, t t0f6, t t0f7, t t0f8,
t t0f9, t t0fa, t t0fb, t t0fc, t t0fd, t t0fe, t t0ff,
t t100, t t101, t t102, t t103, t t104, t t105, t t106, t t107, t t108,
t t109, t t10a, t t10b, t t10c, t t10d, t t10e, t t10f,
t t110, t t111, t t112, t t113, t t114, t t115, t t116, t t117, t t118,
t t119, t t11a, t t11b, t t11c, t t11d, t t11e, t t11f,
t t120, t t121, t t122, t t123, t t124, t t125, t t126, t t127, t t128,
t t129, t t12a, t t12b, t t12c, t t12d, t t12e, t t12f,
t t130, t t131, t t132, t t133, t t134, t t135, t t136, t t137, t t138,
t t139, t t13a, t t13b, t t13c, t t13d, t t13e, t t13f,
t t140, t t141, t t142, t t143, t t144, t t145, t t146, t t147, t t148,
t t149, t t14a, t t14b, t t14c, t t14d, t t14e, t t14f,
t t150, t t151, t t152, t t153, t t154, t t155, t t156, t t157, t t158,
t t159, t t15a, t t15b, t t15c, t t15d, t t15e, t t15f,
t t160, t t161, t t162, t t163, t t164, t t165, t t166, t t167, t t168,
t t169, t t16a, t t16b, t t16c, t t16d, t t16e, t t16f,
t t170, t t171, t t172, t t173, t t174, t t175, t t176, t t177, t t178,
t t179, t t17a, t t17b, t t17c, t t17d, t t17e, t t17f,
t t180, t t181, t t182, t t183, t t184, t t185, t t186, t t187, t t188,
t t189, t t18a, t t18b, t t18c, t t18d, t t18e, t t18f,
t t190, t t191, t t192, t t193, t t194, t t195, t t196, t t197, t t198,
t t199, t t19a, t t19b, t t19c, t t19d, t t19e, t t19f,
t t1a0, t t1a1, t t1a2, t t1a3, t t1a4, t t1a5, t t1a6, t t1a7, t t1a8,
t t1a9, t t1aa, t t1ab, t t1ac, t t1ad, t t1ae, t t1af,
t t1b0, t t1b1, t t1b2, t t1b3, t t1b4, t t1b5, t t1b6, t t1b7, t t1b8,
t t1b9, t t1ba, t t1bb, t t1bc, t t1bd, t t1be, t t1bf
;
SELECT '3 Mi entries written'::text;
INSERT INTO test (
arr000, arr001, arr002, arr003, arr004, arr005, arr006, arr007, arr008,
arr009, arr00a, arr00b, arr00c, arr00d, arr00e, arr00f,
arr010, arr011, arr012, arr013, arr014, arr015, arr016, arr017, arr018,
arr019, arr01a, arr01b, arr01c, arr01d, arr01e, arr01f,
arr020, arr021, arr022, arr023, arr024, arr025, arr026, arr027, arr028,
arr029, arr02a, arr02b, arr02c, arr02d, arr02e, arr02f,
arr030, arr031, arr032, arr033, arr034, arr035, arr036, arr037, arr038,
arr039, arr03a, arr03b, arr03c, arr03d, arr03e, arr03f,
arr040, arr041, arr042, arr043, arr044, arr045, arr046, arr047, arr048,
arr049, arr04a, arr04b, arr04c, arr04d, arr04e, arr04f,
arr050, arr051, arr052, arr053, arr054, arr055, arr056, arr057, arr058,
arr059, arr05a, arr05b, arr05c, arr05d, arr05e, arr05f,
arr060, arr061, arr062, arr063, arr064, arr065, arr066, arr067, arr068,
arr069, arr06a, arr06b, arr06c, arr06d, arr06e, arr06f,
arr070, arr071, arr072, arr073, arr074, arr075, arr076, arr077, arr078,
arr079, arr07a, arr07b, arr07c, arr07d, arr07e, arr07f,
arr080, arr081, arr082, arr083, arr084, arr085, arr086, arr087, arr088,
arr089, arr08a, arr08b, arr08c, arr08d, arr08e, arr08f,
arr090, arr091, arr092, arr093, arr094, arr095, arr096, arr097, arr098,
arr099, arr09a, arr09b, arr09c, arr09d, arr09e, arr09f,
arr0a0, arr0a1, arr0a2, arr0a3, arr0a4, arr0a5, arr0a6, arr0a7, arr0a8,
arr0a9, arr0aa, arr0ab, arr0ac, arr0ad, arr0ae, arr0af,
arr0b0, arr0b1, arr0b2, arr0b3, arr0b4, arr0b5, arr0b6, arr0b7, arr0b8,
arr0b9, arr0ba, arr0bb, arr0bc, arr0bd, arr0be, arr0bf,
arr0c0, arr0c1, arr0c2, arr0c3, arr0c4, arr0c5, arr0c6, arr0c7, arr0c8,
arr0c9, arr0ca, arr0cb, arr0cc, arr0cd, arr0ce, arr0cf,
arr0d0, arr0d1, arr0d2, arr0d3, arr0d4, arr0d5, arr0d6, arr0d7, arr0d8,
arr0d9, arr0da, arr0db, arr0dc, arr0dd, arr0de, arr0df,
arr0e0, arr0e1, arr0e2, arr0e3, arr0e4, arr0e5, arr0e6, arr0e7, arr0e8,
arr0e9, arr0ea, arr0eb, arr0ec, arr0ed, arr0ee, arr0ef,
arr0f0, arr0f1, arr0f2, arr0f3, arr0f4, arr0f5, arr0f6, arr0f7, arr0f8,
arr0f9, arr0fa, arr0fb, arr0fc, arr0fd, arr0fe, arr0ff,
arr100, arr101, arr102, arr103, arr104, arr105, arr106, arr107, arr108,
arr109, arr10a, arr10b, arr10c, arr10d, arr10e, arr10f,
arr110, arr111, arr112, arr113, arr114, arr115, arr116, arr117, arr118,
arr119, arr11a, arr11b, arr11c, arr11d, arr11e, arr11f,
arr120, arr121, arr122, arr123, arr124, arr125, arr126, arr127, arr128,
arr129, arr12a, arr12b, arr12c, arr12d, arr12e, arr12f,
arr130, arr131, arr132, arr133, arr134, arr135, arr136, arr137, arr138,
arr139, arr13a, arr13b, arr13c, arr13d, arr13e, arr13f,
arr140, arr141, arr142, arr143, arr144, arr145, arr146, arr147, arr148,
arr149, arr14a, arr14b, arr14c, arr14d, arr14e, arr14f,
arr150, arr151, arr152, arr153, arr154, arr155, arr156, arr157, arr158,
arr159, arr15a, arr15b, arr15c, arr15d, arr15e, arr15f,
arr160, arr161, arr162, arr163, arr164, arr165, arr166, arr167, arr168,
arr169, arr16a, arr16b, arr16c, arr16d, arr16e, arr16f,
arr170, arr171, arr172, arr173, arr174, arr175, arr176, arr177, arr178,
arr179, arr17a, arr17b, arr17c, arr17d, arr17e, arr17f,
arr180, arr181, arr182, arr183, arr184, arr185, arr186, arr187, arr188,
arr189, arr18a, arr18b, arr18c, arr18d, arr18e, arr18f,
arr190, arr191, arr192, arr193, arr194, arr195, arr196, arr197, arr198,
arr199, arr19a, arr19b, arr19c, arr19d, arr19e, arr19f,
arr1a0, arr1a1, arr1a2, arr1a3, arr1a4, arr1a5, arr1a6, arr1a7, arr1a8,
arr1a9, arr1aa, arr1ab, arr1ac, arr1ad, arr1ae, arr1af,
arr1b0, arr1b1, arr1b2, arr1b3, arr1b4, arr1b5, arr1b6, arr1b7, arr1b8,
arr1b9, arr1ba, arr1bb, arr1bc, arr1bd, arr1be, arr1bf
)
WITH t AS (SELECT '{null}'::Integer[] AS v)
SELECT
t000.v, t001.v, t002.v, t003.v, t004.v, t005.v, t006.v, t007.v, t008.v,
t009.v, t00a.v, t00b.v, t00c.v, t00d.v, t00e.v, t00f.v,
t010.v, t011.v, t012.v, t013.v, t014.v, t015.v, t016.v, t017.v, t018.v,
t019.v, t01a.v, t01b.v, t01c.v, t01d.v, t01e.v, t01f.v,
t020.v, t021.v, t022.v, t023.v, t024.v, t025.v, t026.v, t027.v, t028.v,
t029.v, t02a.v, t02b.v, t02c.v, t02d.v, t02e.v, t02f.v,
t030.v, t031.v, t032.v, t033.v, t034.v, t035.v, t036.v, t037.v, t038.v,
t039.v, t03a.v, t03b.v, t03c.v, t03d.v, t03e.v, t03f.v,
t040.v, t041.v, t042.v, t043.v, t044.v, t045.v, t046.v, t047.v, t048.v,
t049.v, t04a.v, t04b.v, t04c.v, t04d.v, t04e.v, t04f.v,
t050.v, t051.v, t052.v, t053.v, t054.v, t055.v, t056.v, t057.v, t058.v,
t059.v, t05a.v, t05b.v, t05c.v, t05d.v, t05e.v, t05f.v,
t060.v, t061.v, t062.v, t063.v, t064.v, t065.v, t066.v, t067.v, t068.v,
t069.v, t06a.v, t06b.v, t06c.v, t06d.v, t06e.v, t06f.v,
t070.v, t071.v, t072.v, t073.v, t074.v, t075.v, t076.v, t077.v, t078.v,
t079.v, t07a.v, t07b.v, t07c.v, t07d.v, t07e.v, t07f.v,
t080.v, t081.v, t082.v, t083.v, t084.v, t085.v, t086.v, t087.v, t088.v,
t089.v, t08a.v, t08b.v, t08c.v, t08d.v, t08e.v, t08f.v,
t090.v, t091.v, t092.v, t093.v, t094.v, t095.v, t096.v, t097.v, t098.v,
t099.v, t09a.v, t09b.v, t09c.v, t09d.v, t09e.v, t09f.v,
t0a0.v, t0a1.v, t0a2.v, t0a3.v, t0a4.v, t0a5.v, t0a6.v, t0a7.v, t0a8.v,
t0a9.v, t0aa.v, t0ab.v, t0ac.v, t0ad.v, t0ae.v, t0af.v,
t0b0.v, t0b1.v, t0b2.v, t0b3.v, t0b4.v, t0b5.v, t0b6.v, t0b7.v, t0b8.v,
t0b9.v, t0ba.v, t0bb.v, t0bc.v, t0bd.v, t0be.v, t0bf.v,
t0c0.v, t0c1.v, t0c2.v, t0c3.v, t0c4.v, t0c5.v, t0c6.v, t0c7.v, t0c8.v,
t0c9.v, t0ca.v, t0cb.v, t0cc.v, t0cd.v, t0ce.v, t0cf.v,
t0d0.v, t0d1.v, t0d2.v, t0d3.v, t0d4.v, t0d5.v, t0d6.v, t0d7.v, t0d8.v,
t0d9.v, t0da.v, t0db.v, t0dc.v, t0dd.v, t0de.v, t0df.v,
t0e0.v, t0e1.v, t0e2.v, t0e3.v, t0e4.v, t0e5.v, t0e6.v, t0e7.v, t0e8.v,
t0e9.v, t0ea.v, t0eb.v, t0ec.v, t0ed.v, t0ee.v, t0ef.v,
t0f0.v, t0f1.v, t0f2.v, t0f3.v, t0f4.v, t0f5.v, t0f6.v, t0f7.v, t0f8.v,
t0f9.v, t0fa.v, t0fb.v, t0fc.v, t0fd.v, t0fe.v, t0ff.v,
t100.v, t101.v, t102.v, t103.v, t104.v, t105.v, t106.v, t107.v, t108.v,
t109.v, t10a.v, t10b.v, t10c.v, t10d.v, t10e.v, t10f.v,
t110.v, t111.v, t112.v, t113.v, t114.v, t115.v, t116.v, t117.v, t118.v,
t119.v, t11a.v, t11b.v, t11c.v, t11d.v, t11e.v, t11f.v,
t120.v, t121.v, t122.v, t123.v, t124.v, t125.v, t126.v, t127.v, t128.v,
t129.v, t12a.v, t12b.v, t12c.v, t12d.v, t12e.v, t12f.v,
t130.v, t131.v, t132.v, t133.v, t134.v, t135.v, t136.v, t137.v, t138.v,
t139.v, t13a.v, t13b.v, t13c.v, t13d.v, t13e.v, t13f.v,
t140.v, t141.v, t142.v, t143.v, t144.v, t145.v, t146.v, t147.v, t148.v,
t149.v, t14a.v, t14b.v, t14c.v, t14d.v, t14e.v, t14f.v,
t150.v, t151.v, t152.v, t153.v, t154.v, t155.v, t156.v, t157.v, t158.v,
t159.v, t15a.v, t15b.v, t15c.v, t15d.v, t15e.v, t15f.v,
t160.v, t161.v, t162.v, t163.v, t164.v, t165.v, t166.v, t167.v, t168.v,
t169.v, t16a.v, t16b.v, t16c.v, t16d.v, t16e.v, t16f.v,
t170.v, t171.v, t172.v, t173.v, t174.v, t175.v, t176.v, t177.v, t178.v,
t179.v, t17a.v, t17b.v, t17c.v, t17d.v, t17e.v, t17f.v,
t180.v, t181.v, t182.v, t183.v, t184.v, t185.v, t186.v, t187.v, t188.v,
t189.v, t18a.v, t18b.v, t18c.v, t18d.v, t18e.v, t18f.v,
t190.v, t191.v, t192.v, t193.v, t194.v, t195.v, t196.v, t197.v, t198.v,
t199.v, t19a.v, t19b.v, t19c.v, t19d.v, t19e.v, t19f.v,
t1a0.v, t1a1.v, t1a2.v, t1a3.v, t1a4.v, t1a5.v, t1a6.v, t1a7.v, t1a8.v,
t1a9.v, t1aa.v, t1ab.v, t1ac.v, t1ad.v, t1ae.v, t1af.v,
t1b0.v, t1b1.v, t1b2.v, t1b3.v, t1b4.v, t1b5.v, t1b6.v, t1b7.v, t1b8.v,
t1b9.v, t1ba.v, t1bb.v, t1bc.v, t1bd.v, t1be.v, t1bf.v
FROM
generate_series(1, 1024*1024),
t t000, t t001, t t002, t t003, t t004, t t005, t t006, t t007, t t008,
t t009, t t00a, t t00b, t t00c, t t00d, t t00e, t t00f,
t t010, t t011, t t012, t t013, t t014, t t015, t t016, t t017, t t018,
t t019, t t01a, t t01b, t t01c, t t01d, t t01e, t t01f,
t t020, t t021, t t022, t t023, t t024, t t025, t t026, t t027, t t028,
t t029, t t02a, t t02b, t t02c, t t02d, t t02e, t t02f,
t t030, t t031, t t032, t t033, t t034, t t035, t t036, t t037, t t038,
t t039, t t03a, t t03b, t t03c, t t03d, t t03e, t t03f,
t t040, t t041, t t042, t t043, t t044, t t045, t t046, t t047, t t048,
t t049, t t04a, t t04b, t t04c, t t04d, t t04e, t t04f,
t t050, t t051, t t052, t t053, t t054, t t055, t t056, t t057, t t058,
t t059, t t05a, t t05b, t t05c, t t05d, t t05e, t t05f,
t t060, t t061, t t062, t t063, t t064, t t065, t t066, t t067, t t068,
t t069, t t06a, t t06b, t t06c, t t06d, t t06e, t t06f,
t t070, t t071, t t072, t t073, t t074, t t075, t t076, t t077, t t078,
t t079, t t07a, t t07b, t t07c, t t07d, t t07e, t t07f,
t t080, t t081, t t082, t t083, t t084, t t085, t t086, t t087, t t088,
t t089, t t08a, t t08b, t t08c, t t08d, t t08e, t t08f,
t t090, t t091, t t092, t t093, t t094, t t095, t t096, t t097, t t098,
t t099, t t09a, t t09b, t t09c, t t09d, t t09e, t t09f,
t t0a0, t t0a1, t t0a2, t t0a3, t t0a4, t t0a5, t t0a6, t t0a7, t t0a8,
t t0a9, t t0aa, t t0ab, t t0ac, t t0ad, t t0ae, t t0af,
t t0b0, t t0b1, t t0b2, t t0b3, t t0b4, t t0b5, t t0b6, t t0b7, t t0b8,
t t0b9, t t0ba, t t0bb, t t0bc, t t0bd, t t0be, t t0bf,
t t0c0, t t0c1, t t0c2, t t0c3, t t0c4, t t0c5, t t0c6, t t0c7, t t0c8,
t t0c9, t t0ca, t t0cb, t t0cc, t t0cd, t t0ce, t t0cf,
t t0d0, t t0d1, t t0d2, t t0d3, t t0d4, t t0d5, t t0d6, t t0d7, t t0d8,
t t0d9, t t0da, t t0db, t t0dc, t t0dd, t t0de, t t0df,
t t0e0, t t0e1, t t0e2, t t0e3, t t0e4, t t0e5, t t0e6, t t0e7, t t0e8,
t t0e9, t t0ea, t t0eb, t t0ec, t t0ed, t t0ee, t t0ef,
t t0f0, t t0f1, t t0f2, t t0f3, t t0f4, t t0f5, t t0f6, t t0f7, t t0f8,
t t0f9, t t0fa, t t0fb, t t0fc, t t0fd, t t0fe, t t0ff,
t t100, t t101, t t102, t t103, t t104, t t105, t t106, t t107, t t108,
t t109, t t10a, t t10b, t t10c, t t10d, t t10e, t t10f,
t t110, t t111, t t112, t t113, t t114, t t115, t t116, t t117, t t118,
t t119, t t11a, t t11b, t t11c, t t11d, t t11e, t t11f,
t t120, t t121, t t122, t t123, t t124, t t125, t t126, t t127, t t128,
t t129, t t12a, t t12b, t t12c, t t12d, t t12e, t t12f,
t t130, t t131, t t132, t t133, t t134, t t135, t t136, t t137, t t138,
t t139, t t13a, t t13b, t t13c, t t13d, t t13e, t t13f,
t t140, t t141, t t142, t t143, t t144, t t145, t t146, t t147, t t148,
t t149, t t14a, t t14b, t t14c, t t14d, t t14e, t t14f,
t t150, t t151, t t152, t t153, t t154, t t155, t t156, t t157, t t158,
t t159, t t15a, t t15b, t t15c, t t15d, t t15e, t t15f,
t t160, t t161, t t162, t t163, t t164, t t165, t t166, t t167, t t168,
t t169, t t16a, t t16b, t t16c, t t16d, t t16e, t t16f,
t t170, t t171, t t172, t t173, t t174, t t175, t t176, t t177, t t178,
t t179, t t17a, t t17b, t t17c, t t17d, t t17e, t t17f,
t t180, t t181, t t182, t t183, t t184, t t185, t t186, t t187, t t188,
t t189, t t18a, t t18b, t t18c, t t18d, t t18e, t t18f,
t t190, t t191, t t192, t t193, t t194, t t195, t t196, t t197, t t198,
t t199, t t19a, t t19b, t t19c, t t19d, t t19e, t t19f,
t t1a0, t t1a1, t t1a2, t t1a3, t t1a4, t t1a5, t t1a6, t t1a7, t t1a8,
t t1a9, t t1aa, t t1ab, t t1ac, t t1ad, t t1ae, t t1af,
t t1b0, t t1b1, t t1b2, t t1b3, t t1b4, t t1b5, t t1b6, t t1b7, t t1b8,
t t1b9, t t1ba, t t1bb, t t1bc, t t1bd, t t1be, t t1bf
;
SELECT '4 Mi entries written'::text;
INSERT INTO test (
arr000, arr001, arr002, arr003, arr004, arr005, arr006, arr007, arr008,
arr009, arr00a, arr00b, arr00c, arr00d, arr00e, arr00f,
arr010, arr011, arr012, arr013, arr014, arr015, arr016, arr017, arr018,
arr019, arr01a, arr01b, arr01c, arr01d, arr01e, arr01f,
arr020, arr021, arr022, arr023, arr024, arr025, arr026, arr027, arr028,
arr029, arr02a, arr02b, arr02c, arr02d, arr02e, arr02f,
arr030, arr031, arr032, arr033, arr034, arr035, arr036, arr037, arr038,
arr039, arr03a, arr03b, arr03c, arr03d, arr03e, arr03f,
arr040, arr041, arr042, arr043, arr044, arr045, arr046, arr047, arr048,
arr049, arr04a, arr04b, arr04c, arr04d, arr04e, arr04f,
arr050, arr051, arr052, arr053, arr054, arr055, arr056, arr057, arr058,
arr059, arr05a, arr05b, arr05c, arr05d, arr05e, arr05f,
arr060, arr061, arr062, arr063, arr064, arr065, arr066, arr067, arr068,
arr069, arr06a, arr06b, arr06c, arr06d, arr06e, arr06f,
arr070, arr071, arr072, arr073, arr074, arr075, arr076, arr077, arr078,
arr079, arr07a, arr07b, arr07c, arr07d, arr07e, arr07f,
arr080, arr081, arr082, arr083, arr084, arr085, arr086, arr087, arr088,
arr089, arr08a, arr08b, arr08c, arr08d, arr08e, arr08f,
arr090, arr091, arr092, arr093, arr094, arr095, arr096, arr097, arr098,
arr099, arr09a, arr09b, arr09c, arr09d, arr09e, arr09f,
arr0a0, arr0a1, arr0a2, arr0a3, arr0a4, arr0a5, arr0a6, arr0a7, arr0a8,
arr0a9, arr0aa, arr0ab, arr0ac, arr0ad, arr0ae, arr0af,
arr0b0, arr0b1, arr0b2, arr0b3, arr0b4, arr0b5, arr0b6, arr0b7, arr0b8,
arr0b9, arr0ba, arr0bb, arr0bc, arr0bd, arr0be, arr0bf,
arr0c0, arr0c1, arr0c2, arr0c3, arr0c4, arr0c5, arr0c6, arr0c7, arr0c8,
arr0c9, arr0ca, arr0cb, arr0cc, arr0cd, arr0ce, arr0cf,
arr0d0, arr0d1, arr0d2, arr0d3, arr0d4, arr0d5, arr0d6, arr0d7, arr0d8,
arr0d9, arr0da, arr0db, arr0dc, arr0dd, arr0de, arr0df,
arr0e0, arr0e1, arr0e2, arr0e3, arr0e4, arr0e5, arr0e6, arr0e7, arr0e8,
arr0e9, arr0ea, arr0eb, arr0ec, arr0ed, arr0ee, arr0ef,
arr0f0, arr0f1, arr0f2, arr0f3, arr0f4, arr0f5, arr0f6, arr0f7, arr0f8,
arr0f9, arr0fa, arr0fb, arr0fc, arr0fd, arr0fe, arr0ff,
arr100, arr101, arr102, arr103, arr104, arr105, arr106, arr107, arr108,
arr109, arr10a, arr10b, arr10c, arr10d, arr10e, arr10f,
arr110, arr111, arr112, arr113, arr114, arr115, arr116, arr117, arr118,
arr119, arr11a, arr11b, arr11c, arr11d, arr11e, arr11f,
arr120, arr121, arr122, arr123, arr124, arr125, arr126, arr127, arr128,
arr129, arr12a, arr12b, arr12c, arr12d, arr12e, arr12f,
arr130, arr131, arr132, arr133, arr134, arr135, arr136, arr137, arr138,
arr139, arr13a, arr13b, arr13c, arr13d, arr13e, arr13f,
arr140, arr141, arr142, arr143, arr144, arr145, arr146, arr147, arr148,
arr149, arr14a, arr14b, arr14c, arr14d, arr14e, arr14f,
arr150, arr151, arr152, arr153, arr154, arr155, arr156, arr157, arr158,
arr159, arr15a, arr15b, arr15c, arr15d, arr15e, arr15f,
arr160, arr161, arr162, arr163, arr164, arr165, arr166, arr167, arr168,
arr169, arr16a, arr16b, arr16c, arr16d, arr16e, arr16f,
arr170, arr171, arr172, arr173, arr174, arr175, arr176, arr177, arr178,
arr179, arr17a, arr17b, arr17c, arr17d, arr17e, arr17f,
arr180, arr181, arr182, arr183, arr184, arr185, arr186, arr187, arr188,
arr189, arr18a, arr18b, arr18c, arr18d, arr18e, arr18f,
arr190, arr191, arr192, arr193, arr194, arr195, arr196, arr197, arr198,
arr199, arr19a, arr19b, arr19c, arr19d, arr19e, arr19f,
arr1a0, arr1a1, arr1a2, arr1a3, arr1a4, arr1a5, arr1a6, arr1a7, arr1a8,
arr1a9, arr1aa, arr1ab, arr1ac, arr1ad, arr1ae, arr1af,
arr1b0, arr1b1, arr1b2, arr1b3, arr1b4, arr1b5, arr1b6, arr1b7, arr1b8,
arr1b9, arr1ba, arr1bb, arr1bc, arr1bd, arr1be, arr1bf
)
WITH t AS (SELECT '{null}'::Integer[] AS v)
SELECT
t000.v, t001.v, t002.v, t003.v, t004.v, t005.v, t006.v, t007.v, t008.v,
t009.v, t00a.v, t00b.v, t00c.v, t00d.v, t00e.v, t00f.v,
t010.v, t011.v, t012.v, t013.v, t014.v, t015.v, t016.v, t017.v, t018.v,
t019.v, t01a.v, t01b.v, t01c.v, t01d.v, t01e.v, t01f.v,
t020.v, t021.v, t022.v, t023.v, t024.v, t025.v, t026.v, t027.v, t028.v,
t029.v, t02a.v, t02b.v, t02c.v, t02d.v, t02e.v, t02f.v,
t030.v, t031.v, t032.v, t033.v, t034.v, t035.v, t036.v, t037.v, t038.v,
t039.v, t03a.v, t03b.v, t03c.v, t03d.v, t03e.v, t03f.v,
t040.v, t041.v, t042.v, t043.v, t044.v, t045.v, t046.v, t047.v, t048.v,
t049.v, t04a.v, t04b.v, t04c.v, t04d.v, t04e.v, t04f.v,
t050.v, t051.v, t052.v, t053.v, t054.v, t055.v, t056.v, t057.v, t058.v,
t059.v, t05a.v, t05b.v, t05c.v, t05d.v, t05e.v, t05f.v,
t060.v, t061.v, t062.v, t063.v, t064.v, t065.v, t066.v, t067.v, t068.v,
t069.v, t06a.v, t06b.v, t06c.v, t06d.v, t06e.v, t06f.v,
t070.v, t071.v, t072.v, t073.v, t074.v, t075.v, t076.v, t077.v, t078.v,
t079.v, t07a.v, t07b.v, t07c.v, t07d.v, t07e.v, t07f.v,
t080.v, t081.v, t082.v, t083.v, t084.v, t085.v, t086.v, t087.v, t088.v,
t089.v, t08a.v, t08b.v, t08c.v, t08d.v, t08e.v, t08f.v,
t090.v, t091.v, t092.v, t093.v, t094.v, t095.v, t096.v, t097.v, t098.v,
t099.v, t09a.v, t09b.v, t09c.v, t09d.v, t09e.v, t09f.v,
t0a0.v, t0a1.v, t0a2.v, t0a3.v, t0a4.v, t0a5.v, t0a6.v, t0a7.v, t0a8.v,
t0a9.v, t0aa.v, t0ab.v, t0ac.v, t0ad.v, t0ae.v, t0af.v,
t0b0.v, t0b1.v, t0b2.v, t0b3.v, t0b4.v, t0b5.v, t0b6.v, t0b7.v, t0b8.v,
t0b9.v, t0ba.v, t0bb.v, t0bc.v, t0bd.v, t0be.v, t0bf.v,
t0c0.v, t0c1.v, t0c2.v, t0c3.v, t0c4.v, t0c5.v, t0c6.v, t0c7.v, t0c8.v,
t0c9.v, t0ca.v, t0cb.v, t0cc.v, t0cd.v, t0ce.v, t0cf.v,
t0d0.v, t0d1.v, t0d2.v, t0d3.v, t0d4.v, t0d5.v, t0d6.v, t0d7.v, t0d8.v,
t0d9.v, t0da.v, t0db.v, t0dc.v, t0dd.v, t0de.v, t0df.v,
t0e0.v, t0e1.v, t0e2.v, t0e3.v, t0e4.v, t0e5.v, t0e6.v, t0e7.v, t0e8.v,
t0e9.v, t0ea.v, t0eb.v, t0ec.v, t0ed.v, t0ee.v, t0ef.v,
t0f0.v, t0f1.v, t0f2.v, t0f3.v, t0f4.v, t0f5.v, t0f6.v, t0f7.v, t0f8.v,
t0f9.v, t0fa.v, t0fb.v, t0fc.v, t0fd.v, t0fe.v, t0ff.v,
t100.v, t101.v, t102.v, t103.v, t104.v, t105.v, t106.v, t107.v, t108.v,
t109.v, t10a.v, t10b.v, t10c.v, t10d.v, t10e.v, t10f.v,
t110.v, t111.v, t112.v, t113.v, t114.v, t115.v, t116.v, t117.v, t118.v,
t119.v, t11a.v, t11b.v, t11c.v, t11d.v, t11e.v, t11f.v,
t120.v, t121.v, t122.v, t123.v, t124.v, t125.v, t126.v, t127.v, t128.v,
t129.v, t12a.v, t12b.v, t12c.v, t12d.v, t12e.v, t12f.v,
t130.v, t131.v, t132.v, t133.v, t134.v, t135.v, t136.v, t137.v, t138.v,
t139.v, t13a.v, t13b.v, t13c.v, t13d.v, t13e.v, t13f.v,
t140.v, t141.v, t142.v, t143.v, t144.v, t145.v, t146.v, t147.v, t148.v,
t149.v, t14a.v, t14b.v, t14c.v, t14d.v, t14e.v, t14f.v,
t150.v, t151.v, t152.v, t153.v, t154.v, t155.v, t156.v, t157.v, t158.v,
t159.v, t15a.v, t15b.v, t15c.v, t15d.v, t15e.v, t15f.v,
t160.v, t161.v, t162.v, t163.v, t164.v, t165.v, t166.v, t167.v, t168.v,
t169.v, t16a.v, t16b.v, t16c.v, t16d.v, t16e.v, t16f.v,
t170.v, t171.v, t172.v, t173.v, t174.v, t175.v, t176.v, t177.v, t178.v,
t179.v, t17a.v, t17b.v, t17c.v, t17d.v, t17e.v, t17f.v,
t180.v, t181.v, t182.v, t183.v, t184.v, t185.v, t186.v, t187.v, t188.v,
t189.v, t18a.v, t18b.v, t18c.v, t18d.v, t18e.v, t18f.v,
t190.v, t191.v, t192.v, t193.v, t194.v, t195.v, t196.v, t197.v, t198.v,
t199.v, t19a.v, t19b.v, t19c.v, t19d.v, t19e.v, t19f.v,
t1a0.v, t1a1.v, t1a2.v, t1a3.v, t1a4.v, t1a5.v, t1a6.v, t1a7.v, t1a8.v,
t1a9.v, t1aa.v, t1ab.v, t1ac.v, t1ad.v, t1ae.v, t1af.v,
t1b0.v, t1b1.v, t1b2.v, t1b3.v, t1b4.v, t1b5.v, t1b6.v, t1b7.v, t1b8.v,
t1b9.v, t1ba.v, t1bb.v, t1bc.v, t1bd.v, t1be.v, t1bf.v
FROM
generate_series(1, 1024*1024),
t t000, t t001, t t002, t t003, t t004, t t005, t t006, t t007, t t008,
t t009, t t00a, t t00b, t t00c, t t00d, t t00e, t t00f,
t t010, t t011, t t012, t t013, t t014, t t015, t t016, t t017, t t018,
t t019, t t01a, t t01b, t t01c, t t01d, t t01e, t t01f,
t t020, t t021, t t022, t t023, t t024, t t025, t t026, t t027, t t028,
t t029, t t02a, t t02b, t t02c, t t02d, t t02e, t t02f,
t t030, t t031, t t032, t t033, t t034, t t035, t t036, t t037, t t038,
t t039, t t03a, t t03b, t t03c, t t03d, t t03e, t t03f,
t t040, t t041, t t042, t t043, t t044, t t045, t t046, t t047, t t048,
t t049, t t04a, t t04b, t t04c, t t04d, t t04e, t t04f,
t t050, t t051, t t052, t t053, t t054, t t055, t t056, t t057, t t058,
t t059, t t05a, t t05b, t t05c, t t05d, t t05e, t t05f,
t t060, t t061, t t062, t t063, t t064, t t065, t t066, t t067, t t068,
t t069, t t06a, t t06b, t t06c, t t06d, t t06e, t t06f,
t t070, t t071, t t072, t t073, t t074, t t075, t t076, t t077, t t078,
t t079, t t07a, t t07b, t t07c, t t07d, t t07e, t t07f,
t t080, t t081, t t082, t t083, t t084, t t085, t t086, t t087, t t088,
t t089, t t08a, t t08b, t t08c, t t08d, t t08e, t t08f,
t t090, t t091, t t092, t t093, t t094, t t095, t t096, t t097, t t098,
t t099, t t09a, t t09b, t t09c, t t09d, t t09e, t t09f,
t t0a0, t t0a1, t t0a2, t t0a3, t t0a4, t t0a5, t t0a6, t t0a7, t t0a8,
t t0a9, t t0aa, t t0ab, t t0ac, t t0ad, t t0ae, t t0af,
t t0b0, t t0b1, t t0b2, t t0b3, t t0b4, t t0b5, t t0b6, t t0b7, t t0b8,
t t0b9, t t0ba, t t0bb, t t0bc, t t0bd, t t0be, t t0bf,
t t0c0, t t0c1, t t0c2, t t0c3, t t0c4, t t0c5, t t0c6, t t0c7, t t0c8,
t t0c9, t t0ca, t t0cb, t t0cc, t t0cd, t t0ce, t t0cf,
t t0d0, t t0d1, t t0d2, t t0d3, t t0d4, t t0d5, t t0d6, t t0d7, t t0d8,
t t0d9, t t0da, t t0db, t t0dc, t t0dd, t t0de, t t0df,
t t0e0, t t0e1, t t0e2, t t0e3, t t0e4, t t0e5, t t0e6, t t0e7, t t0e8,
t t0e9, t t0ea, t t0eb, t t0ec, t t0ed, t t0ee, t t0ef,
t t0f0, t t0f1, t t0f2, t t0f3, t t0f4, t t0f5, t t0f6, t t0f7, t t0f8,
t t0f9, t t0fa, t t0fb, t t0fc, t t0fd, t t0fe, t t0ff,
t t100, t t101, t t102, t t103, t t104, t t105, t t106, t t107, t t108,
t t109, t t10a, t t10b, t t10c, t t10d, t t10e, t t10f,
t t110, t t111, t t112, t t113, t t114, t t115, t t116, t t117, t t118,
t t119, t t11a, t t11b, t t11c, t t11d, t t11e, t t11f,
t t120, t t121, t t122, t t123, t t124, t t125, t t126, t t127, t t128,
t t129, t t12a, t t12b, t t12c, t t12d, t t12e, t t12f,
t t130, t t131, t t132, t t133, t t134, t t135, t t136, t t137, t t138,
t t139, t t13a, t t13b, t t13c, t t13d, t t13e, t t13f,
t t140, t t141, t t142, t t143, t t144, t t145, t t146, t t147, t t148,
t t149, t t14a, t t14b, t t14c, t t14d, t t14e, t t14f,
t t150, t t151, t t152, t t153, t t154, t t155, t t156, t t157, t t158,
t t159, t t15a, t t15b, t t15c, t t15d, t t15e, t t15f,
t t160, t t161, t t162, t t163, t t164, t t165, t t166, t t167, t t168,
t t169, t t16a, t t16b, t t16c, t t16d, t t16e, t t16f,
t t170, t t171, t t172, t t173, t t174, t t175, t t176, t t177, t t178,
t t179, t t17a, t t17b, t t17c, t t17d, t t17e, t t17f,
t t180, t t181, t t182, t t183, t t184, t t185, t t186, t t187, t t188,
t t189, t t18a, t t18b, t t18c, t t18d, t t18e, t t18f,
t t190, t t191, t t192, t t193, t t194, t t195, t t196, t t197, t t198,
t t199, t t19a, t t19b, t t19c, t t19d, t t19e, t t19f,
t t1a0, t t1a1, t t1a2, t t1a3, t t1a4, t t1a5, t t1a6, t t1a7, t t1a8,
t t1a9, t t1aa, t t1ab, t t1ac, t t1ad, t t1ae, t t1af,
t t1b0, t t1b1, t t1b2, t t1b3, t t1b4, t t1b5, t t1b6, t t1b7, t t1b8,
t t1b9, t t1ba, t t1bb, t t1bc, t t1bd, t t1be, t t1bf
;
SELECT '5 Mi entries written'::text;
INSERT INTO test (
arr000, arr001, arr002, arr003, arr004, arr005, arr006, arr007, arr008,
arr009, arr00a, arr00b, arr00c, arr00d, arr00e, arr00f,
arr010, arr011, arr012, arr013, arr014, arr015, arr016, arr017, arr018,
arr019, arr01a, arr01b, arr01c, arr01d, arr01e, arr01f,
arr020, arr021, arr022, arr023, arr024, arr025, arr026, arr027, arr028,
arr029, arr02a, arr02b, arr02c, arr02d, arr02e, arr02f,
arr030, arr031, arr032, arr033, arr034, arr035, arr036, arr037, arr038,
arr039, arr03a, arr03b, arr03c, arr03d, arr03e, arr03f,
arr040, arr041, arr042, arr043, arr044, arr045, arr046, arr047, arr048,
arr049, arr04a, arr04b, arr04c, arr04d, arr04e, arr04f,
arr050, arr051, arr052, arr053, arr054, arr055, arr056, arr057, arr058,
arr059, arr05a, arr05b, arr05c, arr05d, arr05e, arr05f,
arr060, arr061, arr062, arr063, arr064, arr065, arr066, arr067, arr068,
arr069, arr06a, arr06b, arr06c, arr06d, arr06e, arr06f,
arr070, arr071, arr072, arr073, arr074, arr075, arr076, arr077, arr078,
arr079, arr07a, arr07b, arr07c, arr07d, arr07e, arr07f,
arr080, arr081, arr082, arr083, arr084, arr085, arr086, arr087, arr088,
arr089, arr08a, arr08b, arr08c, arr08d, arr08e, arr08f,
arr090, arr091, arr092, arr093, arr094, arr095, arr096, arr097, arr098,
arr099, arr09a, arr09b, arr09c, arr09d, arr09e, arr09f,
arr0a0, arr0a1, arr0a2, arr0a3, arr0a4, arr0a5, arr0a6, arr0a7, arr0a8,
arr0a9, arr0aa, arr0ab, arr0ac, arr0ad, arr0ae, arr0af,
arr0b0, arr0b1, arr0b2, arr0b3, arr0b4, arr0b5, arr0b6, arr0b7, arr0b8,
arr0b9, arr0ba, arr0bb, arr0bc, arr0bd, arr0be, arr0bf,
arr0c0, arr0c1, arr0c2, arr0c3, arr0c4, arr0c5, arr0c6, arr0c7, arr0c8,
arr0c9, arr0ca, arr0cb, arr0cc, arr0cd, arr0ce, arr0cf,
arr0d0, arr0d1, arr0d2, arr0d3, arr0d4, arr0d5, arr0d6, arr0d7, arr0d8,
arr0d9, arr0da, arr0db, arr0dc, arr0dd, arr0de, arr0df,
arr0e0, arr0e1, arr0e2, arr0e3, arr0e4, arr0e5, arr0e6, arr0e7, arr0e8,
arr0e9, arr0ea, arr0eb, arr0ec, arr0ed, arr0ee, arr0ef,
arr0f0, arr0f1, arr0f2, arr0f3, arr0f4, arr0f5, arr0f6, arr0f7, arr0f8,
arr0f9, arr0fa, arr0fb, arr0fc, arr0fd, arr0fe, arr0ff,
arr100, arr101, arr102, arr103, arr104, arr105, arr106, arr107, arr108,
arr109, arr10a, arr10b, arr10c, arr10d, arr10e, arr10f,
arr110, arr111, arr112, arr113, arr114, arr115, arr116, arr117, arr118,
arr119, arr11a, arr11b, arr11c, arr11d, arr11e, arr11f,
arr120, arr121, arr122, arr123, arr124, arr125, arr126, arr127, arr128,
arr129, arr12a, arr12b, arr12c, arr12d, arr12e, arr12f,
arr130, arr131, arr132, arr133, arr134, arr135, arr136, arr137, arr138,
arr139, arr13a, arr13b, arr13c, arr13d, arr13e, arr13f,
arr140, arr141, arr142, arr143, arr144, arr145, arr146, arr147, arr148,
arr149, arr14a, arr14b, arr14c, arr14d, arr14e, arr14f,
arr150, arr151, arr152, arr153, arr154, arr155, arr156, arr157, arr158,
arr159, arr15a, arr15b, arr15c, arr15d, arr15e, arr15f,
arr160, arr161, arr162, arr163, arr164, arr165, arr166, arr167, arr168,
arr169, arr16a, arr16b, arr16c, arr16d, arr16e, arr16f,
arr170, arr171, arr172, arr173, arr174, arr175, arr176, arr177, arr178,
arr179, arr17a, arr17b, arr17c, arr17d, arr17e, arr17f,
arr180, arr181, arr182, arr183, arr184, arr185, arr186, arr187, arr188,
arr189, arr18a, arr18b, arr18c, arr18d, arr18e, arr18f,
arr190, arr191, arr192, arr193, arr194, arr195, arr196, arr197, arr198,
arr199, arr19a, arr19b, arr19c, arr19d, arr19e, arr19f,
arr1a0, arr1a1, arr1a2, arr1a3, arr1a4, arr1a5, arr1a6, arr1a7, arr1a8,
arr1a9, arr1aa, arr1ab, arr1ac, arr1ad, arr1ae, arr1af,
arr1b0, arr1b1, arr1b2, arr1b3, arr1b4, arr1b5, arr1b6, arr1b7, arr1b8,
arr1b9, arr1ba, arr1bb, arr1bc, arr1bd, arr1be, arr1bf
)
WITH t AS (SELECT '{null}'::Integer[] AS v)
SELECT
t000.v, t001.v, t002.v, t003.v, t004.v, t005.v, t006.v, t007.v, t008.v,
t009.v, t00a.v, t00b.v, t00c.v, t00d.v, t00e.v, t00f.v,
t010.v, t011.v, t012.v, t013.v, t014.v, t015.v, t016.v, t017.v, t018.v,
t019.v, t01a.v, t01b.v, t01c.v, t01d.v, t01e.v, t01f.v,
t020.v, t021.v, t022.v, t023.v, t024.v, t025.v, t026.v, t027.v, t028.v,
t029.v, t02a.v, t02b.v, t02c.v, t02d.v, t02e.v, t02f.v,
t030.v, t031.v, t032.v, t033.v, t034.v, t035.v, t036.v, t037.v, t038.v,
t039.v, t03a.v, t03b.v, t03c.v, t03d.v, t03e.v, t03f.v,
t040.v, t041.v, t042.v, t043.v, t044.v, t045.v, t046.v, t047.v, t048.v,
t049.v, t04a.v, t04b.v, t04c.v, t04d.v, t04e.v, t04f.v,
t050.v, t051.v, t052.v, t053.v, t054.v, t055.v, t056.v, t057.v, t058.v,
t059.v, t05a.v, t05b.v, t05c.v, t05d.v, t05e.v, t05f.v,
t060.v, t061.v, t062.v, t063.v, t064.v, t065.v, t066.v, t067.v, t068.v,
t069.v, t06a.v, t06b.v, t06c.v, t06d.v, t06e.v, t06f.v,
t070.v, t071.v, t072.v, t073.v, t074.v, t075.v, t076.v, t077.v, t078.v,
t079.v, t07a.v, t07b.v, t07c.v, t07d.v, t07e.v, t07f.v,
t080.v, t081.v, t082.v, t083.v, t084.v, t085.v, t086.v, t087.v, t088.v,
t089.v, t08a.v, t08b.v, t08c.v, t08d.v, t08e.v, t08f.v,
t090.v, t091.v, t092.v, t093.v, t094.v, t095.v, t096.v, t097.v, t098.v,
t099.v, t09a.v, t09b.v, t09c.v, t09d.v, t09e.v, t09f.v,
t0a0.v, t0a1.v, t0a2.v, t0a3.v, t0a4.v, t0a5.v, t0a6.v, t0a7.v, t0a8.v,
t0a9.v, t0aa.v, t0ab.v, t0ac.v, t0ad.v, t0ae.v, t0af.v,
t0b0.v, t0b1.v, t0b2.v, t0b3.v, t0b4.v, t0b5.v, t0b6.v, t0b7.v, t0b8.v,
t0b9.v, t0ba.v, t0bb.v, t0bc.v, t0bd.v, t0be.v, t0bf.v,
t0c0.v, t0c1.v, t0c2.v, t0c3.v, t0c4.v, t0c5.v, t0c6.v, t0c7.v, t0c8.v,
t0c9.v, t0ca.v, t0cb.v, t0cc.v, t0cd.v, t0ce.v, t0cf.v,
t0d0.v, t0d1.v, t0d2.v, t0d3.v, t0d4.v, t0d5.v, t0d6.v, t0d7.v, t0d8.v,
t0d9.v, t0da.v, t0db.v, t0dc.v, t0dd.v, t0de.v, t0df.v,
t0e0.v, t0e1.v, t0e2.v, t0e3.v, t0e4.v, t0e5.v, t0e6.v, t0e7.v, t0e8.v,
t0e9.v, t0ea.v, t0eb.v, t0ec.v, t0ed.v, t0ee.v, t0ef.v,
t0f0.v, t0f1.v, t0f2.v, t0f3.v, t0f4.v, t0f5.v, t0f6.v, t0f7.v, t0f8.v,
t0f9.v, t0fa.v, t0fb.v, t0fc.v, t0fd.v, t0fe.v, t0ff.v,
t100.v, t101.v, t102.v, t103.v, t104.v, t105.v, t106.v, t107.v, t108.v,
t109.v, t10a.v, t10b.v, t10c.v, t10d.v, t10e.v, t10f.v,
t110.v, t111.v, t112.v, t113.v, t114.v, t115.v, t116.v, t117.v, t118.v,
t119.v, t11a.v, t11b.v, t11c.v, t11d.v, t11e.v, t11f.v,
t120.v, t121.v, t122.v, t123.v, t124.v, t125.v, t126.v, t127.v, t128.v,
t129.v, t12a.v, t12b.v, t12c.v, t12d.v, t12e.v, t12f.v,
t130.v, t131.v, t132.v, t133.v, t134.v, t135.v, t136.v, t137.v, t138.v,
t139.v, t13a.v, t13b.v, t13c.v, t13d.v, t13e.v, t13f.v,
t140.v, t141.v, t142.v, t143.v, t144.v, t145.v, t146.v, t147.v, t148.v,
t149.v, t14a.v, t14b.v, t14c.v, t14d.v, t14e.v, t14f.v,
t150.v, t151.v, t152.v, t153.v, t154.v, t155.v, t156.v, t157.v, t158.v,
t159.v, t15a.v, t15b.v, t15c.v, t15d.v, t15e.v, t15f.v,
t160.v, t161.v, t162.v, t163.v, t164.v, t165.v, t166.v, t167.v, t168.v,
t169.v, t16a.v, t16b.v, t16c.v, t16d.v, t16e.v, t16f.v,
t170.v, t171.v, t172.v, t173.v, t174.v, t175.v, t176.v, t177.v, t178.v,
t179.v, t17a.v, t17b.v, t17c.v, t17d.v, t17e.v, t17f.v,
t180.v, t181.v, t182.v, t183.v, t184.v, t185.v, t186.v, t187.v, t188.v,
t189.v, t18a.v, t18b.v, t18c.v, t18d.v, t18e.v, t18f.v,
t190.v, t191.v, t192.v, t193.v, t194.v, t195.v, t196.v, t197.v, t198.v,
t199.v, t19a.v, t19b.v, t19c.v, t19d.v, t19e.v, t19f.v,
t1a0.v, t1a1.v, t1a2.v, t1a3.v, t1a4.v, t1a5.v, t1a6.v, t1a7.v, t1a8.v,
t1a9.v, t1aa.v, t1ab.v, t1ac.v, t1ad.v, t1ae.v, t1af.v,
t1b0.v, t1b1.v, t1b2.v, t1b3.v, t1b4.v, t1b5.v, t1b6.v, t1b7.v, t1b8.v,
t1b9.v, t1ba.v, t1bb.v, t1bc.v, t1bd.v, t1be.v, t1bf.v
FROM
generate_series(1, 1024*1024),
t t000, t t001, t t002, t t003, t t004, t t005, t t006, t t007, t t008,
t t009, t t00a, t t00b, t t00c, t t00d, t t00e, t t00f,
t t010, t t011, t t012, t t013, t t014, t t015, t t016, t t017, t t018,
t t019, t t01a, t t01b, t t01c, t t01d, t t01e, t t01f,
t t020, t t021, t t022, t t023, t t024, t t025, t t026, t t027, t t028,
t t029, t t02a, t t02b, t t02c, t t02d, t t02e, t t02f,
t t030, t t031, t t032, t t033, t t034, t t035, t t036, t t037, t t038,
t t039, t t03a, t t03b, t t03c, t t03d, t t03e, t t03f,
t t040, t t041, t t042, t t043, t t044, t t045, t t046, t t047, t t048,
t t049, t t04a, t t04b, t t04c, t t04d, t t04e, t t04f,
t t050, t t051, t t052, t t053, t t054, t t055, t t056, t t057, t t058,
t t059, t t05a, t t05b, t t05c, t t05d, t t05e, t t05f,
t t060, t t061, t t062, t t063, t t064, t t065, t t066, t t067, t t068,
t t069, t t06a, t t06b, t t06c, t t06d, t t06e, t t06f,
t t070, t t071, t t072, t t073, t t074, t t075, t t076, t t077, t t078,
t t079, t t07a, t t07b, t t07c, t t07d, t t07e, t t07f,
t t080, t t081, t t082, t t083, t t084, t t085, t t086, t t087, t t088,
t t089, t t08a, t t08b, t t08c, t t08d, t t08e, t t08f,
t t090, t t091, t t092, t t093, t t094, t t095, t t096, t t097, t t098,
t t099, t t09a, t t09b, t t09c, t t09d, t t09e, t t09f,
t t0a0, t t0a1, t t0a2, t t0a3, t t0a4, t t0a5, t t0a6, t t0a7, t t0a8,
t t0a9, t t0aa, t t0ab, t t0ac, t t0ad, t t0ae, t t0af,
t t0b0, t t0b1, t t0b2, t t0b3, t t0b4, t t0b5, t t0b6, t t0b7, t t0b8,
t t0b9, t t0ba, t t0bb, t t0bc, t t0bd, t t0be, t t0bf,
t t0c0, t t0c1, t t0c2, t t0c3, t t0c4, t t0c5, t t0c6, t t0c7, t t0c8,
t t0c9, t t0ca, t t0cb, t t0cc, t t0cd, t t0ce, t t0cf,
t t0d0, t t0d1, t t0d2, t t0d3, t t0d4, t t0d5, t t0d6, t t0d7, t t0d8,
t t0d9, t t0da, t t0db, t t0dc, t t0dd, t t0de, t t0df,
t t0e0, t t0e1, t t0e2, t t0e3, t t0e4, t t0e5, t t0e6, t t0e7, t t0e8,
t t0e9, t t0ea, t t0eb, t t0ec, t t0ed, t t0ee, t t0ef,
t t0f0, t t0f1, t t0f2, t t0f3, t t0f4, t t0f5, t t0f6, t t0f7, t t0f8,
t t0f9, t t0fa, t t0fb, t t0fc, t t0fd, t t0fe, t t0ff,
t t100, t t101, t t102, t t103, t t104, t t105, t t106, t t107, t t108,
t t109, t t10a, t t10b, t t10c, t t10d, t t10e, t t10f,
t t110, t t111, t t112, t t113, t t114, t t115, t t116, t t117, t t118,
t t119, t t11a, t t11b, t t11c, t t11d, t t11e, t t11f,
t t120, t t121, t t122, t t123, t t124, t t125, t t126, t t127, t t128,
t t129, t t12a, t t12b, t t12c, t t12d, t t12e, t t12f,
t t130, t t131, t t132, t t133, t t134, t t135, t t136, t t137, t t138,
t t139, t t13a, t t13b, t t13c, t t13d, t t13e, t t13f,
t t140, t t141, t t142, t t143, t t144, t t145, t t146, t t147, t t148,
t t149, t t14a, t t14b, t t14c, t t14d, t t14e, t t14f,
t t150, t t151, t t152, t t153, t t154, t t155, t t156, t t157, t t158,
t t159, t t15a, t t15b, t t15c, t t15d, t t15e, t t15f,
t t160, t t161, t t162, t t163, t t164, t t165, t t166, t t167, t t168,
t t169, t t16a, t t16b, t t16c, t t16d, t t16e, t t16f,
t t170, t t171, t t172, t t173, t t174, t t175, t t176, t t177, t t178,
t t179, t t17a, t t17b, t t17c, t t17d, t t17e, t t17f,
t t180, t t181, t t182, t t183, t t184, t t185, t t186, t t187, t t188,
t t189, t t18a, t t18b, t t18c, t t18d, t t18e, t t18f,
t t190, t t191, t t192, t t193, t t194, t t195, t t196, t t197, t t198,
t t199, t t19a, t t19b, t t19c, t t19d, t t19e, t t19f,
t t1a0, t t1a1, t t1a2, t t1a3, t t1a4, t t1a5, t t1a6, t t1a7, t t1a8,
t t1a9, t t1aa, t t1ab, t t1ac, t t1ad, t t1ae, t t1af,
t t1b0, t t1b1, t t1b2, t t1b3, t t1b4, t t1b5, t t1b6, t t1b7, t t1b8,
t t1b9, t t1ba, t t1bb, t t1bc, t t1bd, t t1be, t t1bf
;
SELECT '6 Mi entries written'::text;
INSERT INTO test (
arr000, arr001, arr002, arr003, arr004, arr005, arr006, arr007, arr008,
arr009, arr00a, arr00b, arr00c, arr00d, arr00e, arr00f,
arr010, arr011, arr012, arr013, arr014, arr015, arr016, arr017, arr018,
arr019, arr01a, arr01b, arr01c, arr01d, arr01e, arr01f,
arr020, arr021, arr022, arr023, arr024, arr025, arr026, arr027, arr028,
arr029, arr02a, arr02b, arr02c, arr02d, arr02e, arr02f,
arr030, arr031, arr032, arr033, arr034, arr035, arr036, arr037, arr038,
arr039, arr03a, arr03b, arr03c, arr03d, arr03e, arr03f,
arr040, arr041, arr042, arr043, arr044, arr045, arr046, arr047, arr048,
arr049, arr04a, arr04b, arr04c, arr04d, arr04e, arr04f,
arr050, arr051, arr052, arr053, arr054, arr055, arr056, arr057, arr058,
arr059, arr05a, arr05b, arr05c, arr05d, arr05e, arr05f,
arr060, arr061, arr062, arr063, arr064, arr065, arr066, arr067, arr068,
arr069, arr06a, arr06b, arr06c, arr06d, arr06e, arr06f,
arr070, arr071, arr072, arr073, arr074, arr075, arr076, arr077, arr078,
arr079, arr07a, arr07b, arr07c, arr07d, arr07e, arr07f,
arr080, arr081, arr082, arr083, arr084, arr085, arr086, arr087, arr088,
arr089, arr08a, arr08b, arr08c, arr08d, arr08e, arr08f,
arr090, arr091, arr092, arr093, arr094, arr095, arr096, arr097, arr098,
arr099, arr09a, arr09b, arr09c, arr09d, arr09e, arr09f,
arr0a0, arr0a1, arr0a2, arr0a3, arr0a4, arr0a5, arr0a6, arr0a7, arr0a8,
arr0a9, arr0aa, arr0ab, arr0ac, arr0ad, arr0ae, arr0af,
arr0b0, arr0b1, arr0b2, arr0b3, arr0b4, arr0b5, arr0b6, arr0b7, arr0b8,
arr0b9, arr0ba, arr0bb, arr0bc, arr0bd, arr0be, arr0bf,
arr0c0, arr0c1, arr0c2, arr0c3, arr0c4, arr0c5, arr0c6, arr0c7, arr0c8,
arr0c9, arr0ca, arr0cb, arr0cc, arr0cd, arr0ce, arr0cf,
arr0d0, arr0d1, arr0d2, arr0d3, arr0d4, arr0d5, arr0d6, arr0d7, arr0d8,
arr0d9, arr0da, arr0db, arr0dc, arr0dd, arr0de, arr0df,
arr0e0, arr0e1, arr0e2, arr0e3, arr0e4, arr0e5, arr0e6, arr0e7, arr0e8,
arr0e9, arr0ea, arr0eb, arr0ec, arr0ed, arr0ee, arr0ef,
arr0f0, arr0f1, arr0f2, arr0f3, arr0f4, arr0f5, arr0f6, arr0f7, arr0f8,
arr0f9, arr0fa, arr0fb, arr0fc, arr0fd, arr0fe, arr0ff,
arr100, arr101, arr102, arr103, arr104, arr105, arr106, arr107, arr108,
arr109, arr10a, arr10b, arr10c, arr10d, arr10e, arr10f,
arr110, arr111, arr112, arr113, arr114, arr115, arr116, arr117, arr118,
arr119, arr11a, arr11b, arr11c, arr11d, arr11e, arr11f,
arr120, arr121, arr122, arr123, arr124, arr125, arr126, arr127, arr128,
arr129, arr12a, arr12b, arr12c, arr12d, arr12e, arr12f,
arr130, arr131, arr132, arr133, arr134, arr135, arr136, arr137, arr138,
arr139, arr13a, arr13b, arr13c, arr13d, arr13e, arr13f,
arr140, arr141, arr142, arr143, arr144, arr145, arr146, arr147, arr148,
arr149, arr14a, arr14b, arr14c, arr14d, arr14e, arr14f,
arr150, arr151, arr152, arr153, arr154, arr155, arr156, arr157, arr158,
arr159, arr15a, arr15b, arr15c, arr15d, arr15e, arr15f,
arr160, arr161, arr162, arr163, arr164, arr165, arr166, arr167, arr168,
arr169, arr16a, arr16b, arr16c, arr16d, arr16e, arr16f,
arr170, arr171, arr172, arr173, arr174, arr175, arr176, arr177, arr178,
arr179, arr17a, arr17b, arr17c, arr17d, arr17e, arr17f,
arr180, arr181, arr182, arr183, arr184, arr185, arr186, arr187, arr188,
arr189, arr18a, arr18b, arr18c, arr18d, arr18e, arr18f,
arr190, arr191, arr192, arr193, arr194, arr195, arr196, arr197, arr198,
arr199, arr19a, arr19b, arr19c, arr19d, arr19e, arr19f,
arr1a0, arr1a1, arr1a2, arr1a3, arr1a4, arr1a5, arr1a6, arr1a7, arr1a8,
arr1a9, arr1aa, arr1ab, arr1ac, arr1ad, arr1ae, arr1af,
arr1b0, arr1b1, arr1b2, arr1b3, arr1b4, arr1b5, arr1b6, arr1b7, arr1b8,
arr1b9, arr1ba, arr1bb, arr1bc, arr1bd, arr1be, arr1bf
)
WITH t AS (SELECT '{null}'::Integer[] AS v)
SELECT
t000.v, t001.v, t002.v, t003.v, t004.v, t005.v, t006.v, t007.v, t008.v,
t009.v, t00a.v, t00b.v, t00c.v, t00d.v, t00e.v, t00f.v,
t010.v, t011.v, t012.v, t013.v, t014.v, t015.v, t016.v, t017.v, t018.v,
t019.v, t01a.v, t01b.v, t01c.v, t01d.v, t01e.v, t01f.v,
t020.v, t021.v, t022.v, t023.v, t024.v, t025.v, t026.v, t027.v, t028.v,
t029.v, t02a.v, t02b.v, t02c.v, t02d.v, t02e.v, t02f.v,
t030.v, t031.v, t032.v, t033.v, t034.v, t035.v, t036.v, t037.v, t038.v,
t039.v, t03a.v, t03b.v, t03c.v, t03d.v, t03e.v, t03f.v,
t040.v, t041.v, t042.v, t043.v, t044.v, t045.v, t046.v, t047.v, t048.v,
t049.v, t04a.v, t04b.v, t04c.v, t04d.v, t04e.v, t04f.v,
t050.v, t051.v, t052.v, t053.v, t054.v, t055.v, t056.v, t057.v, t058.v,
t059.v, t05a.v, t05b.v, t05c.v, t05d.v, t05e.v, t05f.v,
t060.v, t061.v, t062.v, t063.v, t064.v, t065.v, t066.v, t067.v, t068.v,
t069.v, t06a.v, t06b.v, t06c.v, t06d.v, t06e.v, t06f.v,
t070.v, t071.v, t072.v, t073.v, t074.v, t075.v, t076.v, t077.v, t078.v,
t079.v, t07a.v, t07b.v, t07c.v, t07d.v, t07e.v, t07f.v,
t080.v, t081.v, t082.v, t083.v, t084.v, t085.v, t086.v, t087.v, t088.v,
t089.v, t08a.v, t08b.v, t08c.v, t08d.v, t08e.v, t08f.v,
t090.v, t091.v, t092.v, t093.v, t094.v, t095.v, t096.v, t097.v, t098.v,
t099.v, t09a.v, t09b.v, t09c.v, t09d.v, t09e.v, t09f.v,
t0a0.v, t0a1.v, t0a2.v, t0a3.v, t0a4.v, t0a5.v, t0a6.v, t0a7.v, t0a8.v,
t0a9.v, t0aa.v, t0ab.v, t0ac.v, t0ad.v, t0ae.v, t0af.v,
t0b0.v, t0b1.v, t0b2.v, t0b3.v, t0b4.v, t0b5.v, t0b6.v, t0b7.v, t0b8.v,
t0b9.v, t0ba.v, t0bb.v, t0bc.v, t0bd.v, t0be.v, t0bf.v,
t0c0.v, t0c1.v, t0c2.v, t0c3.v, t0c4.v, t0c5.v, t0c6.v, t0c7.v, t0c8.v,
t0c9.v, t0ca.v, t0cb.v, t0cc.v, t0cd.v, t0ce.v, t0cf.v,
t0d0.v, t0d1.v, t0d2.v, t0d3.v, t0d4.v, t0d5.v, t0d6.v, t0d7.v, t0d8.v,
t0d9.v, t0da.v, t0db.v, t0dc.v, t0dd.v, t0de.v, t0df.v,
t0e0.v, t0e1.v, t0e2.v, t0e3.v, t0e4.v, t0e5.v, t0e6.v, t0e7.v, t0e8.v,
t0e9.v, t0ea.v, t0eb.v, t0ec.v, t0ed.v, t0ee.v, t0ef.v,
t0f0.v, t0f1.v, t0f2.v, t0f3.v, t0f4.v, t0f5.v, t0f6.v, t0f7.v, t0f8.v,
t0f9.v, t0fa.v, t0fb.v, t0fc.v, t0fd.v, t0fe.v, t0ff.v,
t100.v, t101.v, t102.v, t103.v, t104.v, t105.v, t106.v, t107.v, t108.v,
t109.v, t10a.v, t10b.v, t10c.v, t10d.v, t10e.v, t10f.v,
t110.v, t111.v, t112.v, t113.v, t114.v, t115.v, t116.v, t117.v, t118.v,
t119.v, t11a.v, t11b.v, t11c.v, t11d.v, t11e.v, t11f.v,
t120.v, t121.v, t122.v, t123.v, t124.v, t125.v, t126.v, t127.v, t128.v,
t129.v, t12a.v, t12b.v, t12c.v, t12d.v, t12e.v, t12f.v,
t130.v, t131.v, t132.v, t133.v, t134.v, t135.v, t136.v, t137.v, t138.v,
t139.v, t13a.v, t13b.v, t13c.v, t13d.v, t13e.v, t13f.v,
t140.v, t141.v, t142.v, t143.v, t144.v, t145.v, t146.v, t147.v, t148.v,
t149.v, t14a.v, t14b.v, t14c.v, t14d.v, t14e.v, t14f.v,
t150.v, t151.v, t152.v, t153.v, t154.v, t155.v, t156.v, t157.v, t158.v,
t159.v, t15a.v, t15b.v, t15c.v, t15d.v, t15e.v, t15f.v,
t160.v, t161.v, t162.v, t163.v, t164.v, t165.v, t166.v, t167.v, t168.v,
t169.v, t16a.v, t16b.v, t16c.v, t16d.v, t16e.v, t16f.v,
t170.v, t171.v, t172.v, t173.v, t174.v, t175.v, t176.v, t177.v, t178.v,
t179.v, t17a.v, t17b.v, t17c.v, t17d.v, t17e.v, t17f.v,
t180.v, t181.v, t182.v, t183.v, t184.v, t185.v, t186.v, t187.v, t188.v,
t189.v, t18a.v, t18b.v, t18c.v, t18d.v, t18e.v, t18f.v,
t190.v, t191.v, t192.v, t193.v, t194.v, t195.v, t196.v, t197.v, t198.v,
t199.v, t19a.v, t19b.v, t19c.v, t19d.v, t19e.v, t19f.v,
t1a0.v, t1a1.v, t1a2.v, t1a3.v, t1a4.v, t1a5.v, t1a6.v, t1a7.v, t1a8.v,
t1a9.v, t1aa.v, t1ab.v, t1ac.v, t1ad.v, t1ae.v, t1af.v,
t1b0.v, t1b1.v, t1b2.v, t1b3.v, t1b4.v, t1b5.v, t1b6.v, t1b7.v, t1b8.v,
t1b9.v, t1ba.v, t1bb.v, t1bc.v, t1bd.v, t1be.v, t1bf.v
FROM
generate_series(1, 1024*1024),
t t000, t t001, t t002, t t003, t t004, t t005, t t006, t t007, t t008,
t t009, t t00a, t t00b, t t00c, t t00d, t t00e, t t00f,
t t010, t t011, t t012, t t013, t t014, t t015, t t016, t t017, t t018,
t t019, t t01a, t t01b, t t01c, t t01d, t t01e, t t01f,
t t020, t t021, t t022, t t023, t t024, t t025, t t026, t t027, t t028,
t t029, t t02a, t t02b, t t02c, t t02d, t t02e, t t02f,
t t030, t t031, t t032, t t033, t t034, t t035, t t036, t t037, t t038,
t t039, t t03a, t t03b, t t03c, t t03d, t t03e, t t03f,
t t040, t t041, t t042, t t043, t t044, t t045, t t046, t t047, t t048,
t t049, t t04a, t t04b, t t04c, t t04d, t t04e, t t04f,
t t050, t t051, t t052, t t053, t t054, t t055, t t056, t t057, t t058,
t t059, t t05a, t t05b, t t05c, t t05d, t t05e, t t05f,
t t060, t t061, t t062, t t063, t t064, t t065, t t066, t t067, t t068,
t t069, t t06a, t t06b, t t06c, t t06d, t t06e, t t06f,
t t070, t t071, t t072, t t073, t t074, t t075, t t076, t t077, t t078,
t t079, t t07a, t t07b, t t07c, t t07d, t t07e, t t07f,
t t080, t t081, t t082, t t083, t t084, t t085, t t086, t t087, t t088,
t t089, t t08a, t t08b, t t08c, t t08d, t t08e, t t08f,
t t090, t t091, t t092, t t093, t t094, t t095, t t096, t t097, t t098,
t t099, t t09a, t t09b, t t09c, t t09d, t t09e, t t09f,
t t0a0, t t0a1, t t0a2, t t0a3, t t0a4, t t0a5, t t0a6, t t0a7, t t0a8,
t t0a9, t t0aa, t t0ab, t t0ac, t t0ad, t t0ae, t t0af,
t t0b0, t t0b1, t t0b2, t t0b3, t t0b4, t t0b5, t t0b6, t t0b7, t t0b8,
t t0b9, t t0ba, t t0bb, t t0bc, t t0bd, t t0be, t t0bf,
t t0c0, t t0c1, t t0c2, t t0c3, t t0c4, t t0c5, t t0c6, t t0c7, t t0c8,
t t0c9, t t0ca, t t0cb, t t0cc, t t0cd, t t0ce, t t0cf,
t t0d0, t t0d1, t t0d2, t t0d3, t t0d4, t t0d5, t t0d6, t t0d7, t t0d8,
t t0d9, t t0da, t t0db, t t0dc, t t0dd, t t0de, t t0df,
t t0e0, t t0e1, t t0e2, t t0e3, t t0e4, t t0e5, t t0e6, t t0e7, t t0e8,
t t0e9, t t0ea, t t0eb, t t0ec, t t0ed, t t0ee, t t0ef,
t t0f0, t t0f1, t t0f2, t t0f3, t t0f4, t t0f5, t t0f6, t t0f7, t t0f8,
t t0f9, t t0fa, t t0fb, t t0fc, t t0fd, t t0fe, t t0ff,
t t100, t t101, t t102, t t103, t t104, t t105, t t106, t t107, t t108,
t t109, t t10a, t t10b, t t10c, t t10d, t t10e, t t10f,
t t110, t t111, t t112, t t113, t t114, t t115, t t116, t t117, t t118,
t t119, t t11a, t t11b, t t11c, t t11d, t t11e, t t11f,
t t120, t t121, t t122, t t123, t t124, t t125, t t126, t t127, t t128,
t t129, t t12a, t t12b, t t12c, t t12d, t t12e, t t12f,
t t130, t t131, t t132, t t133, t t134, t t135, t t136, t t137, t t138,
t t139, t t13a, t t13b, t t13c, t t13d, t t13e, t t13f,
t t140, t t141, t t142, t t143, t t144, t t145, t t146, t t147, t t148,
t t149, t t14a, t t14b, t t14c, t t14d, t t14e, t t14f,
t t150, t t151, t t152, t t153, t t154, t t155, t t156, t t157, t t158,
t t159, t t15a, t t15b, t t15c, t t15d, t t15e, t t15f,
t t160, t t161, t t162, t t163, t t164, t t165, t t166, t t167, t t168,
t t169, t t16a, t t16b, t t16c, t t16d, t t16e, t t16f,
t t170, t t171, t t172, t t173, t t174, t t175, t t176, t t177, t t178,
t t179, t t17a, t t17b, t t17c, t t17d, t t17e, t t17f,
t t180, t t181, t t182, t t183, t t184, t t185, t t186, t t187, t t188,
t t189, t t18a, t t18b, t t18c, t t18d, t t18e, t t18f,
t t190, t t191, t t192, t t193, t t194, t t195, t t196, t t197, t t198,
t t199, t t19a, t t19b, t t19c, t t19d, t t19e, t t19f,
t t1a0, t t1a1, t t1a2, t t1a3, t t1a4, t t1a5, t t1a6, t t1a7, t t1a8,
t t1a9, t t1aa, t t1ab, t t1ac, t t1ad, t t1ae, t t1af,
t t1b0, t t1b1, t t1b2, t t1b3, t t1b4, t t1b5, t t1b6, t t1b7, t t1b8,
t t1b9, t t1ba, t t1bb, t t1bc, t t1bd, t t1be, t t1bf
;
SELECT '7 Mi entries written'::text;
INSERT INTO test (
arr000, arr001, arr002, arr003, arr004, arr005, arr006, arr007, arr008,
arr009, arr00a, arr00b, arr00c, arr00d, arr00e, arr00f,
arr010, arr011, arr012, arr013, arr014, arr015, arr016, arr017, arr018,
arr019, arr01a, arr01b, arr01c, arr01d, arr01e, arr01f,
arr020, arr021, arr022, arr023, arr024, arr025, arr026, arr027, arr028,
arr029, arr02a, arr02b, arr02c, arr02d, arr02e, arr02f,
arr030, arr031, arr032, arr033, arr034, arr035, arr036, arr037, arr038,
arr039, arr03a, arr03b, arr03c, arr03d, arr03e, arr03f,
arr040, arr041, arr042, arr043, arr044, arr045, arr046, arr047, arr048,
arr049, arr04a, arr04b, arr04c, arr04d, arr04e, arr04f,
arr050, arr051, arr052, arr053, arr054, arr055, arr056, arr057, arr058,
arr059, arr05a, arr05b, arr05c, arr05d, arr05e, arr05f,
arr060, arr061, arr062, arr063, arr064, arr065, arr066, arr067, arr068,
arr069, arr06a, arr06b, arr06c, arr06d, arr06e, arr06f,
arr070, arr071, arr072, arr073, arr074, arr075, arr076, arr077, arr078,
arr079, arr07a, arr07b, arr07c, arr07d, arr07e, arr07f,
arr080, arr081, arr082, arr083, arr084, arr085, arr086, arr087, arr088,
arr089, arr08a, arr08b, arr08c, arr08d, arr08e, arr08f,
arr090, arr091, arr092, arr093, arr094, arr095, arr096, arr097, arr098,
arr099, arr09a, arr09b, arr09c, arr09d, arr09e, arr09f,
arr0a0, arr0a1, arr0a2, arr0a3, arr0a4, arr0a5, arr0a6, arr0a7, arr0a8,
arr0a9, arr0aa, arr0ab, arr0ac, arr0ad, arr0ae, arr0af,
arr0b0, arr0b1, arr0b2, arr0b3, arr0b4, arr0b5, arr0b6, arr0b7, arr0b8,
arr0b9, arr0ba, arr0bb, arr0bc, arr0bd, arr0be, arr0bf,
arr0c0, arr0c1, arr0c2, arr0c3, arr0c4, arr0c5, arr0c6, arr0c7, arr0c8,
arr0c9, arr0ca, arr0cb, arr0cc, arr0cd, arr0ce, arr0cf,
arr0d0, arr0d1, arr0d2, arr0d3, arr0d4, arr0d5, arr0d6, arr0d7, arr0d8,
arr0d9, arr0da, arr0db, arr0dc, arr0dd, arr0de, arr0df,
arr0e0, arr0e1, arr0e2, arr0e3, arr0e4, arr0e5, arr0e6, arr0e7, arr0e8,
arr0e9, arr0ea, arr0eb, arr0ec, arr0ed, arr0ee, arr0ef,
arr0f0, arr0f1, arr0f2, arr0f3, arr0f4, arr0f5, arr0f6, arr0f7, arr0f8,
arr0f9, arr0fa, arr0fb, arr0fc, arr0fd, arr0fe, arr0ff,
arr100, arr101, arr102, arr103, arr104, arr105, arr106, arr107, arr108,
arr109, arr10a, arr10b, arr10c, arr10d, arr10e, arr10f,
arr110, arr111, arr112, arr113, arr114, arr115, arr116, arr117, arr118,
arr119, arr11a, arr11b, arr11c, arr11d, arr11e, arr11f,
arr120, arr121, arr122, arr123, arr124, arr125, arr126, arr127, arr128,
arr129, arr12a, arr12b, arr12c, arr12d, arr12e, arr12f,
arr130, arr131, arr132, arr133, arr134, arr135, arr136, arr137, arr138,
arr139, arr13a, arr13b, arr13c, arr13d, arr13e, arr13f,
arr140, arr141, arr142, arr143, arr144, arr145, arr146, arr147, arr148,
arr149, arr14a, arr14b, arr14c, arr14d, arr14e, arr14f,
arr150, arr151, arr152, arr153, arr154, arr155, arr156, arr157, arr158,
arr159, arr15a, arr15b, arr15c, arr15d, arr15e, arr15f,
arr160, arr161, arr162, arr163, arr164, arr165, arr166, arr167, arr168,
arr169, arr16a, arr16b, arr16c, arr16d, arr16e, arr16f,
arr170, arr171, arr172, arr173, arr174, arr175, arr176, arr177, arr178,
arr179, arr17a, arr17b, arr17c, arr17d, arr17e, arr17f,
arr180, arr181, arr182, arr183, arr184, arr185, arr186, arr187, arr188,
arr189, arr18a, arr18b, arr18c, arr18d, arr18e, arr18f,
arr190, arr191, arr192, arr193, arr194, arr195, arr196, arr197, arr198,
arr199, arr19a, arr19b, arr19c, arr19d, arr19e, arr19f,
arr1a0, arr1a1, arr1a2, arr1a3, arr1a4, arr1a5, arr1a6, arr1a7, arr1a8,
arr1a9, arr1aa, arr1ab, arr1ac, arr1ad, arr1ae, arr1af,
arr1b0, arr1b1, arr1b2, arr1b3, arr1b4, arr1b5, arr1b6, arr1b7, arr1b8,
arr1b9, arr1ba, arr1bb, arr1bc, arr1bd, arr1be, arr1bf
)
WITH t AS (SELECT '{null}'::Integer[] AS v)
SELECT
t000.v, t001.v, t002.v, t003.v, t004.v, t005.v, t006.v, t007.v, t008.v,
t009.v, t00a.v, t00b.v, t00c.v, t00d.v, t00e.v, t00f.v,
t010.v, t011.v, t012.v, t013.v, t014.v, t015.v, t016.v, t017.v, t018.v,
t019.v, t01a.v, t01b.v, t01c.v, t01d.v, t01e.v, t01f.v,
t020.v, t021.v, t022.v, t023.v, t024.v, t025.v, t026.v, t027.v, t028.v,
t029.v, t02a.v, t02b.v, t02c.v, t02d.v, t02e.v, t02f.v,
t030.v, t031.v, t032.v, t033.v, t034.v, t035.v, t036.v, t037.v, t038.v,
t039.v, t03a.v, t03b.v, t03c.v, t03d.v, t03e.v, t03f.v,
t040.v, t041.v, t042.v, t043.v, t044.v, t045.v, t046.v, t047.v, t048.v,
t049.v, t04a.v, t04b.v, t04c.v, t04d.v, t04e.v, t04f.v,
t050.v, t051.v, t052.v, t053.v, t054.v, t055.v, t056.v, t057.v, t058.v,
t059.v, t05a.v, t05b.v, t05c.v, t05d.v, t05e.v, t05f.v,
t060.v, t061.v, t062.v, t063.v, t064.v, t065.v, t066.v, t067.v, t068.v,
t069.v, t06a.v, t06b.v, t06c.v, t06d.v, t06e.v, t06f.v,
t070.v, t071.v, t072.v, t073.v, t074.v, t075.v, t076.v, t077.v, t078.v,
t079.v, t07a.v, t07b.v, t07c.v, t07d.v, t07e.v, t07f.v,
t080.v, t081.v, t082.v, t083.v, t084.v, t085.v, t086.v, t087.v, t088.v,
t089.v, t08a.v, t08b.v, t08c.v, t08d.v, t08e.v, t08f.v,
t090.v, t091.v, t092.v, t093.v, t094.v, t095.v, t096.v, t097.v, t098.v,
t099.v, t09a.v, t09b.v, t09c.v, t09d.v, t09e.v, t09f.v,
t0a0.v, t0a1.v, t0a2.v, t0a3.v, t0a4.v, t0a5.v, t0a6.v, t0a7.v, t0a8.v,
t0a9.v, t0aa.v, t0ab.v, t0ac.v, t0ad.v, t0ae.v, t0af.v,
t0b0.v, t0b1.v, t0b2.v, t0b3.v, t0b4.v, t0b5.v, t0b6.v, t0b7.v, t0b8.v,
t0b9.v, t0ba.v, t0bb.v, t0bc.v, t0bd.v, t0be.v, t0bf.v,
t0c0.v, t0c1.v, t0c2.v, t0c3.v, t0c4.v, t0c5.v, t0c6.v, t0c7.v, t0c8.v,
t0c9.v, t0ca.v, t0cb.v, t0cc.v, t0cd.v, t0ce.v, t0cf.v,
t0d0.v, t0d1.v, t0d2.v, t0d3.v, t0d4.v, t0d5.v, t0d6.v, t0d7.v, t0d8.v,
t0d9.v, t0da.v, t0db.v, t0dc.v, t0dd.v, t0de.v, t0df.v,
t0e0.v, t0e1.v, t0e2.v, t0e3.v, t0e4.v, t0e5.v, t0e6.v, t0e7.v, t0e8.v,
t0e9.v, t0ea.v, t0eb.v, t0ec.v, t0ed.v, t0ee.v, t0ef.v,
t0f0.v, t0f1.v, t0f2.v, t0f3.v, t0f4.v, t0f5.v, t0f6.v, t0f7.v, t0f8.v,
t0f9.v, t0fa.v, t0fb.v, t0fc.v, t0fd.v, t0fe.v, t0ff.v,
t100.v, t101.v, t102.v, t103.v, t104.v, t105.v, t106.v, t107.v, t108.v,
t109.v, t10a.v, t10b.v, t10c.v, t10d.v, t10e.v, t10f.v,
t110.v, t111.v, t112.v, t113.v, t114.v, t115.v, t116.v, t117.v, t118.v,
t119.v, t11a.v, t11b.v, t11c.v, t11d.v, t11e.v, t11f.v,
t120.v, t121.v, t122.v, t123.v, t124.v, t125.v, t126.v, t127.v, t128.v,
t129.v, t12a.v, t12b.v, t12c.v, t12d.v, t12e.v, t12f.v,
t130.v, t131.v, t132.v, t133.v, t134.v, t135.v, t136.v, t137.v, t138.v,
t139.v, t13a.v, t13b.v, t13c.v, t13d.v, t13e.v, t13f.v,
t140.v, t141.v, t142.v, t143.v, t144.v, t145.v, t146.v, t147.v, t148.v,
t149.v, t14a.v, t14b.v, t14c.v, t14d.v, t14e.v, t14f.v,
t150.v, t151.v, t152.v, t153.v, t154.v, t155.v, t156.v, t157.v, t158.v,
t159.v, t15a.v, t15b.v, t15c.v, t15d.v, t15e.v, t15f.v,
t160.v, t161.v, t162.v, t163.v, t164.v, t165.v, t166.v, t167.v, t168.v,
t169.v, t16a.v, t16b.v, t16c.v, t16d.v, t16e.v, t16f.v,
t170.v, t171.v, t172.v, t173.v, t174.v, t175.v, t176.v, t177.v, t178.v,
t179.v, t17a.v, t17b.v, t17c.v, t17d.v, t17e.v, t17f.v,
t180.v, t181.v, t182.v, t183.v, t184.v, t185.v, t186.v, t187.v, t188.v,
t189.v, t18a.v, t18b.v, t18c.v, t18d.v, t18e.v, t18f.v,
t190.v, t191.v, t192.v, t193.v, t194.v, t195.v, t196.v, t197.v, t198.v,
t199.v, t19a.v, t19b.v, t19c.v, t19d.v, t19e.v, t19f.v,
t1a0.v, t1a1.v, t1a2.v, t1a3.v, t1a4.v, t1a5.v, t1a6.v, t1a7.v, t1a8.v,
t1a9.v, t1aa.v, t1ab.v, t1ac.v, t1ad.v, t1ae.v, t1af.v,
t1b0.v, t1b1.v, t1b2.v, t1b3.v, t1b4.v, t1b5.v, t1b6.v, t1b7.v, t1b8.v,
t1b9.v, t1ba.v, t1bb.v, t1bc.v, t1bd.v, t1be.v, t1bf.v
FROM
generate_series(1, 1024*1024),
t t000, t t001, t t002, t t003, t t004, t t005, t t006, t t007, t t008,
t t009, t t00a, t t00b, t t00c, t t00d, t t00e, t t00f,
t t010, t t011, t t012, t t013, t t014, t t015, t t016, t t017, t t018,
t t019, t t01a, t t01b, t t01c, t t01d, t t01e, t t01f,
t t020, t t021, t t022, t t023, t t024, t t025, t t026, t t027, t t028,
t t029, t t02a, t t02b, t t02c, t t02d, t t02e, t t02f,
t t030, t t031, t t032, t t033, t t034, t t035, t t036, t t037, t t038,
t t039, t t03a, t t03b, t t03c, t t03d, t t03e, t t03f,
t t040, t t041, t t042, t t043, t t044, t t045, t t046, t t047, t t048,
t t049, t t04a, t t04b, t t04c, t t04d, t t04e, t t04f,
t t050, t t051, t t052, t t053, t t054, t t055, t t056, t t057, t t058,
t t059, t t05a, t t05b, t t05c, t t05d, t t05e, t t05f,
t t060, t t061, t t062, t t063, t t064, t t065, t t066, t t067, t t068,
t t069, t t06a, t t06b, t t06c, t t06d, t t06e, t t06f,
t t070, t t071, t t072, t t073, t t074, t t075, t t076, t t077, t t078,
t t079, t t07a, t t07b, t t07c, t t07d, t t07e, t t07f,
t t080, t t081, t t082, t t083, t t084, t t085, t t086, t t087, t t088,
t t089, t t08a, t t08b, t t08c, t t08d, t t08e, t t08f,
t t090, t t091, t t092, t t093, t t094, t t095, t t096, t t097, t t098,
t t099, t t09a, t t09b, t t09c, t t09d, t t09e, t t09f,
t t0a0, t t0a1, t t0a2, t t0a3, t t0a4, t t0a5, t t0a6, t t0a7, t t0a8,
t t0a9, t t0aa, t t0ab, t t0ac, t t0ad, t t0ae, t t0af,
t t0b0, t t0b1, t t0b2, t t0b3, t t0b4, t t0b5, t t0b6, t t0b7, t t0b8,
t t0b9, t t0ba, t t0bb, t t0bc, t t0bd, t t0be, t t0bf,
t t0c0, t t0c1, t t0c2, t t0c3, t t0c4, t t0c5, t t0c6, t t0c7, t t0c8,
t t0c9, t t0ca, t t0cb, t t0cc, t t0cd, t t0ce, t t0cf,
t t0d0, t t0d1, t t0d2, t t0d3, t t0d4, t t0d5, t t0d6, t t0d7, t t0d8,
t t0d9, t t0da, t t0db, t t0dc, t t0dd, t t0de, t t0df,
t t0e0, t t0e1, t t0e2, t t0e3, t t0e4, t t0e5, t t0e6, t t0e7, t t0e8,
t t0e9, t t0ea, t t0eb, t t0ec, t t0ed, t t0ee, t t0ef,
t t0f0, t t0f1, t t0f2, t t0f3, t t0f4, t t0f5, t t0f6, t t0f7, t t0f8,
t t0f9, t t0fa, t t0fb, t t0fc, t t0fd, t t0fe, t t0ff,
t t100, t t101, t t102, t t103, t t104, t t105, t t106, t t107, t t108,
t t109, t t10a, t t10b, t t10c, t t10d, t t10e, t t10f,
t t110, t t111, t t112, t t113, t t114, t t115, t t116, t t117, t t118,
t t119, t t11a, t t11b, t t11c, t t11d, t t11e, t t11f,
t t120, t t121, t t122, t t123, t t124, t t125, t t126, t t127, t t128,
t t129, t t12a, t t12b, t t12c, t t12d, t t12e, t t12f,
t t130, t t131, t t132, t t133, t t134, t t135, t t136, t t137, t t138,
t t139, t t13a, t t13b, t t13c, t t13d, t t13e, t t13f,
t t140, t t141, t t142, t t143, t t144, t t145, t t146, t t147, t t148,
t t149, t t14a, t t14b, t t14c, t t14d, t t14e, t t14f,
t t150, t t151, t t152, t t153, t t154, t t155, t t156, t t157, t t158,
t t159, t t15a, t t15b, t t15c, t t15d, t t15e, t t15f,
t t160, t t161, t t162, t t163, t t164, t t165, t t166, t t167, t t168,
t t169, t t16a, t t16b, t t16c, t t16d, t t16e, t t16f,
t t170, t t171, t t172, t t173, t t174, t t175, t t176, t t177, t t178,
t t179, t t17a, t t17b, t t17c, t t17d, t t17e, t t17f,
t t180, t t181, t t182, t t183, t t184, t t185, t t186, t t187, t t188,
t t189, t t18a, t t18b, t t18c, t t18d, t t18e, t t18f,
t t190, t t191, t t192, t t193, t t194, t t195, t t196, t t197, t t198,
t t199, t t19a, t t19b, t t19c, t t19d, t t19e, t t19f,
t t1a0, t t1a1, t t1a2, t t1a3, t t1a4, t t1a5, t t1a6, t t1a7, t t1a8,
t t1a9, t t1aa, t t1ab, t t1ac, t t1ad, t t1ae, t t1af,
t t1b0, t t1b1, t t1b2, t t1b3, t t1b4, t t1b5, t t1b6, t t1b7, t t1b8,
t t1b9, t t1ba, t t1bb, t t1bc, t t1bd, t t1be, t t1bf
;
SELECT '8 Mi entries written'::text;
INSERT INTO test (
arr000, arr001, arr002, arr003, arr004, arr005, arr006, arr007, arr008,
arr009, arr00a, arr00b, arr00c, arr00d, arr00e, arr00f,
arr010, arr011, arr012, arr013, arr014, arr015, arr016, arr017, arr018,
arr019, arr01a, arr01b, arr01c, arr01d, arr01e, arr01f,
arr020, arr021, arr022, arr023, arr024, arr025, arr026, arr027, arr028,
arr029, arr02a, arr02b, arr02c, arr02d, arr02e, arr02f,
arr030, arr031, arr032, arr033, arr034, arr035, arr036, arr037, arr038,
arr039, arr03a, arr03b, arr03c, arr03d, arr03e, arr03f,
arr040, arr041, arr042, arr043, arr044, arr045, arr046, arr047, arr048,
arr049, arr04a, arr04b, arr04c, arr04d, arr04e, arr04f,
arr050, arr051, arr052, arr053, arr054, arr055, arr056, arr057, arr058,
arr059, arr05a, arr05b, arr05c, arr05d, arr05e, arr05f,
arr060, arr061, arr062, arr063, arr064, arr065, arr066, arr067, arr068,
arr069, arr06a, arr06b, arr06c, arr06d, arr06e, arr06f,
arr070, arr071, arr072, arr073, arr074, arr075, arr076, arr077, arr078,
arr079, arr07a, arr07b, arr07c, arr07d, arr07e, arr07f,
arr080, arr081, arr082, arr083, arr084, arr085, arr086, arr087, arr088,
arr089, arr08a, arr08b, arr08c, arr08d, arr08e, arr08f,
arr090, arr091, arr092, arr093, arr094, arr095, arr096, arr097, arr098,
arr099, arr09a, arr09b, arr09c, arr09d, arr09e, arr09f,
arr0a0, arr0a1, arr0a2, arr0a3, arr0a4, arr0a5, arr0a6, arr0a7, arr0a8,
arr0a9, arr0aa, arr0ab, arr0ac, arr0ad, arr0ae, arr0af,
arr0b0, arr0b1, arr0b2, arr0b3, arr0b4, arr0b5, arr0b6, arr0b7, arr0b8,
arr0b9, arr0ba, arr0bb, arr0bc, arr0bd, arr0be, arr0bf,
arr0c0, arr0c1, arr0c2, arr0c3, arr0c4, arr0c5, arr0c6, arr0c7, arr0c8,
arr0c9, arr0ca, arr0cb, arr0cc, arr0cd, arr0ce, arr0cf,
arr0d0, arr0d1, arr0d2, arr0d3, arr0d4, arr0d5, arr0d6, arr0d7, arr0d8,
arr0d9, arr0da, arr0db, arr0dc, arr0dd, arr0de, arr0df,
arr0e0, arr0e1, arr0e2, arr0e3, arr0e4, arr0e5, arr0e6, arr0e7, arr0e8,
arr0e9, arr0ea, arr0eb, arr0ec, arr0ed, arr0ee, arr0ef,
arr0f0, arr0f1, arr0f2, arr0f3, arr0f4, arr0f5, arr0f6, arr0f7, arr0f8,
arr0f9, arr0fa, arr0fb, arr0fc, arr0fd, arr0fe, arr0ff,
arr100, arr101, arr102, arr103, arr104, arr105, arr106, arr107, arr108,
arr109, arr10a, arr10b, arr10c, arr10d, arr10e, arr10f,
arr110, arr111, arr112, arr113, arr114, arr115, arr116, arr117, arr118,
arr119, arr11a, arr11b, arr11c, arr11d, arr11e, arr11f,
arr120, arr121, arr122, arr123, arr124, arr125, arr126, arr127, arr128,
arr129, arr12a, arr12b, arr12c, arr12d, arr12e, arr12f,
arr130, arr131, arr132, arr133, arr134, arr135, arr136, arr137, arr138,
arr139, arr13a, arr13b, arr13c, arr13d, arr13e, arr13f,
arr140, arr141, arr142, arr143, arr144, arr145, arr146, arr147, arr148,
arr149, arr14a, arr14b, arr14c, arr14d, arr14e, arr14f,
arr150, arr151, arr152, arr153, arr154, arr155, arr156, arr157, arr158,
arr159, arr15a, arr15b, arr15c, arr15d, arr15e, arr15f,
arr160, arr161, arr162, arr163, arr164, arr165, arr166, arr167, arr168,
arr169, arr16a, arr16b, arr16c, arr16d, arr16e, arr16f,
arr170, arr171, arr172, arr173, arr174, arr175, arr176, arr177, arr178,
arr179, arr17a, arr17b, arr17c, arr17d, arr17e, arr17f,
arr180, arr181, arr182, arr183, arr184, arr185, arr186, arr187, arr188,
arr189, arr18a, arr18b, arr18c, arr18d, arr18e, arr18f,
arr190, arr191, arr192, arr193, arr194, arr195, arr196, arr197, arr198,
arr199, arr19a, arr19b, arr19c, arr19d, arr19e, arr19f,
arr1a0, arr1a1, arr1a2, arr1a3, arr1a4, arr1a5, arr1a6, arr1a7, arr1a8,
arr1a9, arr1aa, arr1ab, arr1ac, arr1ad, arr1ae, arr1af,
arr1b0, arr1b1, arr1b2, arr1b3, arr1b4, arr1b5, arr1b6, arr1b7, arr1b8,
arr1b9, arr1ba, arr1bb, arr1bc, arr1bd, arr1be, arr1bf
)
WITH t AS (SELECT '{null}'::Integer[] AS v)
SELECT
t000.v, t001.v, t002.v, t003.v, t004.v, t005.v, t006.v, t007.v, t008.v,
t009.v, t00a.v, t00b.v, t00c.v, t00d.v, t00e.v, t00f.v,
t010.v, t011.v, t012.v, t013.v, t014.v, t015.v, t016.v, t017.v, t018.v,
t019.v, t01a.v, t01b.v, t01c.v, t01d.v, t01e.v, t01f.v,
t020.v, t021.v, t022.v, t023.v, t024.v, t025.v, t026.v, t027.v, t028.v,
t029.v, t02a.v, t02b.v, t02c.v, t02d.v, t02e.v, t02f.v,
t030.v, t031.v, t032.v, t033.v, t034.v, t035.v, t036.v, t037.v, t038.v,
t039.v, t03a.v, t03b.v, t03c.v, t03d.v, t03e.v, t03f.v,
t040.v, t041.v, t042.v, t043.v, t044.v, t045.v, t046.v, t047.v, t048.v,
t049.v, t04a.v, t04b.v, t04c.v, t04d.v, t04e.v, t04f.v,
t050.v, t051.v, t052.v, t053.v, t054.v, t055.v, t056.v, t057.v, t058.v,
t059.v, t05a.v, t05b.v, t05c.v, t05d.v, t05e.v, t05f.v,
t060.v, t061.v, t062.v, t063.v, t064.v, t065.v, t066.v, t067.v, t068.v,
t069.v, t06a.v, t06b.v, t06c.v, t06d.v, t06e.v, t06f.v,
t070.v, t071.v, t072.v, t073.v, t074.v, t075.v, t076.v, t077.v, t078.v,
t079.v, t07a.v, t07b.v, t07c.v, t07d.v, t07e.v, t07f.v,
t080.v, t081.v, t082.v, t083.v, t084.v, t085.v, t086.v, t087.v, t088.v,
t089.v, t08a.v, t08b.v, t08c.v, t08d.v, t08e.v, t08f.v,
t090.v, t091.v, t092.v, t093.v, t094.v, t095.v, t096.v, t097.v, t098.v,
t099.v, t09a.v, t09b.v, t09c.v, t09d.v, t09e.v, t09f.v,
t0a0.v, t0a1.v, t0a2.v, t0a3.v, t0a4.v, t0a5.v, t0a6.v, t0a7.v, t0a8.v,
t0a9.v, t0aa.v, t0ab.v, t0ac.v, t0ad.v, t0ae.v, t0af.v,
t0b0.v, t0b1.v, t0b2.v, t0b3.v, t0b4.v, t0b5.v, t0b6.v, t0b7.v, t0b8.v,
t0b9.v, t0ba.v, t0bb.v, t0bc.v, t0bd.v, t0be.v, t0bf.v,
t0c0.v, t0c1.v, t0c2.v, t0c3.v, t0c4.v, t0c5.v, t0c6.v, t0c7.v, t0c8.v,
t0c9.v, t0ca.v, t0cb.v, t0cc.v, t0cd.v, t0ce.v, t0cf.v,
t0d0.v, t0d1.v, t0d2.v, t0d3.v, t0d4.v, t0d5.v, t0d6.v, t0d7.v, t0d8.v,
t0d9.v, t0da.v, t0db.v, t0dc.v, t0dd.v, t0de.v, t0df.v,
t0e0.v, t0e1.v, t0e2.v, t0e3.v, t0e4.v, t0e5.v, t0e6.v, t0e7.v, t0e8.v,
t0e9.v, t0ea.v, t0eb.v, t0ec.v, t0ed.v, t0ee.v, t0ef.v,
t0f0.v, t0f1.v, t0f2.v, t0f3.v, t0f4.v, t0f5.v, t0f6.v, t0f7.v, t0f8.v,
t0f9.v, t0fa.v, t0fb.v, t0fc.v, t0fd.v, t0fe.v, t0ff.v,
t100.v, t101.v, t102.v, t103.v, t104.v, t105.v, t106.v, t107.v, t108.v,
t109.v, t10a.v, t10b.v, t10c.v, t10d.v, t10e.v, t10f.v,
t110.v, t111.v, t112.v, t113.v, t114.v, t115.v, t116.v, t117.v, t118.v,
t119.v, t11a.v, t11b.v, t11c.v, t11d.v, t11e.v, t11f.v,
t120.v, t121.v, t122.v, t123.v, t124.v, t125.v, t126.v, t127.v, t128.v,
t129.v, t12a.v, t12b.v, t12c.v, t12d.v, t12e.v, t12f.v,
t130.v, t131.v, t132.v, t133.v, t134.v, t135.v, t136.v, t137.v, t138.v,
t139.v, t13a.v, t13b.v, t13c.v, t13d.v, t13e.v, t13f.v,
t140.v, t141.v, t142.v, t143.v, t144.v, t145.v, t146.v, t147.v, t148.v,
t149.v, t14a.v, t14b.v, t14c.v, t14d.v, t14e.v, t14f.v,
t150.v, t151.v, t152.v, t153.v, t154.v, t155.v, t156.v, t157.v, t158.v,
t159.v, t15a.v, t15b.v, t15c.v, t15d.v, t15e.v, t15f.v,
t160.v, t161.v, t162.v, t163.v, t164.v, t165.v, t166.v, t167.v, t168.v,
t169.v, t16a.v, t16b.v, t16c.v, t16d.v, t16e.v, t16f.v,
t170.v, t171.v, t172.v, t173.v, t174.v, t175.v, t176.v, t177.v, t178.v,
t179.v, t17a.v, t17b.v, t17c.v, t17d.v, t17e.v, t17f.v,
t180.v, t181.v, t182.v, t183.v, t184.v, t185.v, t186.v, t187.v, t188.v,
t189.v, t18a.v, t18b.v, t18c.v, t18d.v, t18e.v, t18f.v,
t190.v, t191.v, t192.v, t193.v, t194.v, t195.v, t196.v, t197.v, t198.v,
t199.v, t19a.v, t19b.v, t19c.v, t19d.v, t19e.v, t19f.v,
t1a0.v, t1a1.v, t1a2.v, t1a3.v, t1a4.v, t1a5.v, t1a6.v, t1a7.v, t1a8.v,
t1a9.v, t1aa.v, t1ab.v, t1ac.v, t1ad.v, t1ae.v, t1af.v,
t1b0.v, t1b1.v, t1b2.v, t1b3.v, t1b4.v, t1b5.v, t1b6.v, t1b7.v, t1b8.v,
t1b9.v, t1ba.v, t1bb.v, t1bc.v, t1bd.v, t1be.v, t1bf.v
FROM
generate_series(1, 1024*1024),
t t000, t t001, t t002, t t003, t t004, t t005, t t006, t t007, t t008,
t t009, t t00a, t t00b, t t00c, t t00d, t t00e, t t00f,
t t010, t t011, t t012, t t013, t t014, t t015, t t016, t t017, t t018,
t t019, t t01a, t t01b, t t01c, t t01d, t t01e, t t01f,
t t020, t t021, t t022, t t023, t t024, t t025, t t026, t t027, t t028,
t t029, t t02a, t t02b, t t02c, t t02d, t t02e, t t02f,
t t030, t t031, t t032, t t033, t t034, t t035, t t036, t t037, t t038,
t t039, t t03a, t t03b, t t03c, t t03d, t t03e, t t03f,
t t040, t t041, t t042, t t043, t t044, t t045, t t046, t t047, t t048,
t t049, t t04a, t t04b, t t04c, t t04d, t t04e, t t04f,
t t050, t t051, t t052, t t053, t t054, t t055, t t056, t t057, t t058,
t t059, t t05a, t t05b, t t05c, t t05d, t t05e, t t05f,
t t060, t t061, t t062, t t063, t t064, t t065, t t066, t t067, t t068,
t t069, t t06a, t t06b, t t06c, t t06d, t t06e, t t06f,
t t070, t t071, t t072, t t073, t t074, t t075, t t076, t t077, t t078,
t t079, t t07a, t t07b, t t07c, t t07d, t t07e, t t07f,
t t080, t t081, t t082, t t083, t t084, t t085, t t086, t t087, t t088,
t t089, t t08a, t t08b, t t08c, t t08d, t t08e, t t08f,
t t090, t t091, t t092, t t093, t t094, t t095, t t096, t t097, t t098,
t t099, t t09a, t t09b, t t09c, t t09d, t t09e, t t09f,
t t0a0, t t0a1, t t0a2, t t0a3, t t0a4, t t0a5, t t0a6, t t0a7, t t0a8,
t t0a9, t t0aa, t t0ab, t t0ac, t t0ad, t t0ae, t t0af,
t t0b0, t t0b1, t t0b2, t t0b3, t t0b4, t t0b5, t t0b6, t t0b7, t t0b8,
t t0b9, t t0ba, t t0bb, t t0bc, t t0bd, t t0be, t t0bf,
t t0c0, t t0c1, t t0c2, t t0c3, t t0c4, t t0c5, t t0c6, t t0c7, t t0c8,
t t0c9, t t0ca, t t0cb, t t0cc, t t0cd, t t0ce, t t0cf,
t t0d0, t t0d1, t t0d2, t t0d3, t t0d4, t t0d5, t t0d6, t t0d7, t t0d8,
t t0d9, t t0da, t t0db, t t0dc, t t0dd, t t0de, t t0df,
t t0e0, t t0e1, t t0e2, t t0e3, t t0e4, t t0e5, t t0e6, t t0e7, t t0e8,
t t0e9, t t0ea, t t0eb, t t0ec, t t0ed, t t0ee, t t0ef,
t t0f0, t t0f1, t t0f2, t t0f3, t t0f4, t t0f5, t t0f6, t t0f7, t t0f8,
t t0f9, t t0fa, t t0fb, t t0fc, t t0fd, t t0fe, t t0ff,
t t100, t t101, t t102, t t103, t t104, t t105, t t106, t t107, t t108,
t t109, t t10a, t t10b, t t10c, t t10d, t t10e, t t10f,
t t110, t t111, t t112, t t113, t t114, t t115, t t116, t t117, t t118,
t t119, t t11a, t t11b, t t11c, t t11d, t t11e, t t11f,
t t120, t t121, t t122, t t123, t t124, t t125, t t126, t t127, t t128,
t t129, t t12a, t t12b, t t12c, t t12d, t t12e, t t12f,
t t130, t t131, t t132, t t133, t t134, t t135, t t136, t t137, t t138,
t t139, t t13a, t t13b, t t13c, t t13d, t t13e, t t13f,
t t140, t t141, t t142, t t143, t t144, t t145, t t146, t t147, t t148,
t t149, t t14a, t t14b, t t14c, t t14d, t t14e, t t14f,
t t150, t t151, t t152, t t153, t t154, t t155, t t156, t t157, t t158,
t t159, t t15a, t t15b, t t15c, t t15d, t t15e, t t15f,
t t160, t t161, t t162, t t163, t t164, t t165, t t166, t t167, t t168,
t t169, t t16a, t t16b, t t16c, t t16d, t t16e, t t16f,
t t170, t t171, t t172, t t173, t t174, t t175, t t176, t t177, t t178,
t t179, t t17a, t t17b, t t17c, t t17d, t t17e, t t17f,
t t180, t t181, t t182, t t183, t t184, t t185, t t186, t t187, t t188,
t t189, t t18a, t t18b, t t18c, t t18d, t t18e, t t18f,
t t190, t t191, t t192, t t193, t t194, t t195, t t196, t t197, t t198,
t t199, t t19a, t t19b, t t19c, t t19d, t t19e, t t19f,
t t1a0, t t1a1, t t1a2, t t1a3, t t1a4, t t1a5, t t1a6, t t1a7, t t1a8,
t t1a9, t t1aa, t t1ab, t t1ac, t t1ad, t t1ae, t t1af,
t t1b0, t t1b1, t t1b2, t t1b3, t t1b4, t t1b5, t t1b6, t t1b7, t t1b8,
t t1b9, t t1ba, t t1bb, t t1bc, t t1bd, t t1be, t t1bf
;
SELECT '9 Mi entries written'::text;
INSERT INTO test (
arr000, arr001, arr002, arr003, arr004, arr005, arr006, arr007, arr008,
arr009, arr00a, arr00b, arr00c, arr00d, arr00e, arr00f,
arr010, arr011, arr012, arr013, arr014, arr015, arr016, arr017, arr018,
arr019, arr01a, arr01b, arr01c, arr01d, arr01e, arr01f,
arr020, arr021, arr022, arr023, arr024, arr025, arr026, arr027, arr028,
arr029, arr02a, arr02b, arr02c, arr02d, arr02e, arr02f,
arr030, arr031, arr032, arr033, arr034, arr035, arr036, arr037, arr038,
arr039, arr03a, arr03b, arr03c, arr03d, arr03e, arr03f,
arr040, arr041, arr042, arr043, arr044, arr045, arr046, arr047, arr048,
arr049, arr04a, arr04b, arr04c, arr04d, arr04e, arr04f,
arr050, arr051, arr052, arr053, arr054, arr055, arr056, arr057, arr058,
arr059, arr05a, arr05b, arr05c, arr05d, arr05e, arr05f,
arr060, arr061, arr062, arr063, arr064, arr065, arr066, arr067, arr068,
arr069, arr06a, arr06b, arr06c, arr06d, arr06e, arr06f,
arr070, arr071, arr072, arr073, arr074, arr075, arr076, arr077, arr078,
arr079, arr07a, arr07b, arr07c, arr07d, arr07e, arr07f,
arr080, arr081, arr082, arr083, arr084, arr085, arr086, arr087, arr088,
arr089, arr08a, arr08b, arr08c, arr08d, arr08e, arr08f,
arr090, arr091, arr092, arr093, arr094, arr095, arr096, arr097, arr098,
arr099, arr09a, arr09b, arr09c, arr09d, arr09e, arr09f,
arr0a0, arr0a1, arr0a2, arr0a3, arr0a4, arr0a5, arr0a6, arr0a7, arr0a8,
arr0a9, arr0aa, arr0ab, arr0ac, arr0ad, arr0ae, arr0af,
arr0b0, arr0b1, arr0b2, arr0b3, arr0b4, arr0b5, arr0b6, arr0b7, arr0b8,
arr0b9, arr0ba, arr0bb, arr0bc, arr0bd, arr0be, arr0bf,
arr0c0, arr0c1, arr0c2, arr0c3, arr0c4, arr0c5, arr0c6, arr0c7, arr0c8,
arr0c9, arr0ca, arr0cb, arr0cc, arr0cd, arr0ce, arr0cf,
arr0d0, arr0d1, arr0d2, arr0d3, arr0d4, arr0d5, arr0d6, arr0d7, arr0d8,
arr0d9, arr0da, arr0db, arr0dc, arr0dd, arr0de, arr0df,
arr0e0, arr0e1, arr0e2, arr0e3, arr0e4, arr0e5, arr0e6, arr0e7, arr0e8,
arr0e9, arr0ea, arr0eb, arr0ec, arr0ed, arr0ee, arr0ef,
arr0f0, arr0f1, arr0f2, arr0f3, arr0f4, arr0f5, arr0f6, arr0f7, arr0f8,
arr0f9, arr0fa, arr0fb, arr0fc, arr0fd, arr0fe, arr0ff,
arr100, arr101, arr102, arr103, arr104, arr105, arr106, arr107, arr108,
arr109, arr10a, arr10b, arr10c, arr10d, arr10e, arr10f,
arr110, arr111, arr112, arr113, arr114, arr115, arr116, arr117, arr118,
arr119, arr11a, arr11b, arr11c, arr11d, arr11e, arr11f,
arr120, arr121, arr122, arr123, arr124, arr125, arr126, arr127, arr128,
arr129, arr12a, arr12b, arr12c, arr12d, arr12e, arr12f,
arr130, arr131, arr132, arr133, arr134, arr135, arr136, arr137, arr138,
arr139, arr13a, arr13b, arr13c, arr13d, arr13e, arr13f,
arr140, arr141, arr142, arr143, arr144, arr145, arr146, arr147, arr148,
arr149, arr14a, arr14b, arr14c, arr14d, arr14e, arr14f,
arr150, arr151, arr152, arr153, arr154, arr155, arr156, arr157, arr158,
arr159, arr15a, arr15b, arr15c, arr15d, arr15e, arr15f,
arr160, arr161, arr162, arr163, arr164, arr165, arr166, arr167, arr168,
arr169, arr16a, arr16b, arr16c, arr16d, arr16e, arr16f,
arr170, arr171, arr172, arr173, arr174, arr175, arr176, arr177, arr178,
arr179, arr17a, arr17b, arr17c, arr17d, arr17e, arr17f,
arr180, arr181, arr182, arr183, arr184, arr185, arr186, arr187, arr188,
arr189, arr18a, arr18b, arr18c, arr18d, arr18e, arr18f,
arr190, arr191, arr192, arr193, arr194, arr195, arr196, arr197, arr198,
arr199, arr19a, arr19b, arr19c, arr19d, arr19e, arr19f,
arr1a0, arr1a1, arr1a2, arr1a3, arr1a4, arr1a5, arr1a6, arr1a7, arr1a8,
arr1a9, arr1aa, arr1ab, arr1ac, arr1ad, arr1ae, arr1af,
arr1b0, arr1b1, arr1b2, arr1b3, arr1b4, arr1b5, arr1b6, arr1b7, arr1b8,
arr1b9, arr1ba, arr1bb, arr1bc, arr1bd, arr1be, arr1bf
)
WITH t AS (SELECT '{null}'::Integer[] AS v)
SELECT
t000.v, t001.v, t002.v, t003.v, t004.v, t005.v, t006.v, t007.v, t008.v,
t009.v, t00a.v, t00b.v, t00c.v, t00d.v, t00e.v, t00f.v,
t010.v, t011.v, t012.v, t013.v, t014.v, t015.v, t016.v, t017.v, t018.v,
t019.v, t01a.v, t01b.v, t01c.v, t01d.v, t01e.v, t01f.v,
t020.v, t021.v, t022.v, t023.v, t024.v, t025.v, t026.v, t027.v, t028.v,
t029.v, t02a.v, t02b.v, t02c.v, t02d.v, t02e.v, t02f.v,
t030.v, t031.v, t032.v, t033.v, t034.v, t035.v, t036.v, t037.v, t038.v,
t039.v, t03a.v, t03b.v, t03c.v, t03d.v, t03e.v, t03f.v,
t040.v, t041.v, t042.v, t043.v, t044.v, t045.v, t046.v, t047.v, t048.v,
t049.v, t04a.v, t04b.v, t04c.v, t04d.v, t04e.v, t04f.v,
t050.v, t051.v, t052.v, t053.v, t054.v, t055.v, t056.v, t057.v, t058.v,
t059.v, t05a.v, t05b.v, t05c.v, t05d.v, t05e.v, t05f.v,
t060.v, t061.v, t062.v, t063.v, t064.v, t065.v, t066.v, t067.v, t068.v,
t069.v, t06a.v, t06b.v, t06c.v, t06d.v, t06e.v, t06f.v,
t070.v, t071.v, t072.v, t073.v, t074.v, t075.v, t076.v, t077.v, t078.v,
t079.v, t07a.v, t07b.v, t07c.v, t07d.v, t07e.v, t07f.v,
t080.v, t081.v, t082.v, t083.v, t084.v, t085.v, t086.v, t087.v, t088.v,
t089.v, t08a.v, t08b.v, t08c.v, t08d.v, t08e.v, t08f.v,
t090.v, t091.v, t092.v, t093.v, t094.v, t095.v, t096.v, t097.v, t098.v,
t099.v, t09a.v, t09b.v, t09c.v, t09d.v, t09e.v, t09f.v,
t0a0.v, t0a1.v, t0a2.v, t0a3.v, t0a4.v, t0a5.v, t0a6.v, t0a7.v, t0a8.v,
t0a9.v, t0aa.v, t0ab.v, t0ac.v, t0ad.v, t0ae.v, t0af.v,
t0b0.v, t0b1.v, t0b2.v, t0b3.v, t0b4.v, t0b5.v, t0b6.v, t0b7.v, t0b8.v,
t0b9.v, t0ba.v, t0bb.v, t0bc.v, t0bd.v, t0be.v, t0bf.v,
t0c0.v, t0c1.v, t0c2.v, t0c3.v, t0c4.v, t0c5.v, t0c6.v, t0c7.v, t0c8.v,
t0c9.v, t0ca.v, t0cb.v, t0cc.v, t0cd.v, t0ce.v, t0cf.v,
t0d0.v, t0d1.v, t0d2.v, t0d3.v, t0d4.v, t0d5.v, t0d6.v, t0d7.v, t0d8.v,
t0d9.v, t0da.v, t0db.v, t0dc.v, t0dd.v, t0de.v, t0df.v,
t0e0.v, t0e1.v, t0e2.v, t0e3.v, t0e4.v, t0e5.v, t0e6.v, t0e7.v, t0e8.v,
t0e9.v, t0ea.v, t0eb.v, t0ec.v, t0ed.v, t0ee.v, t0ef.v,
t0f0.v, t0f1.v, t0f2.v, t0f3.v, t0f4.v, t0f5.v, t0f6.v, t0f7.v, t0f8.v,
t0f9.v, t0fa.v, t0fb.v, t0fc.v, t0fd.v, t0fe.v, t0ff.v,
t100.v, t101.v, t102.v, t103.v, t104.v, t105.v, t106.v, t107.v, t108.v,
t109.v, t10a.v, t10b.v, t10c.v, t10d.v, t10e.v, t10f.v,
t110.v, t111.v, t112.v, t113.v, t114.v, t115.v, t116.v, t117.v, t118.v,
t119.v, t11a.v, t11b.v, t11c.v, t11d.v, t11e.v, t11f.v,
t120.v, t121.v, t122.v, t123.v, t124.v, t125.v, t126.v, t127.v, t128.v,
t129.v, t12a.v, t12b.v, t12c.v, t12d.v, t12e.v, t12f.v,
t130.v, t131.v, t132.v, t133.v, t134.v, t135.v, t136.v, t137.v, t138.v,
t139.v, t13a.v, t13b.v, t13c.v, t13d.v, t13e.v, t13f.v,
t140.v, t141.v, t142.v, t143.v, t144.v, t145.v, t146.v, t147.v, t148.v,
t149.v, t14a.v, t14b.v, t14c.v, t14d.v, t14e.v, t14f.v,
t150.v, t151.v, t152.v, t153.v, t154.v, t155.v, t156.v, t157.v, t158.v,
t159.v, t15a.v, t15b.v, t15c.v, t15d.v, t15e.v, t15f.v,
t160.v, t161.v, t162.v, t163.v, t164.v, t165.v, t166.v, t167.v, t168.v,
t169.v, t16a.v, t16b.v, t16c.v, t16d.v, t16e.v, t16f.v,
t170.v, t171.v, t172.v, t173.v, t174.v, t175.v, t176.v, t177.v, t178.v,
t179.v, t17a.v, t17b.v, t17c.v, t17d.v, t17e.v, t17f.v,
t180.v, t181.v, t182.v, t183.v, t184.v, t185.v, t186.v, t187.v, t188.v,
t189.v, t18a.v, t18b.v, t18c.v, t18d.v, t18e.v, t18f.v,
t190.v, t191.v, t192.v, t193.v, t194.v, t195.v, t196.v, t197.v, t198.v,
t199.v, t19a.v, t19b.v, t19c.v, t19d.v, t19e.v, t19f.v,
t1a0.v, t1a1.v, t1a2.v, t1a3.v, t1a4.v, t1a5.v, t1a6.v, t1a7.v, t1a8.v,
t1a9.v, t1aa.v, t1ab.v, t1ac.v, t1ad.v, t1ae.v, t1af.v,
t1b0.v, t1b1.v, t1b2.v, t1b3.v, t1b4.v, t1b5.v, t1b6.v, t1b7.v, t1b8.v,
t1b9.v, t1ba.v, t1bb.v, t1bc.v, t1bd.v, t1be.v, t1bf.v
FROM
generate_series(1, 1024*1024),
t t000, t t001, t t002, t t003, t t004, t t005, t t006, t t007, t t008,
t t009, t t00a, t t00b, t t00c, t t00d, t t00e, t t00f,
t t010, t t011, t t012, t t013, t t014, t t015, t t016, t t017, t t018,
t t019, t t01a, t t01b, t t01c, t t01d, t t01e, t t01f,
t t020, t t021, t t022, t t023, t t024, t t025, t t026, t t027, t t028,
t t029, t t02a, t t02b, t t02c, t t02d, t t02e, t t02f,
t t030, t t031, t t032, t t033, t t034, t t035, t t036, t t037, t t038,
t t039, t t03a, t t03b, t t03c, t t03d, t t03e, t t03f,
t t040, t t041, t t042, t t043, t t044, t t045, t t046, t t047, t t048,
t t049, t t04a, t t04b, t t04c, t t04d, t t04e, t t04f,
t t050, t t051, t t052, t t053, t t054, t t055, t t056, t t057, t t058,
t t059, t t05a, t t05b, t t05c, t t05d, t t05e, t t05f,
t t060, t t061, t t062, t t063, t t064, t t065, t t066, t t067, t t068,
t t069, t t06a, t t06b, t t06c, t t06d, t t06e, t t06f,
t t070, t t071, t t072, t t073, t t074, t t075, t t076, t t077, t t078,
t t079, t t07a, t t07b, t t07c, t t07d, t t07e, t t07f,
t t080, t t081, t t082, t t083, t t084, t t085, t t086, t t087, t t088,
t t089, t t08a, t t08b, t t08c, t t08d, t t08e, t t08f,
t t090, t t091, t t092, t t093, t t094, t t095, t t096, t t097, t t098,
t t099, t t09a, t t09b, t t09c, t t09d, t t09e, t t09f,
t t0a0, t t0a1, t t0a2, t t0a3, t t0a4, t t0a5, t t0a6, t t0a7, t t0a8,
t t0a9, t t0aa, t t0ab, t t0ac, t t0ad, t t0ae, t t0af,
t t0b0, t t0b1, t t0b2, t t0b3, t t0b4, t t0b5, t t0b6, t t0b7, t t0b8,
t t0b9, t t0ba, t t0bb, t t0bc, t t0bd, t t0be, t t0bf,
t t0c0, t t0c1, t t0c2, t t0c3, t t0c4, t t0c5, t t0c6, t t0c7, t t0c8,
t t0c9, t t0ca, t t0cb, t t0cc, t t0cd, t t0ce, t t0cf,
t t0d0, t t0d1, t t0d2, t t0d3, t t0d4, t t0d5, t t0d6, t t0d7, t t0d8,
t t0d9, t t0da, t t0db, t t0dc, t t0dd, t t0de, t t0df,
t t0e0, t t0e1, t t0e2, t t0e3, t t0e4, t t0e5, t t0e6, t t0e7, t t0e8,
t t0e9, t t0ea, t t0eb, t t0ec, t t0ed, t t0ee, t t0ef,
t t0f0, t t0f1, t t0f2, t t0f3, t t0f4, t t0f5, t t0f6, t t0f7, t t0f8,
t t0f9, t t0fa, t t0fb, t t0fc, t t0fd, t t0fe, t t0ff,
t t100, t t101, t t102, t t103, t t104, t t105, t t106, t t107, t t108,
t t109, t t10a, t t10b, t t10c, t t10d, t t10e, t t10f,
t t110, t t111, t t112, t t113, t t114, t t115, t t116, t t117, t t118,
t t119, t t11a, t t11b, t t11c, t t11d, t t11e, t t11f,
t t120, t t121, t t122, t t123, t t124, t t125, t t126, t t127, t t128,
t t129, t t12a, t t12b, t t12c, t t12d, t t12e, t t12f,
t t130, t t131, t t132, t t133, t t134, t t135, t t136, t t137, t t138,
t t139, t t13a, t t13b, t t13c, t t13d, t t13e, t t13f,
t t140, t t141, t t142, t t143, t t144, t t145, t t146, t t147, t t148,
t t149, t t14a, t t14b, t t14c, t t14d, t t14e, t t14f,
t t150, t t151, t t152, t t153, t t154, t t155, t t156, t t157, t t158,
t t159, t t15a, t t15b, t t15c, t t15d, t t15e, t t15f,
t t160, t t161, t t162, t t163, t t164, t t165, t t166, t t167, t t168,
t t169, t t16a, t t16b, t t16c, t t16d, t t16e, t t16f,
t t170, t t171, t t172, t t173, t t174, t t175, t t176, t t177, t t178,
t t179, t t17a, t t17b, t t17c, t t17d, t t17e, t t17f,
t t180, t t181, t t182, t t183, t t184, t t185, t t186, t t187, t t188,
t t189, t t18a, t t18b, t t18c, t t18d, t t18e, t t18f,
t t190, t t191, t t192, t t193, t t194, t t195, t t196, t t197, t t198,
t t199, t t19a, t t19b, t t19c, t t19d, t t19e, t t19f,
t t1a0, t t1a1, t t1a2, t t1a3, t t1a4, t t1a5, t t1a6, t t1a7, t t1a8,
t t1a9, t t1aa, t t1ab, t t1ac, t t1ad, t t1ae, t t1af,
t t1b0, t t1b1, t t1b2, t t1b3, t t1b4, t t1b5, t t1b6, t t1b7, t t1b8,
t t1b9, t t1ba, t t1bb, t t1bc, t t1bd, t t1be, t t1bf
;
SELECT '10 Mi entries written'::text;
/* * * End of script * * */
В списке pgsql-bugs по дате отправления:
Предыдущее
От: Tom LaneДата:
Сообщение: Re: BUG #14136: select distinct from a materialized view does not preserve result order
Следующее
От: Kevin GrittnerДата:
Сообщение: Re: BUG #14136: select distinct from a materialized view does not preserve result order