# Analyzedb Perf Test

## Test Script:

\timing
create table partt
(
        i integer
)
partition by range (i)
(
        partition p1 start (0),
        partition p2 start (100),
        partition p3 start (200),
        partition p4 start (300),
        partition p5 start (400),
        partition p6 start (500),
        partition p7 start (600),
        partition p8 start (700),
        partition p9 start (800),
        partition p10 start (900),
        partition p11 start (1000),
        partition p12 start (1100),
        partition p13 start (1200),
        partition p14 start (1300),
        partition p15 start (1400),
        partition p16 start (1500),
        partition p17 start (1600),
        partition p18 start (1700),
        partition p19 start (1800),
        partition p20 start (1900),
        partition p21 start (2000),
        partition p22 start (2100),
        partition p23 start (2200),
        partition p24 start (2300),
        partition p25 start (2400),
        partition p26 start (2500),
        partition p27 start (2600),
        partition p28 start (2700),
        partition p29 start (2800),
        partition p30 start (2900),
        partition p31 start (3000),
        partition p32 start (3100),
        partition p33 start (3200),
        partition p34 start (3300),
        partition p35 start (3400),
        partition p36 start (3500),
        partition p37 start (3600),
        partition p38 start (3700),
        partition p39 start (3800),
        partition p40 start (3900),
        partition p41 start (4000),
        partition p42 start (4100),
        partition p43 start (4200),
        partition p44 start (4300),
        partition p45 start (4400),
        partition p46 start (4500),
        partition p47 start (4600),
        partition p48 start (4700),
        partition p49 start (4800),
        partition p50 start (4900),
        partition p51 start (5000),
        partition p52 start (5100),
        partition p53 start (5200),
        partition p54 start (5300),
        partition p55 start (5400),
        partition p56 start (5500),
        partition p57 start (5600),
        partition p58 start (5700),
        partition p59 start (5800),
        partition p60 start (5900),
        partition p61 start (6000),
        partition p62 start (6100),
        partition p63 start (6200),
        partition p64 start (6300),
        partition p65 start (6400),
        partition p66 start (6500),
        partition p67 start (6600),
        partition p68 start (6700),
        partition p69 start (6800),
        partition p70 start (6900),
        partition p71 start (7000),
        partition p72 start (7100),
        partition p73 start (7200),
        partition p74 start (7300),
        partition p75 start (7400),
        partition p76 start (7500),
        partition p77 start (7600),
        partition p78 start (7700),
        partition p79 start (7800),
        partition p80 start (7900),
        partition p81 start (8000),
        partition p82 start (8100),
        partition p83 start (8200),
        partition p84 start (8300),
        partition p85 start (8400),
        partition p86 start (8500),
        partition p87 start (8600),
        partition p88 start (8700),
        partition p89 start (8800),
        partition p90 start (8900),
        partition p91 start (9000),
        partition p92 start (9100),
        partition p93 start (9200),
        partition p94 start (9300),
        partition p95 start (9400),
        partition p96 start (9500),
        partition p97 start (9600),
        partition p98 start (9700),
        partition p99 start (9800),
        partition p100 start (9900),
        partition p101 start (10000),
        partition p102 start (10100),
        partition p103 start (10200),
        partition p104 start (10300),
        partition p105 start (10400),
        partition p106 start (10500),
        partition p107 start (10600),
        partition p108 start (10700),
        partition p109 start (10800),
        partition p110 start (10900),
        partition p111 start (11000),
        partition p112 start (11100),
        partition p113 start (11200),
        partition p114 start (11300),
        partition p115 start (11400),
        partition p116 start (11500),
        partition p117 start (11600),
        partition p118 start (11700),
        partition p119 start (11800),
        partition p120 start (11900),
        partition p121 start (12000),
        partition p122 start (12100),
        partition p123 start (12200),
        partition p124 start (12300),
        partition p125 start (12400),
        partition p126 start (12500),
        partition p127 start (12600),
        partition p128 start (12700),
        partition p129 start (12800),
        partition p130 start (12900),
        partition p131 start (13000),
        partition p132 start (13100),
        partition p133 start (13200),
        partition p134 start (13300),
        partition p135 start (13400),
        partition p136 start (13500),
        partition p137 start (13600),
        partition p138 start (13700),
        partition p139 start (13800),
        partition p140 start (13900),
        partition p141 start (14000),
        partition p142 start (14100),
        partition p143 start (14200),
        partition p144 start (14300),
        partition p145 start (14400),
        partition p146 start (14500),
        partition p147 start (14600),
        partition p148 start (14700),
        partition p149 start (14800),
        partition p150 start (14900),
        partition p151 start (15000),
        partition p152 start (15100),
        partition p153 start (15200),
        partition p154 start (15300),
        partition p155 start (15400),
        partition p156 start (15500),
        partition p157 start (15600),
        partition p158 start (15700),
        partition p159 start (15800),
        partition p160 start (15900),
        partition p161 start (16000),
        partition p162 start (16100),
        partition p163 start (16200),
        partition p164 start (16300),
        partition p165 start (16400),
        partition p166 start (16500),
        partition p167 start (16600),
        partition p168 start (16700),
        partition p169 start (16800),
        partition p170 start (16900),
        partition p171 start (17000),
        partition p172 start (17100),
        partition p173 start (17200),
        partition p174 start (17300),
        partition p175 start (17400),
        partition p176 start (17500),
        partition p177 start (17600),
        partition p178 start (17700),
        partition p179 start (17800),
        partition p180 start (17900),
        partition p181 start (18000),
        partition p182 start (18100),
        partition p183 start (18200),
        partition p184 start (18300),
        partition p185 start (18400),
        partition p186 start (18500),
        partition p187 start (18600),
        partition p188 start (18700),
        partition p189 start (18800),
        partition p190 start (18900),
        partition p191 start (19000),
        partition p192 start (19100),
        partition p193 start (19200),
        partition p194 start (19300),
        partition p195 start (19400),
        partition p196 start (19500),
        partition p197 start (19600),
        partition p198 start (19700),
        partition p199 start (19800),
        partition p200 start (19900),
        partition p201 start (20000),
        partition p202 start (20100),
        partition p203 start (20200),
        partition p204 start (20300),
        partition p205 start (20400),
        partition p206 start (20500),
        partition p207 start (20600),
        partition p208 start (20700),
        partition p209 start (20800),
        partition p210 start (20900),
        partition p211 start (21000),
        partition p212 start (21100),
        partition p213 start (21200),
        partition p214 start (21300),
        partition p215 start (21400),
        partition p216 start (21500),
        partition p217 start (21600),
        partition p218 start (21700),
        partition p219 start (21800),
        partition p220 start (21900),
        partition p221 start (22000),
        partition p222 start (22100),
        partition p223 start (22200),
        partition p224 start (22300),
        partition p225 start (22400),
        partition p226 start (22500),
        partition p227 start (22600),
        partition p228 start (22700),
        partition p229 start (22800),
        partition p230 start (22900),
        partition p231 start (23000),
        partition p232 start (23100),
        partition p233 start (23200),
        partition p234 start (23300),
        partition p235 start (23400),
        partition p236 start (23500),
        partition p237 start (23600),
        partition p238 start (23700),
        partition p239 start (23800),
        partition p240 start (23900),
        partition p241 start (24000),
        partition p242 start (24100),
        partition p243 start (24200),
        partition p244 start (24300),
        partition p245 start (24400),
        partition p246 start (24500),
        partition p247 start (24600),
        partition p248 start (24700),
        partition p249 start (24800),
        partition p250 start (24900),
        partition p251 start (25000),
        partition p252 start (25100),
        partition p253 start (25200),
        partition p254 start (25300),
        partition p255 start (25400),
        partition p256 start (25500),
        partition p257 start (25600),
        partition p258 start (25700),
        partition p259 start (25800),
        partition p260 start (25900),
        partition p261 start (26000),
        partition p262 start (26100),
        partition p263 start (26200),
        partition p264 start (26300),
        partition p265 start (26400),
        partition p266 start (26500),
        partition p267 start (26600),
        partition p268 start (26700),
        partition p269 start (26800),
        partition p270 start (26900),
        partition p271 start (27000),
        partition p272 start (27100),
        partition p273 start (27200),
        partition p274 start (27300),
        partition p275 start (27400),
        partition p276 start (27500),
        partition p277 start (27600),
        partition p278 start (27700),
        partition p279 start (27800),
        partition p280 start (27900),
        partition p281 start (28000),
        partition p282 start (28100),
        partition p283 start (28200),
        partition p284 start (28300),
        partition p285 start (28400),
        partition p286 start (28500),
        partition p287 start (28600),
        partition p288 start (28700),
        partition p289 start (28800),
        partition p290 start (28900),
        partition p291 start (29000),
        partition p292 start (29100),
        partition p293 start (29200),
        partition p294 start (29300),
        partition p295 start (29400),
        partition p296 start (29500),
        partition p297 start (29600),
        partition p298 start (29700),
        partition p299 start (29800),
        partition p300 start (29900),
        partition p301 start (30000),
        partition p302 start (30100),
        partition p303 start (30200),
        partition p304 start (30300),
        partition p305 start (30400),
        partition p306 start (30500),
        partition p307 start (30600),
        partition p308 start (30700),
        partition p309 start (30800),
        partition p310 start (30900),
        partition p311 start (31000),
        partition p312 start (31100),
        partition p313 start (31200),
        partition p314 start (31300),
        partition p315 start (31400),
        partition p316 start (31500),
        partition p317 start (31600),
        partition p318 start (31700),
        partition p319 start (31800),
        partition p320 start (31900),
        partition p321 start (32000),
        partition p322 start (32100),
        partition p323 start (32200),
        partition p324 start (32300),
        partition p325 start (32400),
        partition p326 start (32500),
        partition p327 start (32600),
        partition p328 start (32700),
        partition p329 start (32800),
        partition p330 start (32900),
        partition p331 start (33000),
        partition p332 start (33100),
        partition p333 start (33200),
        partition p334 start (33300),
        partition p335 start (33400),
        partition p336 start (33500),
        partition p337 start (33600),
        partition p338 start (33700),
        partition p339 start (33800),
        partition p340 start (33900),
        partition p341 start (34000),
        partition p342 start (34100),
        partition p343 start (34200),
        partition p344 start (34300),
        partition p345 start (34400),
        partition p346 start (34500),
        partition p347 start (34600),
        partition p348 start (34700),
        partition p349 start (34800),
        partition p350 start (34900),
        partition p351 start (35000),
        partition p352 start (35100),
        partition p353 start (35200),
        partition p354 start (35300),
        partition p355 start (35400),
        partition p356 start (35500),
        partition p357 start (35600),
        partition p358 start (35700),
        partition p359 start (35800),
        partition p360 start (35900),
        partition p361 start (36000),
        partition p362 start (36100),
        partition p363 start (36200),
        partition p364 start (36300),
        partition p365 start (36400),
        partition p366 start (36500),
        partition p367 start (36600),
        partition p368 start (36700),
        partition p369 start (36800),
        partition p370 start (36900),
        partition p371 start (37000),
        partition p372 start (37100),
        partition p373 start (37200),
        partition p374 start (37300),
        partition p375 start (37400),
        partition p376 start (37500),
        partition p377 start (37600),
        partition p378 start (37700),
        partition p379 start (37800),
        partition p380 start (37900),
        partition p381 start (38000),
        partition p382 start (38100),
        partition p383 start (38200),
        partition p384 start (38300),
        partition p385 start (38400),
        partition p386 start (38500),
        partition p387 start (38600),
        partition p388 start (38700),
        partition p389 start (38800),
        partition p390 start (38900),
        partition p391 start (39000),
        partition p392 start (39100),
        partition p393 start (39200),
        partition p394 start (39300),
        partition p395 start (39400),
        partition p396 start (39500),
        partition p397 start (39600),
        partition p398 start (39700),
        partition p399 start (39800),
        partition p400 start (39900),
        partition p401 start (40000),
        partition p402 start (40100),
        partition p403 start (40200),
        partition p404 start (40300),
        partition p405 start (40400),
        partition p406 start (40500),
        partition p407 start (40600),
        partition p408 start (40700),
        partition p409 start (40800),
        partition p410 start (40900),
        partition p411 start (41000),
        partition p412 start (41100),
        partition p413 start (41200),
        partition p414 start (41300),
        partition p415 start (41400),
        partition p416 start (41500),
        partition p417 start (41600),
        partition p418 start (41700),
        partition p419 start (41800),
        partition p420 start (41900),
        partition p421 start (42000),
        partition p422 start (42100),
        partition p423 start (42200),
        partition p424 start (42300),
        partition p425 start (42400),
        partition p426 start (42500),
        partition p427 start (42600),
        partition p428 start (42700),
        partition p429 start (42800),
        partition p430 start (42900),
        partition p431 start (43000),
        partition p432 start (43100),
        partition p433 start (43200),
        partition p434 start (43300),
        partition p435 start (43400),
        partition p436 start (43500),
        partition p437 start (43600),
        partition p438 start (43700),
        partition p439 start (43800),
        partition p440 start (43900),
        partition p441 start (44000),
        partition p442 start (44100),
        partition p443 start (44200),
        partition p444 start (44300),
        partition p445 start (44400),
        partition p446 start (44500),
        partition p447 start (44600),
        partition p448 start (44700),
        partition p449 start (44800),
        partition p450 start (44900),
        partition p451 start (45000),
        partition p452 start (45100),
        partition p453 start (45200),
        partition p454 start (45300),
        partition p455 start (45400),
        partition p456 start (45500),
        partition p457 start (45600),
        partition p458 start (45700),
        partition p459 start (45800),
        partition p460 start (45900),
        partition p461 start (46000),
        partition p462 start (46100),
        partition p463 start (46200),
        partition p464 start (46300),
        partition p465 start (46400),
        partition p466 start (46500),
        partition p467 start (46600),
        partition p468 start (46700),
        partition p469 start (46800),
        partition p470 start (46900),
        partition p471 start (47000),
        partition p472 start (47100),
        partition p473 start (47200),
        partition p474 start (47300),
        partition p475 start (47400),
        partition p476 start (47500),
        partition p477 start (47600),
        partition p478 start (47700),
        partition p479 start (47800),
        partition p480 start (47900),
        partition p481 start (48000),
        partition p482 start (48100),
        partition p483 start (48200),
        partition p484 start (48300),
        partition p485 start (48400),
        partition p486 start (48500),
        partition p487 start (48600),
        partition p488 start (48700),
        partition p489 start (48800),
        partition p490 start (48900),
        partition p491 start (49000),
        partition p492 start (49100),
        partition p493 start (49200),
        partition p494 start (49300),
        partition p495 start (49400),
        partition p496 start (49500),
        partition p497 start (49600),
        partition p498 start (49700),
        partition p499 start (49800),
        partition p500 start (49900),
        partition p501 start (50000),
        partition p502 start (50100),
        partition p503 start (50200),
        partition p504 start (50300),
        partition p505 start (50400),
        partition p506 start (50500),
        partition p507 start (50600),
        partition p508 start (50700),
        partition p509 start (50800),
        partition p510 start (50900),
        partition p511 start (51000),
        partition p512 start (51100),
        partition p513 start (51200),
        partition p514 start (51300),
        partition p515 start (51400),
        partition p516 start (51500),
        partition p517 start (51600),
        partition p518 start (51700),
        partition p519 start (51800),
        partition p520 start (51900),
        partition p521 start (52000),
        partition p522 start (52100),
        partition p523 start (52200),
        partition p524 start (52300),
        partition p525 start (52400),
        partition p526 start (52500),
        partition p527 start (52600),
        partition p528 start (52700),
        partition p529 start (52800),
        partition p530 start (52900),
        partition p531 start (53000),
        partition p532 start (53100),
        partition p533 start (53200),
        partition p534 start (53300),
        partition p535 start (53400),
        partition p536 start (53500),
        partition p537 start (53600),
        partition p538 start (53700),
        partition p539 start (53800),
        partition p540 start (53900),
        partition p541 start (54000),
        partition p542 start (54100),
        partition p543 start (54200),
        partition p544 start (54300),
        partition p545 start (54400),
        partition p546 start (54500),
        partition p547 start (54600),
        partition p548 start (54700),
        partition p549 start (54800),
        partition p550 start (54900),
        partition p551 start (55000),
        partition p552 start (55100),
        partition p553 start (55200),
        partition p554 start (55300),
        partition p555 start (55400),
        partition p556 start (55500),
        partition p557 start (55600),
        partition p558 start (55700),
        partition p559 start (55800),
        partition p560 start (55900),
        partition p561 start (56000),
        partition p562 start (56100),
        partition p563 start (56200),
        partition p564 start (56300),
        partition p565 start (56400),
        partition p566 start (56500),
        partition p567 start (56600),
        partition p568 start (56700),
        partition p569 start (56800),
        partition p570 start (56900),
        partition p571 start (57000),
        partition p572 start (57100),
        partition p573 start (57200),
        partition p574 start (57300),
        partition p575 start (57400),
        partition p576 start (57500),
        partition p577 start (57600),
        partition p578 start (57700),
        partition p579 start (57800),
        partition p580 start (57900),
        partition p581 start (58000),
        partition p582 start (58100),
        partition p583 start (58200),
        partition p584 start (58300),
        partition p585 start (58400),
        partition p586 start (58500),
        partition p587 start (58600),
        partition p588 start (58700),
        partition p589 start (58800),
        partition p590 start (58900),
        partition p591 start (59000),
        partition p592 start (59100),
        partition p593 start (59200),
        partition p594 start (59300),
        partition p595 start (59400),
        partition p596 start (59500),
        partition p597 start (59600),
        partition p598 start (59700),
        partition p599 start (59800),
        partition p600 start (59900),
        partition p601 start (60000),
        partition p602 start (60100),
        partition p603 start (60200),
        partition p604 start (60300),
        partition p605 start (60400),
        partition p606 start (60500),
        partition p607 start (60600),
        partition p608 start (60700),
        partition p609 start (60800),
        partition p610 start (60900),
        partition p611 start (61000),
        partition p612 start (61100),
        partition p613 start (61200),
        partition p614 start (61300),
        partition p615 start (61400),
        partition p616 start (61500),
        partition p617 start (61600),
        partition p618 start (61700),
        partition p619 start (61800),
        partition p620 start (61900),
        partition p621 start (62000),
        partition p622 start (62100),
        partition p623 start (62200),
        partition p624 start (62300),
        partition p625 start (62400),
        partition p626 start (62500),
        partition p627 start (62600),
        partition p628 start (62700),
        partition p629 start (62800),
        partition p630 start (62900),
        partition p631 start (63000),
        partition p632 start (63100),
        partition p633 start (63200),
        partition p634 start (63300),
        partition p635 start (63400),
        partition p636 start (63500),
        partition p637 start (63600),
        partition p638 start (63700),
        partition p639 start (63800),
        partition p640 start (63900),
        partition p641 start (64000),
        partition p642 start (64100),
        partition p643 start (64200),
        partition p644 start (64300),
        partition p645 start (64400),
        partition p646 start (64500),
        partition p647 start (64600),
        partition p648 start (64700),
        partition p649 start (64800),
        partition p650 start (64900),
        partition p651 start (65000),
        partition p652 start (65100),
        partition p653 start (65200),
        partition p654 start (65300),
        partition p655 start (65400),
        partition p656 start (65500),
        partition p657 start (65600),
        partition p658 start (65700),
        partition p659 start (65800),
        partition p660 start (65900),
        partition p661 start (66000),
        partition p662 start (66100),
        partition p663 start (66200),
        partition p664 start (66300),
        partition p665 start (66400),
        partition p666 start (66500),
        partition p667 start (66600),
        partition p668 start (66700),
        partition p669 start (66800),
        partition p670 start (66900),
        partition p671 start (67000),
        partition p672 start (67100),
        partition p673 start (67200),
        partition p674 start (67300),
        partition p675 start (67400),
        partition p676 start (67500),
        partition p677 start (67600),
        partition p678 start (67700),
        partition p679 start (67800),
        partition p680 start (67900),
        partition p681 start (68000),
        partition p682 start (68100),
        partition p683 start (68200),
        partition p684 start (68300),
        partition p685 start (68400),
        partition p686 start (68500),
        partition p687 start (68600),
        partition p688 start (68700),
        partition p689 start (68800),
        partition p690 start (68900),
        partition p691 start (69000),
        partition p692 start (69100),
        partition p693 start (69200),
        partition p694 start (69300),
        partition p695 start (69400),
        partition p696 start (69500),
        partition p697 start (69600),
        partition p698 start (69700),
        partition p699 start (69800),
        partition p700 start (69900),
        partition p701 start (70000),
        partition p702 start (70100),
        partition p703 start (70200),
        partition p704 start (70300),
        partition p705 start (70400),
        partition p706 start (70500),
        partition p707 start (70600),
        partition p708 start (70700),
        partition p709 start (70800),
        partition p710 start (70900),
        partition p711 start (71000),
        partition p712 start (71100),
        partition p713 start (71200),
        partition p714 start (71300),
        partition p715 start (71400),
        partition p716 start (71500),
        partition p717 start (71600),
        partition p718 start (71700),
        partition p719 start (71800),
        partition p720 start (71900),
        partition p721 start (72000),
        partition p722 start (72100),
        partition p723 start (72200),
        partition p724 start (72300),
        partition p725 start (72400),
        partition p726 start (72500),
        partition p727 start (72600),
        partition p728 start (72700),
        partition p729 start (72800),
        partition p730 start (72900),
        partition p731 start (73000),
        partition p732 start (73100),
        partition p733 start (73200),
        partition p734 start (73300),
        partition p735 start (73400),
        partition p736 start (73500),
        partition p737 start (73600),
        partition p738 start (73700),
        partition p739 start (73800),
        partition p740 start (73900),
        partition p741 start (74000),
        partition p742 start (74100),
        partition p743 start (74200),
        partition p744 start (74300),
        partition p745 start (74400),
        partition p746 start (74500),
        partition p747 start (74600),
        partition p748 start (74700),
        partition p749 start (74800),
        partition p750 start (74900),
        partition p751 start (75000),
        partition p752 start (75100),
        partition p753 start (75200),
        partition p754 start (75300),
        partition p755 start (75400),
        partition p756 start (75500),
        partition p757 start (75600),
        partition p758 start (75700),
        partition p759 start (75800),
        partition p760 start (75900),
        partition p761 start (76000),
        partition p762 start (76100),
        partition p763 start (76200),
        partition p764 start (76300),
        partition p765 start (76400),
        partition p766 start (76500),
        partition p767 start (76600),
        partition p768 start (76700),
        partition p769 start (76800),
        partition p770 start (76900),
        partition p771 start (77000),
        partition p772 start (77100),
        partition p773 start (77200),
        partition p774 start (77300),
        partition p775 start (77400),
        partition p776 start (77500),
        partition p777 start (77600),
        partition p778 start (77700),
        partition p779 start (77800),
        partition p780 start (77900),
        partition p781 start (78000),
        partition p782 start (78100),
        partition p783 start (78200),
        partition p784 start (78300),
        partition p785 start (78400),
        partition p786 start (78500),
        partition p787 start (78600),
        partition p788 start (78700),
        partition p789 start (78800),
        partition p790 start (78900),
        partition p791 start (79000),
        partition p792 start (79100),
        partition p793 start (79200),
        partition p794 start (79300),
        partition p795 start (79400),
        partition p796 start (79500),
        partition p797 start (79600),
        partition p798 start (79700),
        partition p799 start (79800),
        partition p800 start (79900),
        partition p801 start (80000),
        partition p802 start (80100),
        partition p803 start (80200),
        partition p804 start (80300),
        partition p805 start (80400),
        partition p806 start (80500),
        partition p807 start (80600),
        partition p808 start (80700),
        partition p809 start (80800),
        partition p810 start (80900),
        partition p811 start (81000),
        partition p812 start (81100),
        partition p813 start (81200),
        partition p814 start (81300),
        partition p815 start (81400),
        partition p816 start (81500),
        partition p817 start (81600),
        partition p818 start (81700),
        partition p819 start (81800),
        partition p820 start (81900),
        partition p821 start (82000),
        partition p822 start (82100),
        partition p823 start (82200),
        partition p824 start (82300),
        partition p825 start (82400),
        partition p826 start (82500),
        partition p827 start (82600),
        partition p828 start (82700),
        partition p829 start (82800),
        partition p830 start (82900),
        partition p831 start (83000),
        partition p832 start (83100),
        partition p833 start (83200),
        partition p834 start (83300),
        partition p835 start (83400),
        partition p836 start (83500),
        partition p837 start (83600),
        partition p838 start (83700),
        partition p839 start (83800),
        partition p840 start (83900),
        partition p841 start (84000),
        partition p842 start (84100),
        partition p843 start (84200),
        partition p844 start (84300),
        partition p845 start (84400),
        partition p846 start (84500),
        partition p847 start (84600),
        partition p848 start (84700),
        partition p849 start (84800),
        partition p850 start (84900),
        partition p851 start (85000),
        partition p852 start (85100),
        partition p853 start (85200),
        partition p854 start (85300),
        partition p855 start (85400),
        partition p856 start (85500),
        partition p857 start (85600),
        partition p858 start (85700),
        partition p859 start (85800),
        partition p860 start (85900),
        partition p861 start (86000),
        partition p862 start (86100),
        partition p863 start (86200),
        partition p864 start (86300),
        partition p865 start (86400),
        partition p866 start (86500),
        partition p867 start (86600),
        partition p868 start (86700),
        partition p869 start (86800),
        partition p870 start (86900),
        partition p871 start (87000),
        partition p872 start (87100),
        partition p873 start (87200),
        partition p874 start (87300),
        partition p875 start (87400),
        partition p876 start (87500),
        partition p877 start (87600),
        partition p878 start (87700),
        partition p879 start (87800),
        partition p880 start (87900),
        partition p881 start (88000),
        partition p882 start (88100),
        partition p883 start (88200),
        partition p884 start (88300),
        partition p885 start (88400),
        partition p886 start (88500),
        partition p887 start (88600),
        partition p888 start (88700),
        partition p889 start (88800),
        partition p890 start (88900),
        partition p891 start (89000),
        partition p892 start (89100),
        partition p893 start (89200),
        partition p894 start (89300),
        partition p895 start (89400),
        partition p896 start (89500),
        partition p897 start (89600),
        partition p898 start (89700),
        partition p899 start (89800),
        partition p900 start (89900),
        partition p901 start (90000),
        partition p902 start (90100),
        partition p903 start (90200),
        partition p904 start (90300),
        partition p905 start (90400),
        partition p906 start (90500),
        partition p907 start (90600),
        partition p908 start (90700),
        partition p909 start (90800),
        partition p910 start (90900),
        partition p911 start (91000),
        partition p912 start (91100),
        partition p913 start (91200),
        partition p914 start (91300),
        partition p915 start (91400),
        partition p916 start (91500),
        partition p917 start (91600),
        partition p918 start (91700),
        partition p919 start (91800),
        partition p920 start (91900),
        partition p921 start (92000),
        partition p922 start (92100),
        partition p923 start (92200),
        partition p924 start (92300),
        partition p925 start (92400),
        partition p926 start (92500),
        partition p927 start (92600),
        partition p928 start (92700),
        partition p929 start (92800),
        partition p930 start (92900),
        partition p931 start (93000),
        partition p932 start (93100),
        partition p933 start (93200),
        partition p934 start (93300),
        partition p935 start (93400),
        partition p936 start (93500),
        partition p937 start (93600),
        partition p938 start (93700),
        partition p939 start (93800),
        partition p940 start (93900),
        partition p941 start (94000),
        partition p942 start (94100),
        partition p943 start (94200),
        partition p944 start (94300),
        partition p945 start (94400),
        partition p946 start (94500),
        partition p947 start (94600),
        partition p948 start (94700),
        partition p949 start (94800),
        partition p950 start (94900),
        partition p951 start (95000),
        partition p952 start (95100),
        partition p953 start (95200),
        partition p954 start (95300),
        partition p955 start (95400),
        partition p956 start (95500),
        partition p957 start (95600),
        partition p958 start (95700),
        partition p959 start (95800),
        partition p960 start (95900),
        partition p961 start (96000),
        partition p962 start (96100),
        partition p963 start (96200),
        partition p964 start (96300),
        partition p965 start (96400),
        partition p966 start (96500),
        partition p967 start (96600),
        partition p968 start (96700),
        partition p969 start (96800),
        partition p970 start (96900),
        partition p971 start (97000),
        partition p972 start (97100),
        partition p973 start (97200),
        partition p974 start (97300),
        partition p975 start (97400),
        partition p976 start (97500),
        partition p977 start (97600),
        partition p978 start (97700),
        partition p979 start (97800),
        partition p980 start (97900),
        partition p981 start (98000),
        partition p982 start (98100),
        partition p983 start (98200),
        partition p984 start (98300),
        partition p985 start (98400),
        partition p986 start (98500),
        partition p987 start (98600),
        partition p988 start (98700),
        partition p989 start (98800),
        partition p990 start (98900),
        partition p991 start (99000),
        partition p992 start (99100),
        partition p993 start (99200),
        partition p994 start (99300),
        partition p995 start (99400),
        partition p996 start (99500),
        partition p997 start (99600),
        partition p998 start (99700),
        partition p999 start (99800),
        partition p1000 start (99900)
);
--10000000
insert into partt select i % 100000 from generate_series(1, 10000000)i;
delete from partt where i%13=0;
update partt set i=i+1%100000 where i%7=0;
update partt set i=i+i%100000 where i%5=0;
update partt set i=(i%10000)*(i%10000) where i%3=0;

insert into partt select i % 100000 from generate_series(1, 10000000)i;
delete from partt where i%17=0;
update partt set i=i+1%100000 where i%19=0;
update partt set i=i+i%100000 where i%23=0;
update partt set i=(i%10000)*(i%10000) where i%29=0;


set allow_system_table_mods=true;
delete from pg_statistic where starelid in (select oid from pg_class join pg_statistic on oid=starelid where relname like 'partt%');

## Patch to undo commit [f2df2a15](f2df2a15d70786bd75679e0a7d4dc1acc46f28cc):

diff --git a/gpMgmt/bin/analyzedb b/gpMgmt/bin/analyzedb
index 1cae7b6c55d..3c9c9102428 100755
--- a/gpMgmt/bin/analyzedb
+++ b/gpMgmt/bin/analyzedb
@@ -493,19 +493,22 @@ class AnalyzeDb(Operation):
         wait_count = num_tables = len(ordered_candidates)
         num_roots = root_pool.assigned
         start_time = time.time()
-        non_root_pool.run()
+        root_pool.run()
         try:
-            while wait_count > num_roots:
-                self.run_analyze_statements(non_root_pool, wait_count, num_tables)
-                wait_count -= 1
-            non_root_pool.join()
-            non_root_pool.haltWork()
-            root_pool.run()
-            while wait_count > 0:
+            while wait_count > (num_tables - num_roots):
                 self.run_analyze_statements(root_pool, wait_count, num_tables)
                 wait_count -= 1
             root_pool.join()
             root_pool.haltWork()
+            non_root_pool.run()
+            while wait_count > 0:
+                self.run_analyze_statements(non_root_pool, wait_count, num_tables)
+                wait_count -= 1
+            non_root_pool.join()
+            non_root_pool.haltWork()
         except:
             non_root_pool.haltWork()
             non_root_pool.joinWorkers()