home *** CD-ROM | disk | FTP | other *** search
open in: 
MacOS 8.1
|
Win98
|
DOS
browse contents |
view JSON data
|
view as text
This file was processed as: Tape Archive
(archive/tar).
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 100%
| dexvert
| Tape Archive (archive/tar)
| magic
| Supported |
| 100%
| file
| POSIX tar archive (GNU)
| default
| |
| 99%
| file
| POSIX tar archive (GNU), symlink COPYRIGHT, mode 777 , uid 6 , gid 0 , size 0 , seconds 5372517275, linkname COPYRIGHT, user postgres, group system
| default
| |
| 98%
| file
| data
| default
| |
| 62%
| TrID
| TAR - Tape ARchive (GNU)
| default
| |
| 37%
| TrID
| TAR - Tape ARchive (symlink)
| default
| |
| 100%
| siegfried
| x-fmt/265 Tape Archive Format
| default
| |
| 100%
| lsar
| Tar
| default
| |
| 100%
| gt2
| TAR Archiv gefunden (Auflistung ist deaktiviert)
| default
| |
| 100%
| disktype
| GNU tar archive
| default
| |
| 100%
| detectItEasy
| Archive: tar
| default
| |
| 100%
| binwalkID
| POSIX tar archive (GNU), owner user name: "T"
| default
| |
| 100%
| xdgMime
| application/x-tar
| default
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 43 4f 50 59 52 49 47 48 | 54 00 00 00 00 00 00 00 |COPYRIGH|T.......|
|00000010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000060| 00 00 00 00 20 20 20 37 | 37 37 20 00 20 20 20 20 |.... 7|77 . |
|00000070| 20 36 20 00 20 20 20 20 | 20 30 20 00 20 20 20 20 | 6 . | 0 . |
|00000080| 20 20 20 20 20 20 30 20 | 20 35 33 37 32 35 31 37 | 0 | 5372517|
|00000090| 32 37 35 20 20 31 33 30 | 32 36 00 20 32 43 4f 50 |275 130|26. 2COP|
|000000a0| 59 52 49 47 48 54 00 00 | 00 00 00 00 00 00 00 00 |YRIGHT..|........|
|000000b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000100| 00 75 73 74 61 72 20 20 | 00 70 6f 73 74 67 72 65 |.ustar |.postgre|
|00000110| 73 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |s.......|........|
|00000120| 00 00 00 00 00 00 00 00 | 00 73 79 73 74 65 6d 00 |........|.system.|
|00000130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000180| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000190| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000200| 62 65 6e 63 68 2f 00 00 | 00 00 00 00 00 00 00 00 |bench/..|........|
|00000210| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000220| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000230| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000240| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000250| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000260| 00 00 00 00 20 20 20 37 | 35 35 20 00 20 20 20 20 |.... 7|55 . |
|00000270| 20 36 20 00 20 20 20 20 | 20 30 20 00 20 20 20 20 | 6 . | 0 . |
|00000280| 20 20 20 20 20 20 30 20 | 20 35 33 37 32 33 33 31 | 0 | 5372331|
|00000290| 32 37 35 20 20 31 31 33 | 31 34 00 20 35 00 00 00 |275 113|14. 5...|
|000002a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000300| 00 75 73 74 61 72 20 20 | 00 70 6f 73 74 67 72 65 |.ustar |.postgre|
|00000310| 73 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |s.......|........|
|00000320| 00 00 00 00 00 00 00 00 | 00 73 79 73 74 65 6d 00 |........|.system.|
|00000330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000340| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000350| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000380| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000400| 62 65 6e 63 68 2f 57 49 | 53 43 2d 52 45 41 44 4d |bench/WI|SC-READM|
|00000410| 45 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |E.......|........|
|00000420| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000430| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000440| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000450| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000460| 00 00 00 00 20 20 20 34 | 34 34 20 00 20 20 20 20 |.... 4|44 . |
|00000470| 20 36 20 00 20 20 20 20 | 20 30 20 00 20 20 20 20 | 6 . | 0 . |
|00000480| 20 20 20 31 37 33 35 20 | 20 35 32 34 37 30 37 33 | 1735 | 5247073|
|00000490| 35 32 37 20 20 31 33 30 | 32 37 00 20 30 00 00 00 |527 130|27. 0...|
|000004a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000500| 00 75 73 74 61 72 20 20 | 00 70 6f 73 74 67 72 65 |.ustar |.postgre|
|00000510| 73 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |s.......|........|
|00000520| 00 00 00 00 00 00 00 00 | 00 73 79 73 74 65 6d 00 |........|.system.|
|00000530| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000540| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000550| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000560| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000570| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000580| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000590| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000600| 54 68 65 20 50 6f 73 74 | 67 72 65 73 20 57 69 73 |The Post|gres Wis|
|00000610| 63 6f 6e 73 69 6e 20 42 | 65 6e 63 68 6d 61 72 6b |consin B|enchmark|
|00000620| 0a 0a 49 6e 20 74 68 69 | 73 20 64 69 72 65 63 74 |..In thi|s direct|
|00000630| 6f 72 79 20 61 72 65 20 | 74 68 65 20 71 75 65 72 |ory are |the quer|
|00000640| 69 65 73 20 61 6e 64 20 | 72 61 77 20 64 61 74 61 |ies and |raw data|
|00000650| 20 66 69 6c 65 73 20 75 | 73 65 64 20 74 6f 20 70 | files u|sed to p|
|00000660| 6f 70 75 6c 61 74 65 20 | 74 68 65 0a 50 6f 73 74 |opulate |the.Post|
|00000670| 67 72 65 73 20 76 65 72 | 73 69 6f 6e 20 6f 66 20 |gres ver|sion of |
|00000680| 74 68 65 20 57 69 73 63 | 6f 6e 73 69 6e 20 62 65 |the Wisc|onsin be|
|00000690| 6e 63 68 6d 61 72 6b 2e | 20 20 49 6e 20 6f 72 64 |nchmark.| In ord|
|000006a0| 65 72 20 74 6f 20 72 75 | 6e 20 74 68 65 20 62 65 |er to ru|n the be|
|000006b0| 6e 63 68 6d 61 72 6b 2c | 0a 79 6f 75 27 6c 6c 20 |nchmark,|.you'll |
|000006c0| 69 6e 69 74 69 61 6c 6c | 79 20 6e 65 65 64 20 74 |initiall|y need t|
|000006d0| 6f 20 65 78 65 63 75 74 | 65 20 74 68 65 20 73 63 |o execut|e the sc|
|000006e0| 72 69 70 74 0a 0a 2e 2f | 63 72 65 61 74 65 2e 73 |ript.../|create.s|
|000006f0| 68 0a 0a 77 68 69 63 68 | 20 77 69 6c 6c 20 70 6f |h..which| will po|
|00000700| 70 75 6c 61 74 65 20 74 | 68 65 20 22 62 65 6e 63 |pulate t|he "benc|
|00000710| 68 22 20 64 61 74 61 62 | 61 73 65 2c 20 63 72 65 |h" datab|ase, cre|
|00000720| 61 74 65 20 74 68 65 20 | 69 6e 64 69 63 65 73 2c |ate the |indices,|
|00000730| 20 61 6e 64 20 76 61 63 | 75 75 6d 20 74 68 65 0a | and vac|uum the.|
|00000740| 64 61 74 61 62 61 73 65 | 2e 20 20 54 68 69 73 20 |database|. This |
|00000750| 77 69 6c 6c 20 74 61 6b | 65 20 66 72 6f 6d 20 31 |will tak|e from 1|
|00000760| 30 20 6d 69 6e 75 74 65 | 73 20 6f 72 20 73 6f 20 |0 minute|s or so |
|00000770| 6f 6e 20 61 20 53 70 61 | 72 63 20 49 49 2f 44 45 |on a Spa|rc II/DE|
|00000780| 43 73 74 61 74 69 6f 6e | 20 35 30 30 30 0a 63 6c |Cstation| 5000.cl|
|00000790| 61 73 73 20 6d 61 63 68 | 69 6e 65 20 74 6f 20 61 |ass mach|ine to a|
|000007a0| 6e 20 68 6f 75 72 20 6f | 6e 20 61 20 53 75 6e 20 |n hour o|n a Sun |
|000007b0| 33 2e 0a 0a 4f 6e 63 65 | 20 63 72 65 61 74 65 2e |3...Once| create.|
|000007c0| 73 68 20 63 6f 6d 70 6c | 65 74 65 73 2c 20 79 6f |sh compl|etes, yo|
|000007d0| 75 20 63 61 6e 20 65 78 | 65 63 75 74 65 20 74 68 |u can ex|ecute th|
|000007e0| 65 20 62 65 6e 63 68 6d | 61 72 6b 20 62 79 20 72 |e benchm|ark by r|
|000007f0| 75 6e 6e 69 6e 67 20 74 | 68 65 0a 73 63 72 69 70 |unning t|he.scrip|
|00000800| 74 0a 0a 2e 2f 72 75 6e | 77 69 73 63 2e 73 68 0a |t.../run|wisc.sh.|
|00000810| 0a 69 6e 74 6f 20 61 6e | 20 6f 75 74 70 75 74 20 |.into an| output |
|00000820| 66 69 6c 65 2e 20 20 54 | 68 69 73 20 6f 75 74 70 |file. T|his outp|
|00000830| 75 74 20 66 69 6c 65 20 | 6d 61 79 20 62 65 20 71 |ut file |may be q|
|00000840| 75 69 74 65 20 6c 61 72 | 67 65 20 28 33 30 30 4b |uite lar|ge (300K|
|00000850| 20 6f 72 20 73 6f 29 0a | 73 6f 20 6d 61 6b 65 20 | or so).|so make |
|00000860| 73 75 72 65 20 79 6f 75 | 20 68 61 76 65 20 73 75 |sure you| have su|
|00000870| 66 66 69 63 69 65 6e 74 | 20 64 69 73 6b 20 73 70 |fficient| disk sp|
|00000880| 61 63 65 2e 20 20 4f 6e | 63 65 20 74 68 65 20 62 |ace. On|ce the b|
|00000890| 65 6e 63 68 6d 61 72 6b | 20 72 75 6e 20 68 61 73 |enchmark| run has|
|000008a0| 0a 63 6f 6d 70 6c 65 74 | 65 64 2c 20 71 75 65 72 |.complet|ed, quer|
|000008b0| 79 20 65 78 65 63 75 74 | 69 6f 6e 20 74 69 6d 65 |y execut|ion time|
|000008c0| 73 20 63 61 6e 20 62 65 | 20 6f 62 74 61 69 6e 65 |s can be| obtaine|
|000008d0| 64 20 62 79 20 72 75 6e | 6e 69 6e 67 20 74 68 65 |d by run|ning the|
|000008e0| 20 0a 0a 2e 2f 70 65 72 | 71 75 65 72 79 0a 0a 73 | .../per|query..s|
|000008f0| 63 72 69 70 74 20 6f 6e | 20 74 68 65 20 6f 75 74 |cript on| the out|
|00000900| 70 75 74 20 66 69 6c 65 | 2e 20 20 49 74 20 77 69 |put file|. It wi|
|00000910| 6c 6c 20 67 65 6e 65 72 | 61 74 65 20 61 20 6e 69 |ll gener|ate a ni|
|00000920| 63 65 6c 79 20 66 6f 72 | 6d 61 74 74 65 64 2c 20 |cely for|matted, |
|00000930| 6e 75 6d 62 65 72 65 64 | 0a 73 65 74 20 6f 66 20 |numbered|.set of |
|00000940| 6f 75 74 70 75 74 20 77 | 69 74 68 20 74 69 6d 65 |output w|ith time|
|00000950| 73 20 66 6f 72 20 65 61 | 63 68 20 71 75 65 72 79 |s for ea|ch query|
|00000960| 20 69 6e 64 69 63 61 74 | 65 64 2e 20 20 28 4e 6f | indicat|ed. (No|
|00000970| 74 65 20 74 68 61 74 20 | 65 61 63 68 20 71 75 65 |te that |each que|
|00000980| 72 79 0a 69 73 20 72 75 | 6e 20 74 77 69 63 65 2e |ry.is ru|n twice.|
|00000990| 29 0a 0a 20 20 21 21 21 | 20 57 41 52 4e 49 4e 47 |).. !!!| WARNING|
|000009a0| 21 20 20 44 4f 20 4e 4f | 54 20 52 55 4e 20 54 48 |! DO NO|T RUN TH|
|000009b0| 45 53 45 20 53 43 52 49 | 50 54 53 20 49 46 20 54 |ESE SCRI|PTS IF T|
|000009c0| 48 45 20 50 4f 53 54 4d | 41 53 54 45 52 20 49 53 |HE POSTM|ASTER IS|
|000009d0| 20 52 55 4e 4e 49 4e 47 | 20 21 21 21 0a 00 00 00 | RUNNING| !!!....|
|000009e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a00| 62 65 6e 63 68 2f 63 72 | 65 61 74 65 2e 73 68 00 |bench/cr|eate.sh.|
|00000a10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a60| 00 00 00 00 20 20 20 35 | 35 35 20 00 20 20 20 20 |.... 5|55 . |
|00000a70| 20 36 20 00 20 20 20 20 | 20 30 20 00 20 20 20 20 | 6 . | 0 . |
|00000a80| 20 20 20 31 32 37 34 20 | 20 35 32 34 37 30 37 33 | 1274 | 5247073|
|00000a90| 35 32 37 20 20 31 33 32 | 30 34 00 20 30 00 00 00 |527 132|04. 0...|
|00000aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ab0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ac0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ad0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ae0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000af0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b00| 00 75 73 74 61 72 20 20 | 00 70 6f 73 74 67 72 65 |.ustar |.postgre|
|00000b10| 73 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |s.......|........|
|00000b20| 00 00 00 00 00 00 00 00 | 00 73 79 73 74 65 6d 00 |........|.system.|
|00000b30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ba0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000be0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c00| 23 21 2f 62 69 6e 2f 73 | 68 0a 23 20 24 48 45 41 |#!/bin/s|h.# $HEA|
|00000c10| 44 45 52 3a 0a 23 20 0a | 23 20 77 69 73 63 6f 6e |DER:.# .|# wiscon|
|00000c20| 73 69 6e 2e 73 68 20 2d | 20 70 6f 70 75 6c 61 74 |sin.sh -| populat|
|00000c30| 65 73 20 61 6e 64 20 72 | 75 6e 73 20 74 68 65 20 |es and r|uns the |
|00000c40| 77 69 73 63 6f 6e 73 69 | 6e 20 62 65 6e 63 68 6d |wisconsi|n benchm|
|00000c50| 61 72 6b 20 6f 6e 20 61 | 20 64 61 74 61 62 61 73 |ark on a| databas|
|00000c60| 65 0a 23 20 6e 61 6d 65 | 64 20 22 62 65 6e 63 68 |e.# name|d "bench|
|00000c70| 22 2e 0a 23 0a 0a 69 66 | 20 28 74 65 73 74 20 21 |"..#..if| (test !|
|00000c80| 20 2d 7a 20 22 24 50 4f | 53 54 47 52 45 53 48 4f | -z "$PO|STGRESHO|
|00000c90| 4d 45 22 29 0a 74 68 65 | 6e 0a 20 20 20 20 50 47 |ME").the|n. PG|
|00000ca0| 48 4f 4d 45 3d 24 50 4f | 53 54 47 52 45 53 48 4f |HOME=$PO|STGRESHO|
|00000cb0| 4d 45 0a 65 6c 73 65 0a | 20 20 20 20 50 47 48 4f |ME.else.| PGHO|
|00000cc0| 4d 45 3d 2f 75 73 72 2f | 70 6f 73 74 67 72 65 73 |ME=/usr/|postgres|
|00000cd0| 0a 66 69 0a 0a 50 4f 53 | 54 47 52 45 53 3d 24 50 |.fi..POS|TGRES=$P|
|00000ce0| 47 48 4f 4d 45 2f 62 69 | 6e 2f 70 6f 73 74 67 72 |GHOME/bi|n/postgr|
|00000cf0| 65 73 0a 50 4f 53 54 4d | 41 53 54 45 52 3d 24 50 |es.POSTM|ASTER=$P|
|00000d00| 47 48 4f 4d 45 2f 62 69 | 6e 2f 70 6f 73 74 6d 61 |GHOME/bi|n/postma|
|00000d10| 73 74 65 72 0a 43 52 45 | 41 54 45 44 42 3d 24 50 |ster.CRE|ATEDB=$P|
|00000d20| 47 48 4f 4d 45 2f 62 69 | 6e 2f 63 72 65 61 74 65 |GHOME/bi|n/create|
|00000d30| 64 62 2e 73 68 0a 56 43 | 4f 4e 54 52 4f 4c 3d 24 |db.sh.VC|ONTROL=$|
|00000d40| 50 47 48 4f 4d 45 2f 62 | 69 6e 2f 76 63 6f 6e 74 |PGHOME/b|in/vcont|
|00000d50| 72 6f 6c 0a 4d 41 4b 45 | 3d 2f 62 69 6e 2f 6d 61 |rol.MAKE|=/bin/ma|
|00000d60| 6b 65 0a 0a 65 63 68 6f | 20 3d 3d 3d 3d 3d 20 63 |ke..echo| ===== c|
|00000d70| 72 65 61 74 69 6e 67 20 | 62 65 6e 63 68 6d 61 72 |reating |benchmar|
|00000d80| 6b 20 64 61 74 61 62 61 | 73 65 20 3d 3d 3d 3d 3d |k databa|se =====|
|00000d90| 3d 0a 0a 24 43 52 45 41 | 54 45 44 42 20 62 65 6e |=..$CREA|TEDB ben|
|00000da0| 63 68 0a 0a 65 63 68 6f | 20 3d 3d 3d 3d 3d 20 70 |ch..echo| ===== p|
|00000db0| 6f 70 75 6c 61 74 69 6e | 67 20 69 6e 69 74 69 61 |opulatin|g initia|
|00000dc0| 6c 20 63 6c 61 73 73 65 | 73 20 3d 3d 3d 3d 3d 3d |l classe|s ======|
|00000dd0| 0a 0a 66 6f 72 20 69 20 | 69 6e 20 71 75 65 72 79 |..for i |in query|
|00000de0| 63 72 65 61 74 20 71 75 | 65 72 79 63 6f 70 79 20 |creat qu|erycopy |
|00000df0| 71 75 65 72 79 64 65 66 | 69 6e 65 69 6e 64 65 78 |querydef|ineindex|
|00000e00| 20 71 75 65 72 79 42 70 | 72 69 6d 65 0a 64 6f 0a | queryBp|rime.do.|
|00000e10| 20 20 20 20 65 63 68 6f | 20 52 75 6e 6e 69 6e 67 | echo| Running|
|00000e20| 20 24 69 2e 2e 2e 2e 0a | 20 20 20 20 24 50 4f 53 | $i.....| $POS|
|00000e30| 54 47 52 45 53 20 2d 51 | 20 62 65 6e 63 68 20 3c |TGRES -Q| bench <|
|00000e40| 20 24 69 20 3e 20 2f 64 | 65 76 2f 6e 75 6c 6c 0a | $i > /d|ev/null.|
|00000e50| 64 6f 6e 65 0a 0a 65 63 | 68 6f 20 3d 3d 3d 3d 3d |done..ec|ho =====|
|00000e60| 20 76 61 63 75 75 6d 69 | 6e 67 20 62 65 6e 63 68 | vacuumi|ng bench|
|00000e70| 20 64 61 74 61 62 61 73 | 65 20 3d 3d 3d 3d 3d 3d | databas|e ======|
|00000e80| 0a 65 63 68 6f 20 22 76 | 61 63 75 75 6d 22 20 7c |.echo "v|acuum" ||
|00000e90| 20 24 50 4f 53 54 47 52 | 45 53 20 2d 51 20 62 65 | $POSTGR|ES -Q be|
|00000ea0| 6e 63 68 20 3e 20 2f 64 | 65 76 2f 6e 75 6c 6c 0a |nch > /d|ev/null.|
|00000eb0| 0a 65 63 68 6f 20 64 6f | 6e 65 20 0a 00 00 00 00 |.echo do|ne .....|
|00000ec0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ed0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ee0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ef0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fe0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ff0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001000| 62 65 6e 63 68 2f 64 75 | 73 74 62 75 73 74 65 72 |bench/du|stbuster|
|00001010| 2e 63 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |.c......|........|
|00001020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001060| 00 00 00 00 20 20 20 34 | 34 34 20 00 20 20 20 20 |.... 4|44 . |
|00001070| 20 36 20 00 20 20 20 20 | 20 30 20 00 20 20 20 20 | 6 . | 0 . |
|00001080| 20 20 20 35 37 31 36 20 | 20 35 32 34 37 30 37 33 | 5716 | 5247073|
|00001090| 35 32 37 20 20 31 33 37 | 35 37 00 20 30 00 00 00 |527 137|57. 0...|
|000010a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001100| 00 75 73 74 61 72 20 20 | 00 70 6f 73 74 67 72 65 |.ustar |.postgre|
|00001110| 73 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |s.......|........|
|00001120| 00 00 00 00 00 00 00 00 | 00 73 79 73 74 65 6d 00 |........|.system.|
|00001130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001180| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001190| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000011a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000011b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000011c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000011d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000011e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000011f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001200| 23 69 6e 63 6c 75 64 65 | 20 22 74 6d 70 2f 70 6f |#include| "tmp/po|
|00001210| 73 74 67 72 65 73 2e 68 | 22 0a 23 69 6e 63 6c 75 |stgres.h|".#inclu|
|00001220| 64 65 20 22 74 6d 70 2f | 63 2e 68 22 0a 0a 23 69 |de "tmp/|c.h"..#i|
|00001230| 6e 63 6c 75 64 65 20 22 | 73 74 6f 72 61 67 65 2f |nclude "|storage/|
|00001240| 62 75 66 70 61 67 65 2e | 68 22 0a 23 69 6e 63 6c |bufpage.|h".#incl|
|00001250| 75 64 65 20 22 75 74 69 | 6c 73 2f 6c 6f 67 2e 68 |ude "uti|ls/log.h|
|00001260| 22 0a 0a 23 69 6e 63 6c | 75 64 65 20 22 61 63 63 |"..#incl|ude "acc|
|00001270| 65 73 73 2f 67 65 6e 61 | 6d 2e 68 22 0a 23 69 6e |ess/gena|m.h".#in|
|00001280| 63 6c 75 64 65 20 22 61 | 63 63 65 73 73 2f 68 65 |clude "a|ccess/he|
|00001290| 61 70 61 6d 2e 68 22 0a | 23 69 6e 63 6c 75 64 65 |apam.h".|#include|
|000012a0| 20 22 61 63 63 65 73 73 | 2f 74 71 75 61 6c 2e 68 | "access|/tqual.h|
|000012b0| 22 0a 0a 23 69 6e 63 6c | 75 64 65 20 22 63 61 74 |"..#incl|ude "cat|
|000012c0| 61 6c 6f 67 2f 70 67 5f | 72 65 6c 61 74 69 6f 6e |alog/pg_|relation|
|000012d0| 2e 68 22 0a 0a 2f 2a 0a | 20 2a 20 20 64 75 73 74 |.h"../*.| * dust|
|000012e0| 62 75 73 74 65 72 28 29 | 20 2d 2d 20 61 20 70 6f |buster()| -- a po|
|000012f0| 72 74 61 62 6c 65 20 70 | 6f 73 74 67 72 65 73 20 |rtable p|ostgres |
|00001300| 76 61 63 75 75 6d 20 63 | 6c 65 61 6e 65 72 2e 0a |vacuum c|leaner..|
|00001310| 20 2a 0a 20 2a 09 54 68 | 69 73 20 72 6f 75 74 69 | *. *.Th|is routi|
|00001320| 6e 65 20 64 6f 65 73 6e | 27 74 20 64 6f 20 61 6e |ne doesn|'t do an|
|00001330| 79 20 75 70 64 61 74 65 | 73 20 6f 6e 20 69 74 73 |y update|s on its|
|00001340| 20 6f 77 6e 20 62 65 68 | 61 6c 66 2c 20 73 6f 20 | own beh|alf, so |
|00001350| 69 74 0a 20 2a 09 77 6f | 75 6c 64 6e 27 74 20 72 |it. *.wo|uldn't r|
|00001360| 65 61 6c 6c 79 20 6d 61 | 74 74 65 72 20 69 66 20 |eally ma|tter if |
|00001370| 69 74 20 76 69 6f 6c 61 | 74 65 64 20 74 77 6f 2d |it viola|ted two-|
|00001380| 70 68 61 73 65 20 6c 6f | 63 6b 69 6e 67 2e 20 20 |phase lo|cking. |
|00001390| 48 6f 77 65 76 65 72 2c | 0a 20 2a 09 64 75 65 20 |However,|. *.due |
|000013a0| 74 6f 20 61 20 62 75 67 | 20 49 20 64 6f 6e 27 74 |to a bug| I don't|
|000013b0| 20 75 6e 64 65 72 73 74 | 61 6e 64 20 69 6e 20 74 | underst|and in t|
|000013c0| 68 65 20 6c 6f 63 6b 20 | 6d 61 6e 61 67 65 72 2c |he lock |manager,|
|000013d0| 20 77 65 20 63 61 6e 27 | 74 0a 20 2a 09 65 76 65 | we can'|t. *.eve|
|000013e0| 6e 20 64 6f 20 73 68 6f | 72 74 2d 74 65 72 6d 20 |n do sho|rt-term |
|000013f0| 77 72 69 74 65 20 6c 6f | 63 6b 73 20 69 6e 20 74 |write lo|cks in t|
|00001400| 68 65 20 69 6e 6e 65 72 | 20 73 63 61 6e 20 68 65 |he inner| scan he|
|00001410| 72 65 20 2d 2d 20 74 68 | 65 20 6c 6f 63 6b 0a 20 |re -- th|e lock. |
|00001420| 2a 09 6d 61 6e 61 67 65 | 72 20 62 69 74 63 68 65 |*.manage|r bitche|
|00001430| 73 20 61 62 6f 75 74 20 | 61 6e 20 61 74 74 65 6d |s about |an attem|
|00001440| 70 74 20 74 6f 20 72 65 | 6c 65 61 73 65 20 61 20 |pt to re|lease a |
|00001450| 77 72 69 74 65 20 6c 6f | 63 6b 20 74 68 61 74 20 |write lo|ck that |
|00001460| 77 65 0a 20 2a 09 64 65 | 66 69 6e 69 74 65 6c 79 |we. *.de|finitely|
|00001470| 20 68 61 76 65 2e 0a 20 | 2a 0a 20 2a 09 53 69 6e | have.. |*. *.Sin|
|00001480| 63 65 20 74 68 65 20 6f | 6e 6c 79 20 74 68 69 6e |ce the o|nly thin|
|00001490| 67 20 77 65 20 75 70 64 | 61 74 65 20 69 73 20 73 |g we upd|ate is s|
|000014a0| 74 75 66 66 20 74 68 61 | 74 20 6f 74 68 65 72 20 |tuff tha|t other |
|000014b0| 72 6f 75 74 69 6e 65 73 | 20 68 61 76 65 0a 20 2a |routines| have. *|
|000014c0| 09 74 6f 20 66 69 6c 6c | 20 69 6e 20 61 6e 79 77 |.to fill| in anyw|
|000014d0| 61 79 2c 20 74 68 69 73 | 20 73 68 6f 75 6c 64 6e |ay, this| shouldn|
|000014e0| 27 74 20 6d 61 74 74 65 | 72 20 76 65 72 79 20 6d |'t matte|r very m|
|000014f0| 75 63 68 2e 20 20 53 74 | 69 6c 6c 2c 20 79 6f 75 |uch. St|ill, you|
|00001500| 0a 20 2a 09 6d 69 67 68 | 74 20 66 65 65 6c 20 62 |. *.migh|t feel b|
|00001510| 65 74 74 65 72 20 72 75 | 6e 6e 69 6e 67 20 74 68 |etter ru|nning th|
|00001520| 69 73 20 73 69 6e 67 6c | 65 2d 75 73 65 72 2e 0a |is singl|e-user..|
|00001530| 20 2a 0a 20 2a 09 54 61 | 6b 65 73 20 6e 6f 20 70 | *. *.Ta|kes no p|
|00001540| 61 72 61 6d 65 74 65 72 | 73 3b 20 72 65 74 75 72 |arameter|s; retur|
|00001550| 6e 73 20 74 68 65 20 6e | 75 6d 62 65 72 20 6f 66 |ns the n|umber of|
|00001560| 20 74 75 70 6c 65 73 20 | 63 6c 65 61 6e 65 64 2c | tuples |cleaned,|
|00001570| 20 69 6e 20 6c 69 65 75 | 0a 20 2a 09 6f 66 20 61 | in lieu|. *.of a|
|00001580| 6e 79 20 6d 6f 72 65 20 | 69 6e 74 65 72 65 73 74 |ny more |interest|
|00001590| 69 6e 67 20 72 65 73 75 | 6c 74 2e 0a 20 2a 2f 0a |ing resu|lt.. */.|
|000015a0| 0a 69 6e 74 33 32 0a 64 | 75 73 74 62 75 73 74 65 |.int32.d|ustbuste|
|000015b0| 72 28 29 0a 7b 0a 20 20 | 20 20 52 65 6c 61 74 69 |r().{. | Relati|
|000015c0| 6f 6e 20 70 67 72 65 6c | 3b 0a 20 20 20 20 54 75 |on pgrel|;. Tu|
|000015d0| 70 6c 65 44 65 73 63 72 | 69 70 74 6f 72 20 74 75 |pleDescr|iptor tu|
|000015e0| 70 64 65 73 63 3b 0a 20 | 20 20 20 48 65 61 70 53 |pdesc;. | HeapS|
|000015f0| 63 61 6e 44 65 73 63 20 | 72 65 6c 73 63 61 6e 3b |canDesc |relscan;|
|00001600| 0a 20 20 20 20 48 65 61 | 70 53 63 61 6e 44 65 73 |. Hea|pScanDes|
|00001610| 63 20 73 63 61 6e 3b 0a | 20 20 20 20 4e 61 6d 65 |c scan;.| Name|
|00001620| 20 72 6e 61 6d 65 3b 0a | 20 20 20 20 63 68 61 72 | rname;.| char|
|00001630| 20 72 74 79 70 65 3b 0a | 20 20 20 20 52 65 6c 61 | rtype;.| Rela|
|00001640| 74 69 6f 6e 20 6f 6e 65 | 72 65 6c 3b 0a 20 20 20 |tion one|rel;. |
|00001650| 20 48 65 61 70 54 75 70 | 6c 65 20 68 74 75 70 3b | HeapTup|le htup;|
|00001660| 0a 20 20 20 20 48 65 61 | 70 54 75 70 6c 65 20 72 |. Hea|pTuple r|
|00001670| 65 6c 74 75 70 3b 0a 20 | 20 20 20 42 75 66 66 65 |eltup;. | Buffe|
|00001680| 72 20 62 75 66 2c 20 62 | 75 66 32 3b 0a 20 20 20 |r buf, b|uf2;. |
|00001690| 20 50 61 67 65 20 70 61 | 67 65 3b 0a 20 20 20 20 | Page pa|ge;. |
|000016a0| 4f 66 66 73 65 74 49 6e | 64 65 78 20 6f 66 66 69 |OffsetIn|dex offi|
|000016b0| 6e 64 2c 20 6d 61 78 6f | 66 66 3b 0a 20 20 20 20 |nd, maxo|ff;. |
|000016c0| 49 74 65 6d 49 64 20 69 | 74 65 6d 69 64 3b 0a 20 |ItemId i|temid;. |
|000016d0| 20 20 20 69 6e 74 20 62 | 6c 6b 6e 6f 2c 20 6e 62 | int b|lkno, nb|
|000016e0| 6c 6f 63 6b 73 3b 0a 20 | 20 20 20 69 6e 74 20 6e |locks;. | int n|
|000016f0| 63 68 61 6e 67 65 73 3b | 0a 20 20 20 20 44 61 74 |changes;|. Dat|
|00001700| 75 6d 20 64 3b 0a 20 20 | 20 20 42 6f 6f 6c 65 61 |um d;. | Boolea|
|00001710| 6e 20 74 75 70 63 68 6e | 67 2c 20 63 68 61 6e 67 |n tupchn|g, chang|
|00001720| 65 64 3b 0a 20 20 20 20 | 42 6f 6f 6c 65 61 6e 20 |ed;. |Boolean |
|00001730| 6e 3b 0a 0a 20 20 20 20 | 70 67 72 65 6c 20 3d 20 |n;.. |pgrel = |
|00001740| 68 65 61 70 5f 6f 70 65 | 6e 72 28 4e 61 6d 65 5f |heap_ope|nr(Name_|
|00001750| 70 67 5f 72 65 6c 61 74 | 69 6f 6e 29 3b 0a 20 20 |pg_relat|ion);. |
|00001760| 20 20 74 75 70 64 65 73 | 63 20 3d 20 52 65 6c 61 | tupdes|c = Rela|
|00001770| 74 69 6f 6e 47 65 74 54 | 75 70 6c 65 44 65 73 63 |tionGetT|upleDesc|
|00001780| 72 69 70 74 6f 72 28 70 | 67 72 65 6c 29 3b 0a 20 |riptor(p|grel);. |
|00001790| 20 20 20 72 65 6c 73 63 | 61 6e 20 3d 20 68 65 61 | relsc|an = hea|
|000017a0| 70 5f 62 65 67 69 6e 73 | 63 61 6e 28 70 67 72 65 |p_begins|can(pgre|
|000017b0| 6c 2c 20 30 2c 20 4e 55 | 4c 4c 2c 20 30 2c 20 4e |l, 0, NU|LL, 0, N|
|000017c0| 55 4c 4c 29 3b 0a 0a 20 | 20 20 20 6e 63 68 61 6e |ULL);.. | nchan|
|000017d0| 67 65 73 20 3d 20 30 3b | 0a 20 20 20 20 77 68 69 |ges = 0;|. whi|
|000017e0| 6c 65 20 28 48 65 61 70 | 54 75 70 6c 65 49 73 56 |le (Heap|TupleIsV|
|000017f0| 61 6c 69 64 28 72 65 6c | 74 75 70 20 3d 20 68 65 |alid(rel|tup = he|
|00001800| 61 70 5f 67 65 74 6e 65 | 78 74 28 72 65 6c 73 63 |ap_getne|xt(relsc|
|00001810| 61 6e 2c 20 30 2c 20 26 | 62 75 66 29 29 29 20 7b |an, 0, &|buf))) {|
|00001820| 0a 09 69 66 20 28 21 48 | 65 61 70 54 75 70 6c 65 |..if (!H|eapTuple|
|00001830| 53 61 74 69 73 66 69 65 | 73 54 69 6d 65 51 75 61 |Satisfie|sTimeQua|
|00001840| 6c 28 72 65 6c 74 75 70 | 2c 20 4e 6f 77 54 69 6d |l(reltup|, NowTim|
|00001850| 65 51 75 61 6c 29 29 0a | 09 20 20 20 20 63 6f 6e |eQual)).|. con|
|00001860| 74 69 6e 75 65 3b 0a 0a | 09 64 20 3d 20 28 44 61 |tinue;..|.d = (Da|
|00001870| 74 75 6d 29 20 68 65 61 | 70 5f 67 65 74 61 74 74 |tum) hea|p_getatt|
|00001880| 72 28 72 65 6c 74 75 70 | 2c 20 62 75 66 2c 20 41 |r(reltup|, buf, A|
|00001890| 6e 75 6d 5f 70 67 5f 72 | 65 6c 61 74 69 6f 6e 5f |num_pg_r|elation_|
|000018a0| 72 65 6c 6b 69 6e 64 2c | 0a 09 09 09 09 20 74 75 |relkind,|..... tu|
|000018b0| 70 64 65 73 63 2c 20 26 | 6e 29 3b 0a 09 72 74 79 |pdesc, &|n);..rty|
|000018c0| 70 65 20 3d 20 28 63 68 | 61 72 29 20 44 61 74 75 |pe = (ch|ar) Datu|
|000018d0| 6d 47 65 74 43 68 61 72 | 28 64 29 3b 0a 09 69 66 |mGetChar|(d);..if|
|000018e0| 20 28 72 74 79 70 65 20 | 21 3d 20 27 72 27 29 0a | (rtype |!= 'r').|
|000018f0| 09 20 20 20 20 63 6f 6e | 74 69 6e 75 65 3b 0a 0a |. con|tinue;..|
|00001900| 09 64 20 3d 20 28 44 61 | 74 75 6d 29 20 68 65 61 |.d = (Da|tum) hea|
|00001910| 70 5f 67 65 74 61 74 74 | 72 28 72 65 6c 74 75 70 |p_getatt|r(reltup|
|00001920| 2c 20 62 75 66 2c 20 41 | 6e 75 6d 5f 70 67 5f 72 |, buf, A|num_pg_r|
|00001930| 65 6c 61 74 69 6f 6e 5f | 72 65 6c 6e 61 6d 65 2c |elation_|relname,|
|00001940| 0a 09 09 09 09 20 74 75 | 70 64 65 73 63 2c 20 26 |..... tu|pdesc, &|
|00001950| 6e 29 3b 0a 09 72 6e 61 | 6d 65 20 3d 20 28 4e 61 |n);..rna|me = (Na|
|00001960| 6d 65 29 20 44 61 74 75 | 6d 47 65 74 4e 61 6d 65 |me) Datu|mGetName|
|00001970| 28 64 29 3b 0a 09 6f 6e | 65 72 65 6c 20 3d 20 68 |(d);..on|erel = h|
|00001980| 65 61 70 5f 6f 70 65 6e | 72 28 72 6e 61 6d 65 29 |eap_open|r(rname)|
|00001990| 3b 0a 09 6e 62 6c 6f 63 | 6b 73 20 3d 20 52 65 6c |;..nbloc|ks = Rel|
|000019a0| 61 74 69 6f 6e 47 65 74 | 4e 75 6d 62 65 72 4f 66 |ationGet|NumberOf|
|000019b0| 42 6c 6f 63 6b 73 28 6f | 6e 65 72 65 6c 29 3b 0a |Blocks(o|nerel);.|
|000019c0| 0a 09 66 6f 72 20 28 62 | 6c 6b 6e 6f 20 3d 20 30 |..for (b|lkno = 0|
|000019d0| 3b 20 62 6c 6b 6e 6f 20 | 3c 20 6e 62 6c 6f 63 6b |; blkno |< nblock|
|000019e0| 73 3b 20 62 6c 6b 6e 6f | 2b 2b 29 20 7b 0a 0a 09 |s; blkno|++) {...|
|000019f0| 20 20 20 20 63 68 61 6e | 67 65 64 20 3d 20 66 61 | chan|ged = fa|
|00001a00| 6c 73 65 3b 0a 09 20 20 | 20 20 62 75 66 32 20 3d |lse;.. | buf2 =|
|00001a10| 20 52 65 61 64 42 75 66 | 66 65 72 28 6f 6e 65 72 | ReadBuf|fer(oner|
|00001a20| 65 6c 2c 20 62 6c 6b 6e | 6f 29 3b 0a 09 20 20 20 |el, blkn|o);.. |
|00001a30| 20 70 61 67 65 20 3d 20 | 42 75 66 66 65 72 47 65 | page = |BufferGe|
|00001a40| 74 50 61 67 65 28 62 75 | 66 32 2c 20 30 29 3b 0a |tPage(bu|f2, 0);.|
|00001a50| 09 20 20 20 20 6d 61 78 | 6f 66 66 20 3d 20 50 61 |. max|off = Pa|
|00001a60| 67 65 47 65 74 4d 61 78 | 4f 66 66 73 65 74 49 6e |geGetMax|OffsetIn|
|00001a70| 64 65 78 28 70 61 67 65 | 29 3b 0a 0a 09 20 20 20 |dex(page|);... |
|00001a80| 20 66 6f 72 20 28 6f 66 | 66 69 6e 64 20 3d 20 30 | for (of|find = 0|
|00001a90| 3b 20 6f 66 66 69 6e 64 | 20 3c 3d 20 6d 61 78 6f |; offind| <= maxo|
|00001aa0| 66 66 3b 20 6f 66 66 69 | 6e 64 2b 2b 29 20 7b 0a |ff; offi|nd++) {.|
|00001ab0| 0a 09 09 69 74 65 6d 69 | 64 20 3d 20 50 61 67 65 |...itemi|d = Page|
|00001ac0| 47 65 74 49 74 65 6d 49 | 64 28 70 61 67 65 2c 20 |GetItemI|d(page, |
|00001ad0| 6f 66 66 69 6e 64 29 3b | 0a 09 09 69 66 20 28 21 |offind);|...if (!|
|00001ae0| 49 74 65 6d 49 64 49 73 | 55 73 65 64 28 69 74 65 |ItemIdIs|Used(ite|
|00001af0| 6d 69 64 29 29 0a 09 09 | 20 20 20 20 63 6f 6e 74 |mid))...| cont|
|00001b00| 69 6e 75 65 3b 0a 0a 09 | 09 68 74 75 70 20 3d 20 |inue;...|.htup = |
|00001b10| 28 48 65 61 70 54 75 70 | 6c 65 29 20 50 61 67 65 |(HeapTup|le) Page|
|00001b20| 47 65 74 49 74 65 6d 28 | 70 61 67 65 2c 20 69 74 |GetItem(|page, it|
|00001b30| 65 6d 69 64 29 3b 0a 09 | 09 74 75 70 63 68 6e 67 |emid);..|.tupchng|
|00001b40| 20 3d 20 66 61 6c 73 65 | 3b 0a 0a 09 09 69 66 20 | = false|;....if |
|00001b50| 28 68 74 75 70 2d 3e 74 | 5f 74 6d 69 6e 20 3d 3d |(htup->t|_tmin ==|
|00001b60| 20 30 20 26 26 20 54 72 | 61 6e 73 61 63 74 69 6f | 0 && Tr|ansactio|
|00001b70| 6e 49 64 49 73 56 61 6c | 69 64 28 68 74 75 70 2d |nIdIsVal|id(htup-|
|00001b80| 3e 74 5f 78 6d 69 6e 29 | 0a 09 09 20 20 20 20 26 |>t_xmin)|... &|
|00001b90| 26 20 54 72 61 6e 73 61 | 63 74 69 6f 6e 49 64 44 |& Transa|ctionIdD|
|00001ba0| 69 64 43 6f 6d 6d 69 74 | 28 68 74 75 70 2d 3e 74 |idCommit|(htup->t|
|00001bb0| 5f 78 6d 69 6e 29 29 20 | 7b 0a 09 09 20 20 20 20 |_xmin)) |{... |
|00001bc0| 68 74 75 70 2d 3e 74 5f | 74 6d 69 6e 20 3d 20 54 |htup->t_|tmin = T|
|00001bd0| 72 61 6e 73 61 63 74 69 | 6f 6e 49 64 47 65 74 43 |ransacti|onIdGetC|
|00001be0| 6f 6d 6d 69 74 54 69 6d | 65 28 68 74 75 70 2d 3e |ommitTim|e(htup->|
|00001bf0| 74 5f 78 6d 69 6e 29 3b | 0a 09 09 20 20 20 20 74 |t_xmin);|... t|
|00001c00| 75 70 63 68 6e 67 20 3d | 20 63 68 61 6e 67 65 64 |upchng =| changed|
|00001c10| 20 3d 20 74 72 75 65 3b | 0a 09 09 7d 0a 09 09 69 | = true;|...}...i|
|00001c20| 66 20 28 68 74 75 70 2d | 3e 74 5f 74 6d 61 78 20 |f (htup-|>t_tmax |
|00001c30| 3d 3d 20 30 20 26 26 20 | 54 72 61 6e 73 61 63 74 |== 0 && |Transact|
|00001c40| 69 6f 6e 49 64 49 73 56 | 61 6c 69 64 28 68 74 75 |ionIdIsV|alid(htu|
|00001c50| 70 2d 3e 74 5f 78 6d 61 | 78 29 0a 09 09 20 20 20 |p->t_xma|x)... |
|00001c60| 20 26 26 20 54 72 61 6e | 73 61 63 74 69 6f 6e 49 | && Tran|sactionI|
|00001c70| 64 44 69 64 43 6f 6d 6d | 69 74 28 68 74 75 70 2d |dDidComm|it(htup-|
|00001c80| 3e 74 5f 78 6d 61 78 29 | 29 20 7b 0a 09 09 20 20 |>t_xmax)|) {... |
|00001c90| 20 20 68 74 75 70 2d 3e | 74 5f 74 6d 61 78 20 3d | htup->|t_tmax =|
|00001ca0| 20 54 72 61 6e 73 61 63 | 74 69 6f 6e 49 64 47 65 | Transac|tionIdGe|
|00001cb0| 74 43 6f 6d 6d 69 74 54 | 69 6d 65 28 68 74 75 70 |tCommitT|ime(htup|
|00001cc0| 2d 3e 74 5f 78 6d 61 78 | 29 3b 0a 09 09 20 20 20 |->t_xmax|);... |
|00001cd0| 20 74 75 70 63 68 6e 67 | 20 3d 20 63 68 61 6e 67 | tupchng| = chang|
|00001ce0| 65 64 20 3d 20 74 72 75 | 65 3b 0a 09 09 7d 0a 09 |ed = tru|e;...}..|
|00001cf0| 09 69 66 20 28 74 75 70 | 63 68 6e 67 29 0a 09 09 |.if (tup|chng)...|
|00001d00| 20 20 20 20 6e 63 68 61 | 6e 67 65 73 2b 2b 3b 0a | ncha|nges++;.|
|00001d10| 09 20 20 20 20 7d 0a 09 | 20 20 20 20 69 66 20 28 |. }..| if (|
|00001d20| 63 68 61 6e 67 65 64 29 | 20 7b 0a 09 09 57 72 69 |changed)| {...Wri|
|00001d30| 74 65 42 75 66 66 65 72 | 28 62 75 66 32 29 3b 0a |teBuffer|(buf2);.|
|00001d40| 09 20 20 20 20 7d 20 65 | 6c 73 65 0a 09 09 52 65 |. } e|lse...Re|
|00001d50| 6c 65 61 73 65 42 75 66 | 66 65 72 28 62 75 66 32 |leaseBuf|fer(buf2|
|00001d60| 29 3b 0a 09 7d 0a 09 68 | 65 61 70 5f 63 6c 6f 73 |);..}..h|eap_clos|
|00001d70| 65 28 6f 6e 65 72 65 6c | 29 3b 0a 20 20 20 20 7d |e(onerel|);. }|
|00001d80| 0a 0a 20 20 20 20 68 65 | 61 70 5f 65 6e 64 73 63 |.. he|ap_endsc|
|00001d90| 61 6e 28 72 65 6c 73 63 | 61 6e 29 3b 0a 20 20 20 |an(relsc|an);. |
|00001da0| 20 68 65 61 70 5f 63 6c | 6f 73 65 28 70 67 72 65 | heap_cl|ose(pgre|
|00001db0| 6c 29 3b 0a 0a 20 20 20 | 20 72 65 74 75 72 6e 20 |l);.. | return |
|00001dc0| 28 6e 63 68 61 6e 67 65 | 73 29 3b 0a 7d 0a 00 00 |(nchange|s);.}...|
|00001dd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001de0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001df0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001e00| 62 65 6e 63 68 2f 64 75 | 73 74 62 75 73 74 65 72 |bench/du|stbuster|
|00001e10| 2e 70 71 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |.pq.....|........|
|00001e20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001e30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001e40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001e50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001e60| 00 00 00 00 20 20 20 34 | 34 34 20 00 20 20 20 20 |.... 4|44 . |
|00001e70| 20 36 20 00 20 20 20 20 | 20 30 20 00 20 20 20 20 | 6 . | 0 . |
|00001e80| 20 20 20 20 31 37 34 20 | 20 35 32 34 37 30 37 33 | 174 | 5247073|
|00001e90| 35 32 37 20 20 31 34 31 | 32 36 00 20 30 00 00 00 |527 141|26. 0...|
|00001ea0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001eb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ec0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ed0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ee0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ef0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001f00| 00 75 73 74 61 72 20 20 | 00 70 6f 73 74 67 72 65 |.ustar |.postgre|
|00001f10| 73 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |s.......|........|
|00001f20| 00 00 00 00 00 00 00 00 | 00 73 79 73 74 65 6d 00 |........|.system.|
|00001f30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001f40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001f50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001f60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001f70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001f80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001f90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001fa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001fb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001fc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001fd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001fe0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ff0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002000| 64 65 66 69 6e 65 20 63 | 20 66 75 6e 63 74 69 6f |define c| functio|
|00002010| 6e 20 64 75 73 74 62 75 | 73 74 65 72 20 28 20 66 |n dustbu|ster ( f|
|00002020| 69 6c 65 20 3d 20 22 2f | 75 73 72 2f 70 6f 73 74 |ile = "/|usr/post|
|00002030| 67 72 65 73 2f 64 75 73 | 74 62 75 73 74 65 72 2f |gres/dus|tbuster/|
|00002040| 64 75 73 74 62 75 73 74 | 65 72 2e 6f 22 2c 20 72 |dustbust|er.o", r|
|00002050| 65 74 75 72 6e 74 79 70 | 65 20 3d 20 69 6e 74 34 |eturntyp|e = int4|
|00002060| 29 0a 72 65 74 72 69 65 | 76 65 20 28 78 3d 64 75 |).retrie|ve (x=du|
|00002070| 73 74 62 75 73 74 65 72 | 28 29 29 0a 00 00 00 00 |stbuster|()).....|
|00002080| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000020a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000020b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000020c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000020d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000020e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000020f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002100| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002110| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002120| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002180| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002190| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000021a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000021b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000021c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000021d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000021e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000021f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002200| 62 65 6e 63 68 2f 6d 61 | 6b 65 66 69 6c 65 2e 64 |bench/ma|kefile.d|
|00002210| 75 73 74 62 00 00 00 00 | 00 00 00 00 00 00 00 00 |ustb....|........|
|00002220| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002230| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002240| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002250| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002260| 00 00 00 00 20 20 20 34 | 34 34 20 00 20 20 20 20 |.... 4|44 . |
|00002270| 20 36 20 00 20 20 20 20 | 20 30 20 00 20 20 20 20 | 6 . | 0 . |
|00002280| 20 20 20 20 34 36 37 20 | 20 35 32 34 37 30 37 33 | 467 | 5247073|
|00002290| 35 32 37 20 20 31 34 32 | 30 35 00 20 30 00 00 00 |527 142|05. 0...|
|000022a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000022b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000022c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000022d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000022e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000022f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002300| 00 75 73 74 61 72 20 20 | 00 70 6f 73 74 67 72 65 |.ustar |.postgre|
|00002310| 73 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |s.......|........|
|00002320| 00 00 00 00 00 00 00 00 | 00 73 79 73 74 65 6d 00 |........|.system.|
|00002330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002340| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002350| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002380| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000023a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000023b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000023c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000023d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000023e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000023f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002400| 54 52 45 45 3d 09 2f 75 | 73 72 2f 70 6f 73 74 67 |TREE=./u|sr/postg|
|00002410| 72 65 73 0a 53 44 3d 09 | 2f 75 73 72 2f 70 6f 73 |res.SD=.|/usr/pos|
|00002420| 74 67 72 65 73 2f 73 72 | 63 0a 4f 44 3d 09 2f 75 |tgres/sr|c.OD=./u|
|00002430| 73 72 2f 70 6f 73 74 67 | 72 65 73 2f 6f 62 6a 2e |sr/postg|res/obj.|
|00002440| 73 70 61 72 63 0a 50 4f | 52 54 4e 41 4d 45 3d 09 |sparc.PO|RTNAME=.|
|00002450| 73 70 61 72 63 0a 0a 50 | 4f 52 54 44 49 52 3d 09 |sparc..P|ORTDIR=.|
|00002460| 70 6f 72 74 2f 73 70 61 | 72 63 0a 50 4f 52 54 4c |port/spa|rc.PORTL|
|00002470| 44 46 4c 41 47 53 3d 0a | 47 43 46 4c 41 47 53 3d |DFLAGS=.|GCFLAGS=|
|00002480| 0a 4c 44 46 4c 41 47 53 | 3d 09 24 28 47 43 46 4c |.LDFLAGS|=.$(GCFL|
|00002490| 41 47 53 29 0a 43 46 4c | 41 47 53 3d 09 09 24 28 |AGS).CFL|AGS=..$(|
|000024a0| 47 43 46 4c 41 47 53 29 | 20 5c 0a 09 09 2d 49 24 |GCFLAGS)| \...-I$|
|000024b0| 28 53 44 29 2f 6c 69 62 | 2f 48 20 5c 0a 09 09 2d |(SD)/lib|/H \...-|
|000024c0| 49 24 28 53 44 29 2f 6c | 69 62 2f 48 2f 6f 62 73 |I$(SD)/l|ib/H/obs|
|000024d0| 6f 6c 65 74 65 20 5c 0a | 09 09 2d 49 24 28 4f 44 |olete \.|..-I$(OD|
|000024e0| 29 2f 6c 69 62 2f 48 20 | 5c 0a 09 09 2d 49 24 28 |)/lib/H |\...-I$(|
|000024f0| 53 44 29 2f 24 28 50 4f | 52 54 44 49 52 29 20 0a |SD)/$(PO|RTDIR) .|
|00002500| 44 49 52 53 3d 09 09 2e | 2f 64 69 72 73 2e 6d 6b |DIRS=...|/dirs.mk|
|00002510| 0a 4c 49 42 53 3d 09 09 | 2d 6c 6c 20 2d 6c 6d 20 |.LIBS=..|-ll -lm |
|00002520| 2d 6c 63 0a 0a 61 6c 6c | 3a 20 64 75 73 74 62 75 |-lc..all|: dustbu|
|00002530| 73 74 65 72 2e 6f 0a 00 | 00 00 00 00 00 00 00 00 |ster.o..|........|
|00002540| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002550| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002560| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002570| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002580| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002590| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000025a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000025b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000025c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000025d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000025e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000025f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002600| 62 65 6e 63 68 2f 70 65 | 72 71 75 65 72 79 00 00 |bench/pe|rquery..|
|00002610| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002620| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002630| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002640| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002650| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002660| 00 00 00 00 20 20 20 35 | 35 35 20 00 20 20 20 20 |.... 5|55 . |
|00002670| 20 36 20 00 20 20 20 20 | 20 30 20 00 20 20 20 20 | 6 . | 0 . |
|00002680| 20 20 20 20 35 37 33 20 | 20 35 32 34 37 30 37 33 | 573 | 5247073|
|00002690| 35 33 30 20 20 31 33 31 | 35 37 00 20 30 00 00 00 |530 131|57. 0...|
|000026a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000026b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000026c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000026d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000026e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000026f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002700| 00 75 73 74 61 72 20 20 | 00 70 6f 73 74 67 72 65 |.ustar |.postgre|
|00002710| 73 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |s.......|........|
|00002720| 00 00 00 00 00 00 00 00 | 00 73 79 73 74 65 6d 00 |........|.system.|
|00002730| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002740| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002750| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002760| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002770| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002780| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002790| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000027a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000027b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000027c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000027d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000027e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000027f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002800| 23 21 2f 62 69 6e 2f 73 | 68 0a 0a 65 67 72 65 70 |#!/bin/s|h..egrep|
|00002810| 20 27 78 20 3d 20 22 7c | 65 6c 61 70 73 65 27 20 | 'x = "||elapse' |
|00002820| 3e 20 2f 74 6d 70 2f 66 | 6f 6f 24 24 0a 0a 61 77 |> /tmp/f|oo$$..aw|
|00002830| 6b 20 27 42 45 47 49 4e | 20 7b 20 78 20 3d 20 30 |k 'BEGIN| { x = 0|
|00002840| 3b 20 79 20 3d 20 30 3b | 20 7a 20 3d 20 30 3b 20 |; y = 0;| z = 0; |
|00002850| 61 20 3d 20 30 3b 20 7d | 20 5c 0a 20 20 20 20 20 |a = 0; }| \. |
|00002860| 2f 2e 2a 65 6c 61 70 73 | 65 2e 2a 2f 20 7b 78 20 |/.*elaps|e.*/ {x |
|00002870| 3d 20 24 32 20 2b 20 78 | 3b 20 79 20 3d 20 24 34 |= $2 + x|; y = $4|
|00002880| 20 2b 20 79 3b 20 7a 20 | 3d 20 24 36 20 2b 20 7a | + y; z |= $6 + z|
|00002890| 3b 7d 20 5c 0a 20 20 20 | 20 20 2f 2e 2a 78 20 3d |;} \. | /.*x =|
|000028a0| 20 22 2e 2a 2f 20 7b 20 | 5c 0a 09 20 70 72 69 6e | ".*/ { |\.. prin|
|000028b0| 74 66 20 22 71 75 65 72 | 79 20 25 32 64 3a 20 25 |tf "quer|y %2d: %|
|000028c0| 37 2e 33 66 20 72 65 61 | 6c 20 25 37 2e 33 66 20 |7.3f rea|l %7.3f |
|000028d0| 75 73 65 72 20 25 37 2e | 33 66 20 73 79 73 5c 6e |user %7.|3f sys\n|
|000028e0| 22 2c 20 61 2c 20 78 2c | 20 79 2c 20 7a 3b 20 5c |", a, x,| y, z; \|
|000028f0| 0a 09 20 78 20 3d 20 30 | 3b 20 79 20 3d 20 30 3b |.. x = 0|; y = 0;|
|00002900| 20 7a 20 3d 20 30 3b 20 | 61 20 3d 20 61 20 2b 20 | z = 0; |a = a + |
|00002910| 31 3b 20 7d 20 5c 0a 20 | 20 20 20 20 45 4e 44 20 |1; } \. | END |
|00002920| 7b 70 72 69 6e 74 66 28 | 22 71 75 65 72 79 20 25 |{printf(|"query %|
|00002930| 32 64 3a 20 25 37 2e 33 | 66 20 72 65 61 6c 20 25 |2d: %7.3|f real %|
|00002940| 37 2e 33 66 20 75 73 65 | 72 20 25 37 2e 33 66 20 |7.3f use|r %7.3f |
|00002950| 73 79 73 5c 6e 22 2c 20 | 61 2c 20 78 2c 20 79 2c |sys\n", |a, x, y,|
|00002960| 20 7a 29 3b 7d 27 20 5c | 0a 09 20 3c 20 2f 74 6d | z);}' \|.. < /tm|
|00002970| 70 2f 66 6f 6f 24 24 0a | 09 20 0a 00 00 00 00 00 |p/foo$$.|. ......|
|00002980| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002990| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000029a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000029b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000029c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000029d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000029e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000029f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002a00| 62 65 6e 63 68 2f 71 75 | 65 72 79 31 00 00 00 00 |bench/qu|ery1....|
|00002a10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002a20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002a30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002a40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002a50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002a60| 00 00 00 00 20 20 20 34 | 34 34 20 00 20 20 20 20 |.... 4|44 . |
|00002a70| 20 36 20 00 20 20 20 20 | 20 30 20 00 20 20 20 20 | 6 . | 0 . |
|00002a80| 20 20 20 20 33 31 34 20 | 20 35 32 34 37 30 37 33 | 314 | 5247073|
|00002a90| 35 33 30 20 20 31 32 35 | 31 37 00 20 30 00 00 00 |530 125|17. 0...|
|00002aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ab0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ac0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ad0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ae0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002af0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002b00| 00 75 73 74 61 72 20 20 | 00 70 6f 73 74 67 72 65 |.ustar |.postgre|
|00002b10| 73 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |s.......|........|
|00002b20| 00 00 00 00 00 00 00 00 | 00 73 79 73 74 65 6d 00 |........|.system.|
|00002b30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002b40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002b50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002b60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002b70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002b80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002b90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ba0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002bb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002bc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002bd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002be0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002bf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002c00| 72 65 74 72 69 65 76 65 | 20 69 6e 74 6f 20 74 65 |retrieve| into te|
|00002c10| 6d 70 20 28 74 2e 61 6c | 6c 29 20 66 72 6f 6d 20 |mp (t.al|l) from |
|00002c20| 74 20 69 6e 20 74 65 6e | 6b 31 20 77 68 65 72 65 |t in ten|k1 where|
|00002c30| 20 28 74 2e 75 6e 69 71 | 75 65 32 20 3e 20 33 30 | (t.uniq|ue2 > 30|
|00002c40| 31 29 20 61 6e 64 20 28 | 74 2e 75 6e 69 71 75 65 |1) and (|t.unique|
|00002c50| 32 20 3c 20 34 30 32 29 | 0a 64 65 73 74 72 6f 79 |2 < 402)|.destroy|
|00002c60| 20 74 65 6d 70 0a 72 65 | 74 72 69 65 76 65 20 69 | temp.re|trieve i|
|00002c70| 6e 74 6f 20 74 65 6d 70 | 20 28 74 2e 61 6c 6c 29 |nto temp| (t.all)|
|00002c80| 20 66 72 6f 6d 20 74 20 | 69 6e 20 74 65 6e 6b 31 | from t |in tenk1|
|00002c90| 20 77 68 65 72 65 20 28 | 74 2e 75 6e 69 71 75 65 | where (|t.unique|
|00002ca0| 32 20 3e 20 33 30 31 29 | 20 61 6e 64 20 28 74 2e |2 > 301)| and (t.|
|00002cb0| 75 6e 69 71 75 65 32 20 | 3c 20 34 30 32 29 0a 64 |unique2 |< 402).d|
|00002cc0| 65 73 74 72 6f 79 20 74 | 65 6d 70 0a 00 00 00 00 |estroy t|emp.....|
|00002cd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ce0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002cf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002d00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002d10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002d20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002d30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002d40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002d50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002d60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002d70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002d80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002d90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002da0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002db0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002dc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002dd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002de0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002df0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002e00| 62 65 6e 63 68 2f 71 75 | 65 72 79 31 30 00 00 00 |bench/qu|ery10...|
|00002e10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002e20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002e30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002e40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002e50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002e60| 00 00 00 00 20 20 20 34 | 34 34 20 00 20 20 20 20 |.... 4|44 . |
|00002e70| 20 36 20 00 20 20 20 20 | 20 30 20 00 20 20 20 20 | 6 . | 0 . |
|00002e80| 20 20 20 31 34 30 36 20 | 20 35 32 34 37 30 37 33 | 1406 | 5247073|
|00002e90| 35 33 30 20 20 31 32 36 | 32 32 00 20 30 00 00 00 |530 126|22. 0...|
|00002ea0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002eb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ec0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ed0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ee0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ef0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f00| 00 75 73 74 61 72 20 20 | 00 70 6f 73 74 67 72 65 |.ustar |.postgre|
|00002f10| 73 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |s.......|........|
|00002f20| 00 00 00 00 00 00 00 00 | 00 73 79 73 74 65 6d 00 |........|.system.|
|00002f30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002fa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002fb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002fc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002fd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002fe0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ff0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003000| 72 65 74 72 69 65 76 65 | 20 69 6e 74 6f 20 74 65 |retrieve| into te|
|00003010| 6d 70 20 28 74 2e 61 6c | 6c 2c 42 75 6e 69 71 75 |mp (t.al|l,Buniqu|
|00003020| 65 31 20 3d 42 2e 75 6e | 69 71 75 65 31 2c 42 75 |e1 =B.un|ique1,Bu|
|00003030| 6e 69 71 75 65 32 3d 42 | 2e 75 6e 69 71 75 65 32 |nique2=B|.unique2|
|00003040| 2c 42 74 77 6f 3d 42 2e | 74 77 6f 2c 42 66 6f 75 |,Btwo=B.|two,Bfou|
|00003050| 72 3d 42 2e 66 6f 75 72 | 2c 42 74 65 6e 3d 42 2e |r=B.four|,Bten=B.|
|00003060| 74 65 6e 2c 42 74 77 65 | 6e 74 79 3d 20 42 2e 74 |ten,Btwe|nty= B.t|
|00003070| 77 65 6e 74 79 2c 20 42 | 68 75 6e 64 72 65 64 3d |wenty, B|hundred=|
|00003080| 42 2e 68 75 6e 64 72 65 | 64 2c 42 74 68 6f 75 73 |B.hundre|d,Bthous|
|00003090| 61 6e 64 3d 42 2e 74 68 | 6f 75 73 61 6e 64 2c 42 |and=B.th|ousand,B|
|000030a0| 74 77 6f 74 68 6f 75 73 | 61 6e 64 3d 42 2e 74 77 |twothous|and=B.tw|
|000030b0| 6f 74 68 6f 75 73 61 6e | 64 2c 42 66 69 76 65 74 |othousan|d,Bfivet|
|000030c0| 68 6f 75 73 3d 42 2e 66 | 69 76 65 74 68 6f 75 73 |hous=B.f|ivethous|
|000030d0| 2c 42 74 65 6e 74 68 6f | 75 73 3d 42 2e 74 65 6e |,Btentho|us=B.ten|
|000030e0| 74 68 6f 75 73 2c 42 6f | 64 64 3d 42 2e 6f 64 64 |thous,Bo|dd=B.odd|
|000030f0| 2c 20 42 65 76 65 6e 3d | 42 2e 65 76 65 6e 2c 42 |, Beven=|B.even,B|
|00003100| 73 74 72 69 6e 67 75 31 | 3d 42 2e 73 74 72 69 6e |stringu1|=B.strin|
|00003110| 67 75 31 2c 42 73 74 72 | 69 6e 67 75 32 3d 42 2e |gu1,Bstr|ingu2=B.|
|00003120| 73 74 72 69 6e 67 75 32 | 2c 42 73 74 72 69 6e 67 |stringu2|,Bstring|
|00003130| 34 3d 42 2e 73 74 72 69 | 6e 67 34 29 20 66 72 6f |4=B.stri|ng4) fro|
|00003140| 6d 20 74 20 69 6e 20 74 | 65 6e 6b 31 2c 20 42 20 |m t in t|enk1, B |
|00003150| 69 6e 20 42 70 72 69 6d | 65 20 77 68 65 72 65 20 |in Bprim|e where |
|00003160| 74 2e 75 6e 69 71 75 65 | 32 20 3d 20 42 2e 75 6e |t.unique|2 = B.un|
|00003170| 69 71 75 65 32 0a 64 65 | 73 74 72 6f 79 20 74 65 |ique2.de|stroy te|
|00003180| 6d 70 0a 72 65 74 72 69 | 65 76 65 20 69 6e 74 6f |mp.retri|eve into|
|00003190| 20 74 65 6d 70 20 28 74 | 2e 61 6c 6c 2c 42 75 6e | temp (t|.all,Bun|
|000031a0| 69 71 75 65 31 20 3d 42 | 2e 75 6e 69 71 75 65 31 |ique1 =B|.unique1|
|000031b0| 2c 42 75 6e 69 71 75 65 | 32 3d 42 2e 75 6e 69 71 |,Bunique|2=B.uniq|
|000031c0| 75 65 32 2c 42 74 77 6f | 3d 42 2e 74 77 6f 2c 42 |ue2,Btwo|=B.two,B|
|000031d0| 66 6f 75 72 3d 42 2e 66 | 6f 75 72 2c 42 74 65 6e |four=B.f|our,Bten|
|000031e0| 3d 42 2e 74 65 6e 2c 42 | 74 77 65 6e 74 79 3d 20 |=B.ten,B|twenty= |
|000031f0| 42 2e 74 77 65 6e 74 79 | 2c 20 42 68 75 6e 64 72 |B.twenty|, Bhundr|
|00003200| 65 64 3d 42 2e 68 75 6e | 64 72 65 64 2c 42 74 68 |ed=B.hun|dred,Bth|
|00003210| 6f 75 73 61 6e 64 3d 42 | 2e 74 68 6f 75 73 61 6e |ousand=B|.thousan|
|00003220| 64 2c 42 74 77 6f 74 68 | 6f 75 73 61 6e 64 3d 42 |d,Btwoth|ousand=B|
|00003230| 2e 74 77 6f 74 68 6f 75 | 73 61 6e 64 2c 42 66 69 |.twothou|sand,Bfi|
|00003240| 76 65 74 68 6f 75 73 3d | 42 2e 66 69 76 65 74 68 |vethous=|B.fiveth|
|00003250| 6f 75 73 2c 42 74 65 6e | 74 68 6f 75 73 3d 42 2e |ous,Bten|thous=B.|
|00003260| 74 65 6e 74 68 6f 75 73 | 2c 42 6f 64 64 3d 42 2e |tenthous|,Bodd=B.|
|00003270| 6f 64 64 2c 20 42 65 76 | 65 6e 3d 42 2e 65 76 65 |odd, Bev|en=B.eve|
|00003280| 6e 2c 42 73 74 72 69 6e | 67 75 31 3d 42 2e 73 74 |n,Bstrin|gu1=B.st|
|00003290| 72 69 6e 67 75 31 2c 42 | 73 74 72 69 6e 67 75 32 |ringu1,B|stringu2|
|000032a0| 3d 42 2e 73 74 72 69 6e | 67 75 32 2c 42 73 74 72 |=B.strin|gu2,Bstr|
|000032b0| 69 6e 67 34 3d 42 2e 73 | 74 72 69 6e 67 34 29 20 |ing4=B.s|tring4) |
|000032c0| 66 72 6f 6d 20 74 20 69 | 6e 20 74 65 6e 6b 31 2c |from t i|n tenk1,|
|000032d0| 20 42 20 69 6e 20 42 70 | 72 69 6d 65 20 77 68 65 | B in Bp|rime whe|
|000032e0| 72 65 20 74 2e 75 6e 69 | 71 75 65 32 20 3d 20 42 |re t.uni|que2 = B|
|000032f0| 2e 75 6e 69 71 75 65 32 | 0a 64 65 73 74 72 6f 79 |.unique2|.destroy|
|00003300| 20 74 65 6d 70 0a 00 00 | 00 00 00 00 00 00 00 00 | temp...|........|
|00003310| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003320| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003340| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003350| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003380| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000033a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000033b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000033c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000033d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000033e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000033f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003400| 62 65 6e 63 68 2f 71 75 | 65 72 79 31 31 00 00 00 |bench/qu|ery11...|
|00003410| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003420| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003430| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003440| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003450| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003460| 00 00 00 00 20 20 20 34 | 34 34 20 00 20 20 20 20 |.... 4|44 . |
|00003470| 20 36 20 00 20 20 20 20 | 20 30 20 00 20 20 20 20 | 6 . | 0 . |
|00003480| 20 20 20 31 37 30 30 20 | 20 35 32 34 37 30 37 33 | 1700 | 5247073|
|00003490| 35 33 30 20 20 31 32 36 | 32 30 00 20 30 00 00 00 |530 126|20. 0...|
|000034a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000034b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000034c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000034d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000034e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000034f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003500| 00 75 73 74 61 72 20 20 | 00 70 6f 73 74 67 72 65 |.ustar |.postgre|
|00003510| 73 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |s.......|........|
|00003520| 00 00 00 00 00 00 00 00 | 00 73 79 73 74 65 6d 00 |........|.system.|
|00003530| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003540| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003550| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003560| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003570| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003580| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003590| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000035a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000035b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000035c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000035d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000035e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000035f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003600| 72 65 74 72 69 65 76 65 | 20 69 6e 74 6f 20 74 65 |retrieve| into te|
|00003610| 6d 70 20 28 74 31 2e 61 | 6c 6c 2c 6f 75 6e 69 71 |mp (t1.a|ll,ouniq|
|00003620| 75 65 31 3d 6f 2e 75 6e | 69 71 75 65 31 2c 6f 75 |ue1=o.un|ique1,ou|
|00003630| 6e 69 71 75 65 32 3d 6f | 2e 75 6e 69 71 75 65 32 |nique2=o|.unique2|
|00003640| 2c 6f 74 77 6f 3d 6f 2e | 74 77 6f 2c 6f 66 6f 75 |,otwo=o.|two,ofou|
|00003650| 72 3d 6f 2e 66 6f 75 72 | 2c 6f 74 65 6e 3d 6f 2e |r=o.four|,oten=o.|
|00003660| 74 65 6e 2c 6f 74 77 65 | 6e 74 79 3d 20 6f 2e 74 |ten,otwe|nty= o.t|
|00003670| 77 65 6e 74 79 2c 20 6f | 68 75 6e 64 72 65 64 3d |wenty, o|hundred=|
|00003680| 6f 2e 68 75 6e 64 72 65 | 64 2c 6f 74 68 6f 75 73 |o.hundre|d,othous|
|00003690| 61 6e 64 3d 6f 2e 74 68 | 6f 75 73 61 6e 64 2c 6f |and=o.th|ousand,o|
|000036a0| 74 77 6f 74 68 6f 75 73 | 61 6e 64 3d 6f 2e 74 77 |twothous|and=o.tw|
|000036b0| 6f 74 68 6f 75 73 61 6e | 64 2c 6f 66 69 76 65 74 |othousan|d,ofivet|
|000036c0| 68 6f 75 73 3d 6f 2e 66 | 69 76 65 74 68 6f 75 73 |hous=o.f|ivethous|
|000036d0| 2c 6f 74 65 6e 74 68 6f | 75 73 3d 6f 2e 74 65 6e |,otentho|us=o.ten|
|000036e0| 74 68 6f 75 73 2c 6f 6f | 64 64 3d 6f 2e 6f 64 64 |thous,oo|dd=o.odd|
|000036f0| 2c 20 6f 65 76 65 6e 3d | 6f 2e 65 76 65 6e 2c 6f |, oeven=|o.even,o|
|00003700| 73 74 72 69 6e 67 75 31 | 3d 6f 2e 73 74 72 69 6e |stringu1|=o.strin|
|00003710| 67 75 31 2c 6f 73 74 72 | 69 6e 67 75 32 3d 6f 2e |gu1,ostr|ingu2=o.|
|00003720| 73 74 72 69 6e 67 75 32 | 2c 6f 73 74 72 69 6e 67 |stringu2|,ostring|
|00003730| 34 3d 6f 2e 73 74 72 69 | 6e 67 34 29 20 66 72 6f |4=o.stri|ng4) fro|
|00003740| 6d 20 6f 20 69 6e 20 6f | 6e 65 6b 2c 20 74 31 20 |m o in o|nek, t1 |
|00003750| 69 6e 20 74 65 6e 6b 31 | 2c 20 74 32 20 69 6e 20 |in tenk1|, t2 in |
|00003760| 74 65 6e 6b 32 20 77 68 | 65 72 65 20 28 6f 2e 75 |tenk2 wh|ere (o.u|
|00003770| 6e 69 71 75 65 32 20 3d | 20 74 31 2e 75 6e 69 71 |nique2 =| t1.uniq|
|00003780| 75 65 32 29 20 61 6e 64 | 20 28 74 31 2e 75 6e 69 |ue2) and| (t1.uni|
|00003790| 71 75 65 32 20 3d 20 74 | 32 2e 75 6e 69 71 75 65 |que2 = t|2.unique|
|000037a0| 32 29 20 61 6e 64 20 28 | 74 31 2e 75 6e 69 71 75 |2) and (|t1.uniqu|
|000037b0| 65 32 20 3c 20 31 30 30 | 30 29 20 61 6e 64 20 28 |e2 < 100|0) and (|
|000037c0| 74 32 2e 75 6e 69 71 75 | 65 32 20 3c 20 31 30 30 |t2.uniqu|e2 < 100|
|000037d0| 30 29 0a 64 65 73 74 72 | 6f 79 20 74 65 6d 70 0a |0).destr|oy temp.|
|000037e0| 72 65 74 72 69 65 76 65 | 20 69 6e 74 6f 20 74 65 |retrieve| into te|
|000037f0| 6d 70 20 28 74 31 2e 61 | 6c 6c 2c 6f 75 6e 69 71 |mp (t1.a|ll,ouniq|
|00003800| 75 65 31 3d 6f 2e 75 6e | 69 71 75 65 31 2c 6f 75 |ue1=o.un|ique1,ou|
|00003810| 6e 69 71 75 65 32 3d 6f | 2e 75 6e 69 71 75 65 32 |nique2=o|.unique2|
|00003820| 2c 6f 74 77 6f 3d 6f 2e | 74 77 6f 2c 6f 66 6f 75 |,otwo=o.|two,ofou|
|00003830| 72 3d 6f 2e 66 6f 75 72 | 2c 6f 74 65 6e 3d 6f 2e |r=o.four|,oten=o.|
|00003840| 74 65 6e 2c 6f 74 77 65 | 6e 74 79 3d 20 6f 2e 74 |ten,otwe|nty= o.t|
|00003850| 77 65 6e 74 79 2c 20 6f | 68 75 6e 64 72 65 64 3d |wenty, o|hundred=|
|00003860| 6f 2e 68 75 6e 64 72 65 | 64 2c 6f 74 68 6f 75 73 |o.hundre|d,othous|
|00003870| 61 6e 64 3d 6f 2e 74 68 | 6f 75 73 61 6e 64 2c 6f |and=o.th|ousand,o|
|00003880| 74 77 6f 74 68 6f 75 73 | 61 6e 64 3d 6f 2e 74 77 |twothous|and=o.tw|
|00003890| 6f 74 68 6f 75 73 61 6e | 64 2c 6f 66 69 76 65 74 |othousan|d,ofivet|
|000038a0| 68 6f 75 73 3d 6f 2e 66 | 69 76 65 74 68 6f 75 73 |hous=o.f|ivethous|
|000038b0| 2c 6f 74 65 6e 74 68 6f | 75 73 3d 6f 2e 74 65 6e |,otentho|us=o.ten|
|000038c0| 74 68 6f 75 73 2c 6f 6f | 64 64 3d 6f 2e 6f 64 64 |thous,oo|dd=o.odd|
|000038d0| 2c 20 6f 65 76 65 6e 3d | 6f 2e 65 76 65 6e 2c 6f |, oeven=|o.even,o|
|000038e0| 73 74 72 69 6e 67 75 31 | 3d 6f 2e 73 74 72 69 6e |stringu1|=o.strin|
|000038f0| 67 75 31 2c 6f 73 74 72 | 69 6e 67 75 32 3d 6f 2e |gu1,ostr|ingu2=o.|
|00003900| 73 74 72 69 6e 67 75 32 | 2c 6f 73 74 72 69 6e 67 |stringu2|,ostring|
|00003910| 34 3d 6f 2e 73 74 72 69 | 6e 67 34 29 20 66 72 6f |4=o.stri|ng4) fro|
|00003920| 6d 20 6f 20 69 6e 20 6f | 6e 65 6b 2c 20 74 31 20 |m o in o|nek, t1 |
|00003930| 69 6e 20 74 65 6e 6b 31 | 2c 20 74 32 20 69 6e 20 |in tenk1|, t2 in |
|00003940| 74 65 6e 6b 32 20 77 68 | 65 72 65 20 28 6f 2e 75 |tenk2 wh|ere (o.u|
|00003950| 6e 69 71 75 65 32 20 3d | 20 74 31 2e 75 6e 69 71 |nique2 =| t1.uniq|
|00003960| 75 65 32 29 20 61 6e 64 | 20 28 74 31 2e 75 6e 69 |ue2) and| (t1.uni|
|00003970| 71 75 65 32 20 3d 20 74 | 32 2e 75 6e 69 71 75 65 |que2 = t|2.unique|
|00003980| 32 29 20 61 6e 64 20 28 | 74 31 2e 75 6e 69 71 75 |2) and (|t1.uniqu|
|00003990| 65 32 20 3c 20 31 30 30 | 30 29 20 61 6e 64 20 28 |e2 < 100|0) and (|
|000039a0| 74 32 2e 75 6e 69 71 75 | 65 32 20 3c 20 31 30 30 |t2.uniqu|e2 < 100|
|000039b0| 30 29 0a 64 65 73 74 72 | 6f 79 20 74 65 6d 70 0a |0).destr|oy temp.|
|000039c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000039d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000039e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000039f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a00| 62 65 6e 63 68 2f 71 75 | 65 72 79 31 32 00 00 00 |bench/qu|ery12...|
|00003a10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a60| 00 00 00 00 20 20 20 34 | 34 34 20 00 20 20 20 20 |.... 4|44 . |
|00003a70| 20 36 20 00 20 20 20 20 | 20 30 20 00 20 20 20 20 | 6 . | 0 . |
|00003a80| 20 20 20 31 36 35 32 20 | 20 35 32 34 37 30 37 33 | 1652 | 5247073|
|00003a90| 35 33 30 20 20 31 32 36 | 32 37 00 20 30 00 00 00 |530 126|27. 0...|
|00003aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ab0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ac0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ad0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ae0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003af0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b00| 00 75 73 74 61 72 20 20 | 00 70 6f 73 74 67 72 65 |.ustar |.postgre|
|00003b10| 73 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |s.......|........|
|00003b20| 00 00 00 00 00 00 00 00 | 00 73 79 73 74 65 6d 00 |........|.system.|
|00003b30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ba0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003bb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003bc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003bd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003be0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003bf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003c00| 72 65 74 72 69 65 76 65 | 20 69 6e 74 6f 20 74 65 |retrieve| into te|
|00003c10| 6d 70 20 28 74 31 2e 61 | 6c 6c 2c 74 32 75 6e 69 |mp (t1.a|ll,t2uni|
|00003c20| 71 75 65 31 3d 74 32 2e | 75 6e 69 71 75 65 31 2c |que1=t2.|unique1,|
|00003c30| 20 74 32 75 6e 69 71 75 | 65 32 3d 74 32 2e 75 6e | t2uniqu|e2=t2.un|
|00003c40| 69 71 75 65 32 2c 20 74 | 32 74 77 6f 3d 74 32 2e |ique2, t|2two=t2.|
|00003c50| 74 77 6f 2c 20 74 32 66 | 6f 75 72 3d 74 32 2e 66 |two, t2f|our=t2.f|
|00003c60| 6f 75 72 2c 20 74 32 74 | 65 6e 3d 74 32 2e 74 65 |our, t2t|en=t2.te|
|00003c70| 6e 2c 20 74 32 74 77 65 | 6e 74 79 3d 20 74 32 2e |n, t2twe|nty= t2.|
|00003c80| 74 77 65 6e 74 79 2c 20 | 74 32 68 75 6e 64 72 65 |twenty, |t2hundre|
|00003c90| 64 3d 74 32 2e 68 75 6e | 64 72 65 64 2c 20 74 32 |d=t2.hun|dred, t2|
|00003ca0| 74 68 6f 75 73 61 6e 64 | 3d 20 74 32 2e 74 68 6f |thousand|= t2.tho|
|00003cb0| 75 73 61 6e 64 2c 74 32 | 74 77 6f 74 68 6f 75 73 |usand,t2|twothous|
|00003cc0| 61 6e 64 3d 20 74 32 2e | 74 77 6f 74 68 6f 75 73 |and= t2.|twothous|
|00003cd0| 61 6e 64 2c 20 74 32 66 | 69 76 65 74 68 6f 75 73 |and, t2f|ivethous|
|00003ce0| 3d 20 74 32 2e 66 69 76 | 65 74 68 6f 75 73 2c 20 |= t2.fiv|ethous, |
|00003cf0| 74 32 74 65 6e 74 68 6f | 75 73 3d 20 74 32 2e 74 |t2tentho|us= t2.t|
|00003d00| 65 6e 74 68 6f 75 73 2c | 20 74 32 6f 64 64 3d 20 |enthous,| t2odd= |
|00003d10| 74 32 2e 6f 64 64 2c 20 | 74 32 65 76 65 6e 3d 20 |t2.odd, |t2even= |
|00003d20| 74 32 2e 65 76 65 6e 2c | 20 74 32 73 74 72 69 6e |t2.even,| t2strin|
|00003d30| 67 75 31 3d 20 74 32 2e | 73 74 72 69 6e 67 75 31 |gu1= t2.|stringu1|
|00003d40| 2c 20 74 32 73 74 72 69 | 6e 67 75 32 3d 20 74 32 |, t2stri|ngu2= t2|
|00003d50| 2e 73 74 72 69 6e 67 75 | 32 2c 20 74 32 73 74 72 |.stringu|2, t2str|
|00003d60| 69 6e 67 34 3d 20 74 32 | 2e 73 74 72 69 6e 67 34 |ing4= t2|.string4|
|00003d70| 29 20 66 72 6f 6d 20 74 | 31 20 69 6e 20 74 65 6e |) from t|1 in ten|
|00003d80| 6b 31 2c 20 74 32 20 69 | 6e 20 74 65 6e 6b 32 20 |k1, t2 i|n tenk2 |
|00003d90| 77 68 65 72 65 20 28 74 | 31 2e 75 6e 69 71 75 65 |where (t|1.unique|
|00003da0| 32 20 3d 20 74 32 2e 75 | 6e 69 71 75 65 32 29 20 |2 = t2.u|nique2) |
|00003db0| 61 6e 64 20 28 74 32 2e | 75 6e 69 71 75 65 32 20 |and (t2.|unique2 |
|00003dc0| 3c 20 31 30 30 30 29 0a | 64 65 73 74 72 6f 79 20 |< 1000).|destroy |
|00003dd0| 74 65 6d 70 0a 72 65 74 | 72 69 65 76 65 20 69 6e |temp.ret|rieve in|
|00003de0| 74 6f 20 74 65 6d 70 20 | 28 74 31 2e 61 6c 6c 2c |to temp |(t1.all,|
|00003df0| 74 32 75 6e 69 71 75 65 | 31 3d 74 32 2e 75 6e 69 |t2unique|1=t2.uni|
|00003e00| 71 75 65 31 2c 20 74 32 | 75 6e 69 71 75 65 32 3d |que1, t2|unique2=|
|00003e10| 74 32 2e 75 6e 69 71 75 | 65 32 2c 20 74 32 74 77 |t2.uniqu|e2, t2tw|
|00003e20| 6f 3d 74 32 2e 74 77 6f | 2c 20 74 32 66 6f 75 72 |o=t2.two|, t2four|
|00003e30| 3d 74 32 2e 66 6f 75 72 | 2c 20 74 32 74 65 6e 3d |=t2.four|, t2ten=|
|00003e40| 74 32 2e 74 65 6e 2c 20 | 74 32 74 77 65 6e 74 79 |t2.ten, |t2twenty|
|00003e50| 3d 20 74 32 2e 74 77 65 | 6e 74 79 2c 20 74 32 68 |= t2.twe|nty, t2h|
|00003e60| 75 6e 64 72 65 64 3d 74 | 32 2e 68 75 6e 64 72 65 |undred=t|2.hundre|
|00003e70| 64 2c 20 74 32 74 68 6f | 75 73 61 6e 64 3d 20 74 |d, t2tho|usand= t|
|00003e80| 32 2e 74 68 6f 75 73 61 | 6e 64 2c 74 32 74 77 6f |2.thousa|nd,t2two|
|00003e90| 74 68 6f 75 73 61 6e 64 | 3d 20 74 32 2e 74 77 6f |thousand|= t2.two|
|00003ea0| 74 68 6f 75 73 61 6e 64 | 2c 20 74 32 66 69 76 65 |thousand|, t2five|
|00003eb0| 74 68 6f 75 73 3d 20 74 | 32 2e 66 69 76 65 74 68 |thous= t|2.fiveth|
|00003ec0| 6f 75 73 2c 20 74 32 74 | 65 6e 74 68 6f 75 73 3d |ous, t2t|enthous=|
|00003ed0| 20 74 32 2e 74 65 6e 74 | 68 6f 75 73 2c 20 74 32 | t2.tent|hous, t2|
|00003ee0| 6f 64 64 3d 20 74 32 2e | 6f 64 64 2c 20 74 32 65 |odd= t2.|odd, t2e|
|00003ef0| 76 65 6e 3d 20 74 32 2e | 65 76 65 6e 2c 20 74 32 |ven= t2.|even, t2|
|00003f00| 73 74 72 69 6e 67 75 31 | 3d 20 74 32 2e 73 74 72 |stringu1|= t2.str|
|00003f10| 69 6e 67 75 31 2c 20 74 | 32 73 74 72 69 6e 67 75 |ingu1, t|2stringu|
|00003f20| 32 3d 20 74 32 2e 73 74 | 72 69 6e 67 75 32 2c 20 |2= t2.st|ringu2, |
|00003f30| 74 32 73 74 72 69 6e 67 | 34 3d 20 74 32 2e 73 74 |t2string|4= t2.st|
|00003f40| 72 69 6e 67 34 29 20 66 | 72 6f 6d 20 74 31 20 69 |ring4) f|rom t1 i|
|00003f50| 6e 20 74 65 6e 6b 31 2c | 20 74 32 20 69 6e 20 74 |n tenk1,| t2 in t|
|00003f60| 65 6e 6b 32 20 77 68 65 | 72 65 20 28 74 31 2e 75 |enk2 whe|re (t1.u|
|00003f70| 6e 69 71 75 65 32 20 3d | 20 74 32 2e 75 6e 69 71 |nique2 =| t2.uniq|
|00003f80| 75 65 32 29 20 61 6e 64 | 20 28 74 32 2e 75 6e 69 |ue2) and| (t2.uni|
|00003f90| 71 75 65 32 20 3c 20 31 | 30 30 30 29 0a 64 65 73 |que2 < 1|000).des|
|00003fa0| 74 72 6f 79 20 74 65 6d | 70 0a 00 00 00 00 00 00 |troy tem|p.......|
|00003fb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003fc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003fd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003fe0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ff0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004000| 62 65 6e 63 68 2f 71 75 | 65 72 79 31 33 00 00 00 |bench/qu|ery13...|
|00004010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004060| 00 00 00 00 20 20 20 34 | 34 34 20 00 20 20 20 20 |.... 4|44 . |
|00004070| 20 36 20 00 20 20 20 20 | 20 30 20 00 20 20 20 20 | 6 . | 0 . |
|00004080| 20 20 20 31 34 30 34 20 | 20 35 32 34 37 30 37 33 | 1404 | 5247073|
|00004090| 35 33 30 20 20 31 32 36 | 32 33 00 20 30 00 00 00 |530 126|23. 0...|
|000040a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000040b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000040c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000040d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000040e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000040f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004100| 00 75 73 74 61 72 20 20 | 00 70 6f 73 74 67 72 65 |.ustar |.postgre|
|00004110| 73 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |s.......|........|
|00004120| 00 00 00 00 00 00 00 00 | 00 73 79 73 74 65 6d 00 |........|.system.|
|00004130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004180| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004190| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000041a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000041b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000041c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000041d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000041e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000041f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004200| 72 65 74 72 69 65 76 65 | 20 69 6e 74 6f 20 74 65 |retrieve| into te|
|00004210| 6d 70 20 28 74 2e 61 6c | 6c 2c 42 75 6e 69 71 75 |mp (t.al|l,Buniqu|
|00004220| 65 31 3d 42 2e 75 6e 69 | 71 75 65 31 2c 42 75 6e |e1=B.uni|que1,Bun|
|00004230| 69 71 75 65 32 3d 42 2e | 75 6e 69 71 75 65 32 2c |ique2=B.|unique2,|
|00004240| 42 74 77 6f 3d 42 2e 74 | 77 6f 2c 42 66 6f 75 72 |Btwo=B.t|wo,Bfour|
|00004250| 3d 42 2e 66 6f 75 72 2c | 42 74 65 6e 3d 42 2e 74 |=B.four,|Bten=B.t|
|00004260| 65 6e 2c 42 74 77 65 6e | 74 79 3d 20 42 2e 74 77 |en,Btwen|ty= B.tw|
|00004270| 65 6e 74 79 2c 20 42 68 | 75 6e 64 72 65 64 3d 42 |enty, Bh|undred=B|
|00004280| 2e 68 75 6e 64 72 65 64 | 2c 42 74 68 6f 75 73 61 |.hundred|,Bthousa|
|00004290| 6e 64 3d 42 2e 74 68 6f | 75 73 61 6e 64 2c 42 74 |nd=B.tho|usand,Bt|
|000042a0| 77 6f 74 68 6f 75 73 61 | 6e 64 3d 42 2e 74 77 6f |wothousa|nd=B.two|
|000042b0| 74 68 6f 75 73 61 6e 64 | 2c 42 66 69 76 65 74 68 |thousand|,Bfiveth|
|000042c0| 6f 75 73 3d 42 2e 66 69 | 76 65 74 68 6f 75 73 2c |ous=B.fi|vethous,|
|000042d0| 42 74 65 6e 74 68 6f 75 | 73 3d 42 2e 74 65 6e 74 |Btenthou|s=B.tent|
|000042e0| 68 6f 75 73 2c 42 6f 64 | 64 3d 42 2e 6f 64 64 2c |hous,Bod|d=B.odd,|
|000042f0| 20 42 65 76 65 6e 3d 42 | 2e 65 76 65 6e 2c 42 73 | Beven=B|.even,Bs|
|00004300| 74 72 69 6e 67 75 31 3d | 42 2e 73 74 72 69 6e 67 |tringu1=|B.string|
|00004310| 75 31 2c 42 73 74 72 69 | 6e 67 75 32 3d 42 2e 73 |u1,Bstri|ngu2=B.s|
|00004320| 74 72 69 6e 67 75 32 2c | 42 73 74 72 69 6e 67 34 |tringu2,|Bstring4|
|00004330| 3d 42 2e 73 74 72 69 6e | 67 34 29 20 66 72 6f 6d |=B.strin|g4) from|
|00004340| 20 74 20 69 6e 20 74 65 | 6e 6b 31 2c 20 42 20 69 | t in te|nk1, B i|
|00004350| 6e 20 42 70 72 69 6d 65 | 20 77 68 65 72 65 20 74 |n Bprime| where t|
|00004360| 2e 75 6e 69 71 75 65 32 | 20 3d 20 42 2e 75 6e 69 |.unique2| = B.uni|
|00004370| 71 75 65 32 0a 64 65 73 | 74 72 6f 79 20 74 65 6d |que2.des|troy tem|
|00004380| 70 0a 72 65 74 72 69 65 | 76 65 20 69 6e 74 6f 20 |p.retrie|ve into |
|00004390| 74 65 6d 70 20 28 74 2e | 61 6c 6c 2c 42 75 6e 69 |temp (t.|all,Buni|
|000043a0| 71 75 65 31 3d 42 2e 75 | 6e 69 71 75 65 31 2c 42 |que1=B.u|nique1,B|
|000043b0| 75 6e 69 71 75 65 32 3d | 42 2e 75 6e 69 71 75 65 |unique2=|B.unique|
|000043c0| 32 2c 42 74 77 6f 3d 42 | 2e 74 77 6f 2c 42 66 6f |2,Btwo=B|.two,Bfo|
|000043d0| 75 72 3d 42 2e 66 6f 75 | 72 2c 42 74 65 6e 3d 42 |ur=B.fou|r,Bten=B|
|000043e0| 2e 74 65 6e 2c 42 74 77 | 65 6e 74 79 3d 20 42 2e |.ten,Btw|enty= B.|
|000043f0| 74 77 65 6e 74 79 2c 20 | 42 68 75 6e 64 72 65 64 |twenty, |Bhundred|
|00004400| 3d 42 2e 68 75 6e 64 72 | 65 64 2c 42 74 68 6f 75 |=B.hundr|ed,Bthou|
|00004410| 73 61 6e 64 3d 42 2e 74 | 68 6f 75 73 61 6e 64 2c |sand=B.t|housand,|
|00004420| 42 74 77 6f 74 68 6f 75 | 73 61 6e 64 3d 42 2e 74 |Btwothou|sand=B.t|
|00004430| 77 6f 74 68 6f 75 73 61 | 6e 64 2c 42 66 69 76 65 |wothousa|nd,Bfive|
|00004440| 74 68 6f 75 73 3d 42 2e | 66 69 76 65 74 68 6f 75 |thous=B.|fivethou|
|00004450| 73 2c 42 74 65 6e 74 68 | 6f 75 73 3d 42 2e 74 65 |s,Btenth|ous=B.te|
|00004460| 6e 74 68 6f 75 73 2c 42 | 6f 64 64 3d 42 2e 6f 64 |nthous,B|odd=B.od|
|00004470| 64 2c 20 42 65 76 65 6e | 3d 42 2e 65 76 65 6e 2c |d, Beven|=B.even,|
|00004480| 42 73 74 72 69 6e 67 75 | 31 3d 42 2e 73 74 72 69 |Bstringu|1=B.stri|
|00004490| 6e 67 75 31 2c 42 73 74 | 72 69 6e 67 75 32 3d 42 |ngu1,Bst|ringu2=B|
|000044a0| 2e 73 74 72 69 6e 67 75 | 32 2c 42 73 74 72 69 6e |.stringu|2,Bstrin|
|000044b0| 67 34 3d 42 2e 73 74 72 | 69 6e 67 34 29 20 66 72 |g4=B.str|ing4) fr|
|000044c0| 6f 6d 20 74 20 69 6e 20 | 74 65 6e 6b 31 2c 20 42 |om t in |tenk1, B|
|000044d0| 20 69 6e 20 42 70 72 69 | 6d 65 20 77 68 65 72 65 | in Bpri|me where|
|000044e0| 20 74 2e 75 6e 69 71 75 | 65 32 20 3d 20 42 2e 75 | t.uniqu|e2 = B.u|
|000044f0| 6e 69 71 75 65 32 0a 64 | 65 73 74 72 6f 79 20 74 |nique2.d|estroy t|
|00004500| 65 6d 70 0a 00 00 00 00 | 00 00 00 00 00 00 00 00 |emp.....|........|
|00004510| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004520| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004530| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004540| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004550| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004560| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004570| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004580| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004590| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000045a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000045b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000045c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000045d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000045e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000045f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004600| 62 65 6e 63 68 2f 71 75 | 65 72 79 31 34 00 00 00 |bench/qu|ery14...|
|00004610| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004620| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004630| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004640| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004650| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004660| 00 00 00 00 20 20 20 34 | 34 34 20 00 20 20 20 20 |.... 4|44 . |
|00004670| 20 36 20 00 20 20 20 20 | 20 30 20 00 20 20 20 20 | 6 . | 0 . |
|00004680| 20 20 20 31 37 30 30 20 | 20 35 32 34 37 30 37 33 | 1700 | 5247073|
|00004690| 35 33 30 20 20 31 32 36 | 32 33 00 20 30 00 00 00 |530 126|23. 0...|
|000046a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000046b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000046c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000046d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000046e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000046f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004700| 00 75 73 74 61 72 20 20 | 00 70 6f 73 74 67 72 65 |.ustar |.postgre|
|00004710| 73 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |s.......|........|
|00004720| 00 00 00 00 00 00 00 00 | 00 73 79 73 74 65 6d 00 |........|.system.|
|00004730| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004740| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004750| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004760| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004770| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004780| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004790| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000047a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000047b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000047c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000047d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000047e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000047f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004800| 72 65 74 72 69 65 76 65 | 20 69 6e 74 6f 20 74 65 |retrieve| into te|
|00004810| 6d 70 20 28 74 31 2e 61 | 6c 6c 2c 6f 75 6e 69 71 |mp (t1.a|ll,ouniq|
|00004820| 75 65 31 3d 6f 2e 75 6e | 69 71 75 65 31 2c 6f 75 |ue1=o.un|ique1,ou|
|00004830| 6e 69 71 75 65 32 3d 6f | 2e 75 6e 69 71 75 65 32 |nique2=o|.unique2|
|00004840| 2c 6f 74 77 6f 3d 6f 2e | 74 77 6f 2c 6f 66 6f 75 |,otwo=o.|two,ofou|
|00004850| 72 3d 6f 2e 66 6f 75 72 | 2c 6f 74 65 6e 3d 6f 2e |r=o.four|,oten=o.|
|00004860| 74 65 6e 2c 6f 74 77 65 | 6e 74 79 3d 20 6f 2e 74 |ten,otwe|nty= o.t|
|00004870| 77 65 6e 74 79 2c 20 6f | 68 75 6e 64 72 65 64 3d |wenty, o|hundred=|
|00004880| 6f 2e 68 75 6e 64 72 65 | 64 2c 6f 74 68 6f 75 73 |o.hundre|d,othous|
|00004890| 61 6e 64 3d 6f 2e 74 68 | 6f 75 73 61 6e 64 2c 6f |and=o.th|ousand,o|
|000048a0| 74 77 6f 74 68 6f 75 73 | 61 6e 64 3d 6f 2e 74 77 |twothous|and=o.tw|
|000048b0| 6f 74 68 6f 75 73 61 6e | 64 2c 6f 66 69 76 65 74 |othousan|d,ofivet|
|000048c0| 68 6f 75 73 3d 6f 2e 66 | 69 76 65 74 68 6f 75 73 |hous=o.f|ivethous|
|000048d0| 2c 6f 74 65 6e 74 68 6f | 75 73 3d 6f 2e 74 65 6e |,otentho|us=o.ten|
|000048e0| 74 68 6f 75 73 2c 6f 6f | 64 64 3d 6f 2e 6f 64 64 |thous,oo|dd=o.odd|
|000048f0| 2c 20 6f 65 76 65 6e 3d | 6f 2e 65 76 65 6e 2c 6f |, oeven=|o.even,o|
|00004900| 73 74 72 69 6e 67 75 31 | 3d 6f 2e 73 74 72 69 6e |stringu1|=o.strin|
|00004910| 67 75 31 2c 6f 73 74 72 | 69 6e 67 75 32 3d 6f 2e |gu1,ostr|ingu2=o.|
|00004920| 73 74 72 69 6e 67 75 32 | 2c 6f 73 74 72 69 6e 67 |stringu2|,ostring|
|00004930| 34 3d 6f 2e 73 74 72 69 | 6e 67 34 29 20 66 72 6f |4=o.stri|ng4) fro|
|00004940| 6d 20 6f 20 69 6e 20 6f | 6e 65 6b 2c 20 74 31 20 |m o in o|nek, t1 |
|00004950| 69 6e 20 74 65 6e 6b 31 | 2c 20 74 32 20 69 6e 20 |in tenk1|, t2 in |
|00004960| 74 65 6e 6b 32 20 77 68 | 65 72 65 20 28 6f 2e 75 |tenk2 wh|ere (o.u|
|00004970| 6e 69 71 75 65 32 20 3d | 20 74 31 2e 75 6e 69 71 |nique2 =| t1.uniq|
|00004980| 75 65 32 29 20 61 6e 64 | 20 28 74 31 2e 75 6e 69 |ue2) and| (t1.uni|
|00004990| 71 75 65 32 20 3d 20 74 | 32 2e 75 6e 69 71 75 65 |que2 = t|2.unique|
|000049a0| 32 29 20 61 6e 64 20 28 | 74 31 2e 75 6e 69 71 75 |2) and (|t1.uniqu|
|000049b0| 65 32 20 3c 20 31 30 30 | 30 29 20 61 6e 64 20 28 |e2 < 100|0) and (|
|000049c0| 74 32 2e 75 6e 69 71 75 | 65 32 20 3c 20 31 30 30 |t2.uniqu|e2 < 100|
|000049d0| 30 29 0a 64 65 73 74 72 | 6f 79 20 74 65 6d 70 0a |0).destr|oy temp.|
|000049e0| 72 65 74 72 69 65 76 65 | 20 69 6e 74 6f 20 74 65 |retrieve| into te|
|000049f0| 6d 70 20 28 74 31 2e 61 | 6c 6c 2c 6f 75 6e 69 71 |mp (t1.a|ll,ouniq|
|00004a00| 75 65 31 3d 6f 2e 75 6e | 69 71 75 65 31 2c 6f 75 |ue1=o.un|ique1,ou|
|00004a10| 6e 69 71 75 65 32 3d 6f | 2e 75 6e 69 71 75 65 32 |nique2=o|.unique2|
|00004a20| 2c 6f 74 77 6f 3d 6f 2e | 74 77 6f 2c 6f 66 6f 75 |,otwo=o.|two,ofou|
|00004a30| 72 3d 6f 2e 66 6f 75 72 | 2c 6f 74 65 6e 3d 6f 2e |r=o.four|,oten=o.|
|00004a40| 74 65 6e 2c 6f 74 77 65 | 6e 74 79 3d 20 6f 2e 74 |ten,otwe|nty= o.t|
|00004a50| 77 65 6e 74 79 2c 20 6f | 68 75 6e 64 72 65 64 3d |wenty, o|hundred=|
|00004a60| 6f 2e 68 75 6e 64 72 65 | 64 2c 6f 74 68 6f 75 73 |o.hundre|d,othous|
|00004a70| 61 6e 64 3d 6f 2e 74 68 | 6f 75 73 61 6e 64 2c 6f |and=o.th|ousand,o|
|00004a80| 74 77 6f 74 68 6f 75 73 | 61 6e 64 3d 6f 2e 74 77 |twothous|and=o.tw|
|00004a90| 6f 74 68 6f 75 73 61 6e | 64 2c 6f 66 69 76 65 74 |othousan|d,ofivet|
|00004aa0| 68 6f 75 73 3d 6f 2e 66 | 69 76 65 74 68 6f 75 73 |hous=o.f|ivethous|
|00004ab0| 2c 6f 74 65 6e 74 68 6f | 75 73 3d 6f 2e 74 65 6e |,otentho|us=o.ten|
|00004ac0| 74 68 6f 75 73 2c 6f 6f | 64 64 3d 6f 2e 6f 64 64 |thous,oo|dd=o.odd|
|00004ad0| 2c 20 6f 65 76 65 6e 3d | 6f 2e 65 76 65 6e 2c 6f |, oeven=|o.even,o|
|00004ae0| 73 74 72 69 6e 67 75 31 | 3d 6f 2e 73 74 72 69 6e |stringu1|=o.strin|
|00004af0| 67 75 31 2c 6f 73 74 72 | 69 6e 67 75 32 3d 6f 2e |gu1,ostr|ingu2=o.|
|00004b00| 73 74 72 69 6e 67 75 32 | 2c 6f 73 74 72 69 6e 67 |stringu2|,ostring|
|00004b10| 34 3d 6f 2e 73 74 72 69 | 6e 67 34 29 20 66 72 6f |4=o.stri|ng4) fro|
|00004b20| 6d 20 6f 20 69 6e 20 6f | 6e 65 6b 2c 20 74 31 20 |m o in o|nek, t1 |
|00004b30| 69 6e 20 74 65 6e 6b 31 | 2c 20 74 32 20 69 6e 20 |in tenk1|, t2 in |
|00004b40| 74 65 6e 6b 32 20 77 68 | 65 72 65 20 28 6f 2e 75 |tenk2 wh|ere (o.u|
|00004b50| 6e 69 71 75 65 32 20 3d | 20 74 31 2e 75 6e 69 71 |nique2 =| t1.uniq|
|00004b60| 75 65 32 29 20 61 6e 64 | 20 28 74 31 2e 75 6e 69 |ue2) and| (t1.uni|
|00004b70| 71 75 65 32 20 3d 20 74 | 32 2e 75 6e 69 71 75 65 |que2 = t|2.unique|
|00004b80| 32 29 20 61 6e 64 20 28 | 74 31 2e 75 6e 69 71 75 |2) and (|t1.uniqu|
|00004b90| 65 32 20 3c 20 31 30 30 | 30 29 20 61 6e 64 20 28 |e2 < 100|0) and (|
|00004ba0| 74 32 2e 75 6e 69 71 75 | 65 32 20 3c 20 31 30 30 |t2.uniqu|e2 < 100|
|00004bb0| 30 29 0a 64 65 73 74 72 | 6f 79 20 74 65 6d 70 0a |0).destr|oy temp.|
|00004bc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004bd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004be0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004bf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004c00| 62 65 6e 63 68 2f 71 75 | 65 72 79 31 35 00 00 00 |bench/qu|ery15...|
|00004c10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004c20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004c30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004c40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004c50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004c60| 00 00 00 00 20 20 20 34 | 34 34 20 00 20 20 20 20 |.... 4|44 . |
|00004c70| 20 36 20 00 20 20 20 20 | 20 30 20 00 20 20 20 20 | 6 . | 0 . |
|00004c80| 20 20 20 31 36 35 34 20 | 20 35 32 34 37 30 37 33 | 1654 | 5247073|
|00004c90| 35 33 30 20 20 31 32 36 | 33 34 00 20 30 00 00 00 |530 126|34. 0...|
|00004ca0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004cb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004cc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004cd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ce0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004cf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004d00| 00 75 73 74 61 72 20 20 | 00 70 6f 73 74 67 72 65 |.ustar |.postgre|
|00004d10| 73 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |s.......|........|
|00004d20| 00 00 00 00 00 00 00 00 | 00 73 79 73 74 65 6d 00 |........|.system.|
|00004d30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004d40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004d50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004d60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004d70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004d80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004d90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004da0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004db0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004dc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004dd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004de0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004df0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004e00| 72 65 74 72 69 65 76 65 | 20 69 6e 74 6f 20 74 65 |retrieve| into te|
|00004e10| 6d 70 20 28 74 31 2e 61 | 6c 6c 2c 20 74 32 75 6e |mp (t1.a|ll, t2un|
|00004e20| 69 71 75 65 31 3d 74 32 | 2e 75 6e 69 71 75 65 31 |ique1=t2|.unique1|
|00004e30| 2c 20 74 32 75 6e 69 71 | 75 65 32 3d 74 32 2e 75 |, t2uniq|ue2=t2.u|
|00004e40| 6e 69 71 75 65 32 2c 20 | 74 32 74 77 6f 3d 74 32 |nique2, |t2two=t2|
|00004e50| 2e 74 77 6f 2c 20 74 32 | 66 6f 75 72 3d 74 32 2e |.two, t2|four=t2.|
|00004e60| 66 6f 75 72 2c 20 74 32 | 74 65 6e 3d 74 32 2e 74 |four, t2|ten=t2.t|
|00004e70| 65 6e 2c 20 74 32 74 77 | 65 6e 74 79 3d 20 74 32 |en, t2tw|enty= t2|
|00004e80| 2e 74 77 65 6e 74 79 2c | 20 74 32 68 75 6e 64 72 |.twenty,| t2hundr|
|00004e90| 65 64 3d 74 32 2e 68 75 | 6e 64 72 65 64 2c 20 74 |ed=t2.hu|ndred, t|
|00004ea0| 32 74 68 6f 75 73 61 6e | 64 3d 20 74 32 2e 74 68 |2thousan|d= t2.th|
|00004eb0| 6f 75 73 61 6e 64 2c 74 | 32 74 77 6f 74 68 6f 75 |ousand,t|2twothou|
|00004ec0| 73 61 6e 64 3d 20 74 32 | 2e 74 77 6f 74 68 6f 75 |sand= t2|.twothou|
|00004ed0| 73 61 6e 64 2c 20 74 32 | 66 69 76 65 74 68 6f 75 |sand, t2|fivethou|
|00004ee0| 73 3d 20 74 32 2e 66 69 | 76 65 74 68 6f 75 73 2c |s= t2.fi|vethous,|
|00004ef0| 20 74 32 74 65 6e 74 68 | 6f 75 73 3d 20 74 32 2e | t2tenth|ous= t2.|
|00004f00| 74 65 6e 74 68 6f 75 73 | 2c 20 74 32 6f 64 64 3d |tenthous|, t2odd=|
|00004f10| 20 74 32 2e 6f 64 64 2c | 20 74 32 65 76 65 6e 3d | t2.odd,| t2even=|
|00004f20| 20 74 32 2e 65 76 65 6e | 2c 20 74 32 73 74 72 69 | t2.even|, t2stri|
|00004f30| 6e 67 75 31 3d 20 74 32 | 2e 73 74 72 69 6e 67 75 |ngu1= t2|.stringu|
|00004f40| 31 2c 20 74 32 73 74 72 | 69 6e 67 75 32 3d 20 74 |1, t2str|ingu2= t|
|00004f50| 32 2e 73 74 72 69 6e 67 | 75 32 2c 20 74 32 73 74 |2.string|u2, t2st|
|00004f60| 72 69 6e 67 34 3d 20 74 | 32 2e 73 74 72 69 6e 67 |ring4= t|2.string|
|00004f70| 34 29 20 66 72 6f 6d 20 | 74 31 20 69 6e 20 74 65 |4) from |t1 in te|
|00004f80| 6e 6b 31 2c 20 74 32 20 | 69 6e 20 74 65 6e 6b 32 |nk1, t2 |in tenk2|
|00004f90| 20 77 68 65 72 65 20 28 | 74 31 2e 75 6e 69 71 75 | where (|t1.uniqu|
|00004fa0| 65 31 20 3d 20 74 32 2e | 75 6e 69 71 75 65 31 29 |e1 = t2.|unique1)|
|00004fb0| 20 61 6e 64 20 28 74 32 | 2e 75 6e 69 71 75 65 31 | and (t2|.unique1|
|00004fc0| 20 3c 20 31 30 30 30 29 | 0a 64 65 73 74 72 6f 79 | < 1000)|.destroy|
|00004fd0| 20 74 65 6d 70 0a 72 65 | 74 72 69 65 76 65 20 69 | temp.re|trieve i|
|00004fe0| 6e 74 6f 20 74 65 6d 70 | 20 28 74 31 2e 61 6c 6c |nto temp| (t1.all|
|00004ff0| 2c 20 74 32 75 6e 69 71 | 75 65 31 3d 74 32 2e 75 |, t2uniq|ue1=t2.u|
|00005000| 6e 69 71 75 65 31 2c 20 | 74 32 75 6e 69 71 75 65 |nique1, |t2unique|
|00005010| 32 3d 74 32 2e 75 6e 69 | 71 75 65 32 2c 20 74 32 |2=t2.uni|que2, t2|
|00005020| 74 77 6f 3d 74 32 2e 74 | 77 6f 2c 20 74 32 66 6f |two=t2.t|wo, t2fo|
|00005030| 75 72 3d 74 32 2e 66 6f | 75 72 2c 20 74 32 74 65 |ur=t2.fo|ur, t2te|
|00005040| 6e 3d 74 32 2e 74 65 6e | 2c 20 74 32 74 77 65 6e |n=t2.ten|, t2twen|
|00005050| 74 79 3d 20 74 32 2e 74 | 77 65 6e 74 79 2c 20 74 |ty= t2.t|wenty, t|
|00005060| 32 68 75 6e 64 72 65 64 | 3d 74 32 2e 68 75 6e 64 |2hundred|=t2.hund|
|00005070| 72 65 64 2c 20 74 32 74 | 68 6f 75 73 61 6e 64 3d |red, t2t|housand=|
|00005080| 20 74 32 2e 74 68 6f 75 | 73 61 6e 64 2c 74 32 74 | t2.thou|sand,t2t|
|00005090| 77 6f 74 68 6f 75 73 61 | 6e 64 3d 20 74 32 2e 74 |wothousa|nd= t2.t|
|000050a0| 77 6f 74 68 6f 75 73 61 | 6e 64 2c 20 74 32 66 69 |wothousa|nd, t2fi|
|000050b0| 76 65 74 68 6f 75 73 3d | 20 74 32 2e 66 69 76 65 |vethous=| t2.five|
|000050c0| 74 68 6f 75 73 2c 20 74 | 32 74 65 6e 74 68 6f 75 |thous, t|2tenthou|
|000050d0| 73 3d 20 74 32 2e 74 65 | 6e 74 68 6f 75 73 2c 20 |s= t2.te|nthous, |
|000050e0| 74 32 6f 64 64 3d 20 74 | 32 2e 6f 64 64 2c 20 74 |t2odd= t|2.odd, t|
|000050f0| 32 65 76 65 6e 3d 20 74 | 32 2e 65 76 65 6e 2c 20 |2even= t|2.even, |
|00005100| 74 32 73 74 72 69 6e 67 | 75 31 3d 20 74 32 2e 73 |t2string|u1= t2.s|
|00005110| 74 72 69 6e 67 75 31 2c | 20 74 32 73 74 72 69 6e |tringu1,| t2strin|
|00005120| 67 75 32 3d 20 74 32 2e | 73 74 72 69 6e 67 75 32 |gu2= t2.|stringu2|
|00005130| 2c 20 74 32 73 74 72 69 | 6e 67 34 3d 20 74 32 2e |, t2stri|ng4= t2.|
|00005140| 73 74 72 69 6e 67 34 29 | 20 66 72 6f 6d 20 74 31 |string4)| from t1|
|00005150| 20 69 6e 20 74 65 6e 6b | 31 2c 20 74 32 20 69 6e | in tenk|1, t2 in|
|00005160| 20 74 65 6e 6b 32 20 77 | 68 65 72 65 20 28 74 31 | tenk2 w|here (t1|
|00005170| 2e 75 6e 69 71 75 65 31 | 20 3d 20 74 32 2e 75 6e |.unique1| = t2.un|
|00005180| 69 71 75 65 31 29 20 61 | 6e 64 20 28 74 32 2e 75 |ique1) a|nd (t2.u|
|00005190| 6e 69 71 75 65 31 20 3c | 20 31 30 30 30 29 0a 64 |nique1 <| 1000).d|
|000051a0| 65 73 74 72 6f 79 20 74 | 65 6d 70 0a 00 00 00 00 |estroy t|emp.....|
|000051b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000051c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000051d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000051e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000051f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005200| 62 65 6e 63 68 2f 71 75 | 65 72 79 31 36 00 00 00 |bench/qu|ery16...|
|00005210| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005220| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005230| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005240| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005250| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005260| 00 00 00 00 20 20 20 34 | 34 34 20 00 20 20 20 20 |.... 4|44 . |
|00005270| 20 36 20 00 20 20 20 20 | 20 30 20 00 20 20 20 20 | 6 . | 0 . |
|00005280| 20 20 20 31 34 30 36 20 | 20 35 32 34 37 30 37 33 | 1406 | 5247073|
|00005290| 35 33 31 20 20 31 32 36 | 33 31 00 20 30 00 00 00 |531 126|31. 0...|
|000052a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000052b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000052c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000052d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000052e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000052f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005300| 00 75 73 74 61 72 20 20 | 00 70 6f 73 74 67 72 65 |.ustar |.postgre|
|00005310| 73 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |s.......|........|
|00005320| 00 00 00 00 00 00 00 00 | 00 73 79 73 74 65 6d 00 |........|.system.|
|00005330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005340| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005350| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005380| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000053a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000053b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000053c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000053d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000053e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000053f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005400| 72 65 74 72 69 65 76 65 | 20 69 6e 74 6f 20 74 65 |retrieve| into te|
|00005410| 6d 70 20 28 74 2e 61 6c | 6c 2c 20 42 75 6e 69 71 |mp (t.al|l, Buniq|
|00005420| 75 65 31 3d 42 2e 75 6e | 69 71 75 65 31 2c 42 75 |ue1=B.un|ique1,Bu|
|00005430| 6e 69 71 75 65 32 3d 42 | 2e 75 6e 69 71 75 65 32 |nique2=B|.unique2|
|00005440| 2c 42 74 77 6f 3d 42 2e | 74 77 6f 2c 42 66 6f 75 |,Btwo=B.|two,Bfou|
|00005450| 72 3d 42 2e 66 6f 75 72 | 2c 42 74 65 6e 3d 42 2e |r=B.four|,Bten=B.|
|00005460| 74 65 6e 2c 42 74 77 65 | 6e 74 79 3d 20 42 2e 74 |ten,Btwe|nty= B.t|
|00005470| 77 65 6e 74 79 2c 20 42 | 68 75 6e 64 72 65 64 3d |wenty, B|hundred=|
|00005480| 42 2e 68 75 6e 64 72 65 | 64 2c 42 74 68 6f 75 73 |B.hundre|d,Bthous|
|00005490| 61 6e 64 3d 42 2e 74 68 | 6f 75 73 61 6e 64 2c 42 |and=B.th|ousand,B|
|000054a0| 74 77 6f 74 68 6f 75 73 | 61 6e 64 3d 42 2e 74 77 |twothous|and=B.tw|
|000054b0| 6f 74 68 6f 75 73 61 6e | 64 2c 42 66 69 76 65 74 |othousan|d,Bfivet|
|000054c0| 68 6f 75 73 3d 42 2e 66 | 69 76 65 74 68 6f 75 73 |hous=B.f|ivethous|
|000054d0| 2c 42 74 65 6e 74 68 6f | 75 73 3d 42 2e 74 65 6e |,Btentho|us=B.ten|
|000054e0| 74 68 6f 75 73 2c 42 6f | 64 64 3d 42 2e 6f 64 64 |thous,Bo|dd=B.odd|
|000054f0| 2c 20 42 65 76 65 6e 3d | 42 2e 65 76 65 6e 2c 42 |, Beven=|B.even,B|
|00005500| 73 74 72 69 6e 67 75 31 | 3d 42 2e 73 74 72 69 6e |stringu1|=B.strin|
|00005510| 67 75 31 2c 42 73 74 72 | 69 6e 67 75 32 3d 42 2e |gu1,Bstr|ingu2=B.|
|00005520| 73 74 72 69 6e 67 75 32 | 2c 42 73 74 72 69 6e 67 |stringu2|,Bstring|
|00005530| 34 3d 42 2e 73 74 72 69 | 6e 67 34 29 20 66 72 6f |4=B.stri|ng4) fro|
|00005540| 6d 20 74 20 69 6e 20 74 | 65 6e 6b 31 2c 20 42 20 |m t in t|enk1, B |
|00005550| 69 6e 20 42 70 72 69 6d | 65 20 77 68 65 72 65 20 |in Bprim|e where |
|00005560| 74 2e 75 6e 69 71 75 65 | 31 20 3d 20 42 2e 75 6e |t.unique|1 = B.un|
|00005570| 69 71 75 65 31 0a 64 65 | 73 74 72 6f 79 20 74 65 |ique1.de|stroy te|
|00005580| 6d 70 0a 72 65 74 72 69 | 65 76 65 20 69 6e 74 6f |mp.retri|eve into|
|00005590| 20 74 65 6d 70 20 28 74 | 2e 61 6c 6c 2c 20 42 75 | temp (t|.all, Bu|
|000055a0| 6e 69 71 75 65 31 3d 42 | 2e 75 6e 69 71 75 65 31 |nique1=B|.unique1|
|000055b0| 2c 42 75 6e 69 71 75 65 | 32 3d 42 2e 75 6e 69 71 |,Bunique|2=B.uniq|
|000055c0| 75 65 32 2c 42 74 77 6f | 3d 42 2e 74 77 6f 2c 42 |ue2,Btwo|=B.two,B|
|000055d0| 66 6f 75 72 3d 42 2e 66 | 6f 75 72 2c 42 74 65 6e |four=B.f|our,Bten|
|000055e0| 3d 42 2e 74 65 6e 2c 42 | 74 77 65 6e 74 79 3d 20 |=B.ten,B|twenty= |
|000055f0| 42 2e 74 77 65 6e 74 79 | 2c 20 42 68 75 6e 64 72 |B.twenty|, Bhundr|
|00005600| 65 64 3d 42 2e 68 75 6e | 64 72 65 64 2c 42 74 68 |ed=B.hun|dred,Bth|
|00005610| 6f 75 73 61 6e 64 3d 42 | 2e 74 68 6f 75 73 61 6e |ousand=B|.thousan|
|00005620| 64 2c 42 74 77 6f 74 68 | 6f 75 73 61 6e 64 3d 42 |d,Btwoth|ousand=B|
|00005630| 2e 74 77 6f 74 68 6f 75 | 73 61 6e 64 2c 42 66 69 |.twothou|sand,Bfi|
|00005640| 76 65 74 68 6f 75 73 3d | 42 2e 66 69 76 65 74 68 |vethous=|B.fiveth|
|00005650| 6f 75 73 2c 42 74 65 6e | 74 68 6f 75 73 3d 42 2e |ous,Bten|thous=B.|
|00005660| 74 65 6e 74 68 6f 75 73 | 2c 42 6f 64 64 3d 42 2e |tenthous|,Bodd=B.|
|00005670| 6f 64 64 2c 20 42 65 76 | 65 6e 3d 42 2e 65 76 65 |odd, Bev|en=B.eve|
|00005680| 6e 2c 42 73 74 72 69 6e | 67 75 31 3d 42 2e 73 74 |n,Bstrin|gu1=B.st|
|00005690| 72 69 6e 67 75 31 2c 42 | 73 74 72 69 6e 67 75 32 |ringu1,B|stringu2|
|000056a0| 3d 42 2e 73 74 72 69 6e | 67 75 32 2c 42 73 74 72 |=B.strin|gu2,Bstr|
|000056b0| 69 6e 67 34 3d 42 2e 73 | 74 72 69 6e 67 34 29 20 |ing4=B.s|tring4) |
|000056c0| 66 72 6f 6d 20 74 20 69 | 6e 20 74 65 6e 6b 31 2c |from t i|n tenk1,|
|000056d0| 20 42 20 69 6e 20 42 70 | 72 69 6d 65 20 77 68 65 | B in Bp|rime whe|
|000056e0| 72 65 20 74 2e 75 6e 69 | 71 75 65 31 20 3d 20 42 |re t.uni|que1 = B|
|000056f0| 2e 75 6e 69 71 75 65 31 | 0a 64 65 73 74 72 6f 79 |.unique1|.destroy|
|00005700| 20 74 65 6d 70 0a 00 00 | 00 00 00 00 00 00 00 00 | temp...|........|
|00005710| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005720| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005730| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005740| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005750| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005760| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005770| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005780| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005790| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000057a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000057b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000057c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000057d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000057e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000057f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005800| 62 65 6e 63 68 2f 71 75 | 65 72 79 31 37 00 00 00 |bench/qu|ery17...|
|00005810| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005820| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005830| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005840| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005850| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005860| 00 00 00 00 20 20 20 34 | 34 34 20 00 20 20 20 20 |.... 4|44 . |
|00005870| 20 36 20 00 20 20 20 20 | 20 30 20 00 20 20 20 20 | 6 . | 0 . |
|00005880| 20 20 20 31 37 30 34 20 | 20 35 32 34 37 30 37 33 | 1704 | 5247073|
|00005890| 35 33 31 20 20 31 32 36 | 33 33 00 20 30 00 00 00 |531 126|33. 0...|
|000058a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000058b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000058c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000058d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000058e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000058f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005900| 00 75 73 74 61 72 20 20 | 00 70 6f 73 74 67 72 65 |.ustar |.postgre|
|00005910| 73 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |s.......|........|
|00005920| 00 00 00 00 00 00 00 00 | 00 73 79 73 74 65 6d 00 |........|.system.|
|00005930| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005940| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005950| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005960| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005970| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005980| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005990| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000059a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000059b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000059c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000059d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000059e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000059f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005a00| 72 65 74 72 69 65 76 65 | 20 69 6e 74 6f 20 74 65 |retrieve| into te|
|00005a10| 6d 70 20 28 74 31 2e 61 | 6c 6c 2c 20 6f 75 6e 69 |mp (t1.a|ll, ouni|
|00005a20| 71 75 65 31 3d 6f 2e 75 | 6e 69 71 75 65 31 2c 6f |que1=o.u|nique1,o|
|00005a30| 75 6e 69 71 75 65 32 3d | 6f 2e 75 6e 69 71 75 65 |unique2=|o.unique|
|00005a40| 32 2c 6f 74 77 6f 3d 6f | 2e 74 77 6f 2c 6f 66 6f |2,otwo=o|.two,ofo|
|00005a50| 75 72 3d 6f 2e 66 6f 75 | 72 2c 6f 74 65 6e 3d 6f |ur=o.fou|r,oten=o|
|00005a60| 2e 74 65 6e 2c 6f 74 77 | 65 6e 74 79 3d 20 6f 2e |.ten,otw|enty= o.|
|00005a70| 74 77 65 6e 74 79 2c 20 | 6f 68 75 6e 64 72 65 64 |twenty, |ohundred|
|00005a80| 3d 6f 2e 68 75 6e 64 72 | 65 64 2c 6f 74 68 6f 75 |=o.hundr|ed,othou|
|00005a90| 73 61 6e 64 3d 6f 2e 74 | 68 6f 75 73 61 6e 64 2c |sand=o.t|housand,|
|00005aa0| 6f 74 77 6f 74 68 6f 75 | 73 61 6e 64 3d 6f 2e 74 |otwothou|sand=o.t|
|00005ab0| 77 6f 74 68 6f 75 73 61 | 6e 64 2c 6f 66 69 76 65 |wothousa|nd,ofive|
|00005ac0| 74 68 6f 75 73 3d 6f 2e | 66 69 76 65 74 68 6f 75 |thous=o.|fivethou|
|00005ad0| 73 2c 6f 74 65 6e 74 68 | 6f 75 73 3d 6f 2e 74 65 |s,otenth|ous=o.te|
|00005ae0| 6e 74 68 6f 75 73 2c 6f | 6f 64 64 3d 6f 2e 6f 64 |nthous,o|odd=o.od|
|00005af0| 64 2c 20 6f 65 76 65 6e | 3d 6f 2e 65 76 65 6e 2c |d, oeven|=o.even,|
|00005b00| 6f 73 74 72 69 6e 67 75 | 31 3d 6f 2e 73 74 72 69 |ostringu|1=o.stri|
|00005b10| 6e 67 75 31 2c 6f 73 74 | 72 69 6e 67 75 32 3d 6f |ngu1,ost|ringu2=o|
|00005b20| 2e 73 74 72 69 6e 67 75 | 32 2c 6f 73 74 72 69 6e |.stringu|2,ostrin|
|00005b30| 67 34 3d 6f 2e 73 74 72 | 69 6e 67 34 20 29 20 66 |g4=o.str|ing4 ) f|
|00005b40| 72 6f 6d 20 6f 20 69 6e | 20 6f 6e 65 6b 2c 20 74 |rom o in| onek, t|
|00005b50| 31 20 69 6e 20 74 65 6e | 6b 31 2c 20 74 32 20 69 |1 in ten|k1, t2 i|
|00005b60| 6e 20 74 65 6e 6b 32 20 | 77 68 65 72 65 20 28 6f |n tenk2 |where (o|
|00005b70| 2e 75 6e 69 71 75 65 31 | 20 3d 20 74 31 2e 75 6e |.unique1| = t1.un|
|00005b80| 69 71 75 65 31 29 20 61 | 6e 64 20 28 74 31 2e 75 |ique1) a|nd (t1.u|
|00005b90| 6e 69 71 75 65 31 20 3d | 20 74 32 2e 75 6e 69 71 |nique1 =| t2.uniq|
|00005ba0| 75 65 31 29 20 61 6e 64 | 20 28 74 31 2e 75 6e 69 |ue1) and| (t1.uni|
|00005bb0| 71 75 65 31 20 3c 20 31 | 30 30 30 29 20 61 6e 64 |que1 < 1|000) and|
|00005bc0| 20 28 74 32 2e 75 6e 69 | 71 75 65 31 20 3c 20 31 | (t2.uni|que1 < 1|
|00005bd0| 30 30 30 29 0a 64 65 73 | 74 72 6f 79 20 74 65 6d |000).des|troy tem|
|00005be0| 70 0a 72 65 74 72 69 65 | 76 65 20 69 6e 74 6f 20 |p.retrie|ve into |
|00005bf0| 74 65 6d 70 20 28 74 31 | 2e 61 6c 6c 2c 20 6f 75 |temp (t1|.all, ou|
|00005c00| 6e 69 71 75 65 31 3d 6f | 2e 75 6e 69 71 75 65 31 |nique1=o|.unique1|
|00005c10| 2c 6f 75 6e 69 71 75 65 | 32 3d 6f 2e 75 6e 69 71 |,ounique|2=o.uniq|
|00005c20| 75 65 32 2c 6f 74 77 6f | 3d 6f 2e 74 77 6f 2c 6f |ue2,otwo|=o.two,o|
|00005c30| 66 6f 75 72 3d 6f 2e 66 | 6f 75 72 2c 6f 74 65 6e |four=o.f|our,oten|
|00005c40| 3d 6f 2e 74 65 6e 2c 6f | 74 77 65 6e 74 79 3d 20 |=o.ten,o|twenty= |
|00005c50| 6f 2e 74 77 65 6e 74 79 | 2c 20 6f 68 75 6e 64 72 |o.twenty|, ohundr|
|00005c60| 65 64 3d 6f 2e 68 75 6e | 64 72 65 64 2c 6f 74 68 |ed=o.hun|dred,oth|
|00005c70| 6f 75 73 61 6e 64 3d 6f | 2e 74 68 6f 75 73 61 6e |ousand=o|.thousan|
|00005c80| 64 2c 6f 74 77 6f 74 68 | 6f 75 73 61 6e 64 3d 6f |d,otwoth|ousand=o|
|00005c90| 2e 74 77 6f 74 68 6f 75 | 73 61 6e 64 2c 6f 66 69 |.twothou|sand,ofi|
|00005ca0| 76 65 74 68 6f 75 73 3d | 6f 2e 66 69 76 65 74 68 |vethous=|o.fiveth|
|00005cb0| 6f 75 73 2c 6f 74 65 6e | 74 68 6f 75 73 3d 6f 2e |ous,oten|thous=o.|
|00005cc0| 74 65 6e 74 68 6f 75 73 | 2c 6f 6f 64 64 3d 6f 2e |tenthous|,oodd=o.|
|00005cd0| 6f 64 64 2c 20 6f 65 76 | 65 6e 3d 6f 2e 65 76 65 |odd, oev|en=o.eve|
|00005ce0| 6e 2c 6f 73 74 72 69 6e | 67 75 31 3d 6f 2e 73 74 |n,ostrin|gu1=o.st|
|00005cf0| 72 69 6e 67 75 31 2c 6f | 73 74 72 69 6e 67 75 32 |ringu1,o|stringu2|
|00005d00| 3d 6f 2e 73 74 72 69 6e | 67 75 32 2c 6f 73 74 72 |=o.strin|gu2,ostr|
|00005d10| 69 6e 67 34 3d 6f 2e 73 | 74 72 69 6e 67 34 20 29 |ing4=o.s|tring4 )|
|00005d20| 20 66 72 6f 6d 20 6f 20 | 69 6e 20 6f 6e 65 6b 2c | from o |in onek,|
|00005d30| 20 74 31 20 69 6e 20 74 | 65 6e 6b 31 2c 20 74 32 | t1 in t|enk1, t2|
|00005d40| 20 69 6e 20 74 65 6e 6b | 32 20 77 68 65 72 65 20 | in tenk|2 where |
|00005d50| 28 6f 2e 75 6e 69 71 75 | 65 31 20 3d 20 74 31 2e |(o.uniqu|e1 = t1.|
|00005d60| 75 6e 69 71 75 65 31 29 | 20 61 6e 64 20 28 74 31 |unique1)| and (t1|
|00005d70| 2e 75 6e 69 71 75 65 31 | 20 3d 20 74 32 2e 75 6e |.unique1| = t2.un|
|00005d80| 69 71 75 65 31 29 20 61 | 6e 64 20 28 74 31 2e 75 |ique1) a|nd (t1.u|
|00005d90| 6e 69 71 75 65 31 20 3c | 20 31 30 30 30 29 20 61 |nique1 <| 1000) a|
|00005da0| 6e 64 20 28 74 32 2e 75 | 6e 69 71 75 65 31 20 3c |nd (t2.u|nique1 <|
|00005db0| 20 31 30 30 30 29 0a 64 | 65 73 74 72 6f 79 20 74 | 1000).d|estroy t|
|00005dc0| 65 6d 70 0a 00 00 00 00 | 00 00 00 00 00 00 00 00 |emp.....|........|
|00005dd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005de0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005df0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005e00| 62 65 6e 63 68 2f 71 75 | 65 72 79 31 38 00 00 00 |bench/qu|ery18...|
|00005e10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005e20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005e30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005e40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005e50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005e60| 00 00 00 00 20 20 20 34 | 34 34 20 00 20 20 20 20 |.... 4|44 . |
|00005e70| 20 36 20 00 20 20 20 20 | 20 30 20 00 20 20 20 20 | 6 . | 0 . |
|00005e80| 20 20 20 20 33 33 36 20 | 20 35 32 34 37 30 37 33 | 336 | 5247073|
|00005e90| 35 33 31 20 20 31 32 36 | 31 34 00 20 30 00 00 00 |531 126|14. 0...|
|00005ea0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005eb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ec0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ed0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ee0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ef0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f00| 00 75 73 74 61 72 20 20 | 00 70 6f 73 74 67 72 65 |.ustar |.postgre|
|00005f10| 73 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |s.......|........|
|00005f20| 00 00 00 00 00 00 00 00 | 00 73 79 73 74 65 6d 00 |........|.system.|
|00005f30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005fa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005fb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005fc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005fd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005fe0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ff0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006000| 72 65 74 72 69 65 76 65 | 20 69 6e 74 6f 20 74 65 |retrieve| into te|
|00006010| 6d 70 20 28 74 31 2e 74 | 77 6f 2c 20 74 31 2e 66 |mp (t1.t|wo, t1.f|
|00006020| 6f 75 72 2c 20 74 31 2e | 74 65 6e 2c 20 74 31 2e |our, t1.|ten, t1.|
|00006030| 74 77 65 6e 74 79 2c 20 | 74 31 2e 68 75 6e 64 72 |twenty, |t1.hundr|
|00006040| 65 64 2c 20 74 31 2e 73 | 74 72 69 6e 67 34 20 29 |ed, t1.s|tring4 )|
|00006050| 20 66 72 6f 6d 20 74 31 | 20 69 6e 20 74 65 6e 6b | from t1| in tenk|
|00006060| 31 0a 64 65 73 74 72 6f | 79 20 74 65 6d 70 0a 72 |1.destro|y temp.r|
|00006070| 65 74 72 69 65 76 65 20 | 69 6e 74 6f 20 74 65 6d |etrieve |into tem|
|00006080| 70 20 28 74 31 2e 74 77 | 6f 2c 20 74 31 2e 66 6f |p (t1.tw|o, t1.fo|
|00006090| 75 72 2c 20 74 31 2e 74 | 65 6e 2c 20 74 31 2e 74 |ur, t1.t|en, t1.t|
|000060a0| 77 65 6e 74 79 2c 20 74 | 31 2e 68 75 6e 64 72 65 |wenty, t|1.hundre|
|000060b0| 64 2c 20 74 31 2e 73 74 | 72 69 6e 67 34 20 29 20 |d, t1.st|ring4 ) |
|000060c0| 66 72 6f 6d 20 74 31 20 | 69 6e 20 74 65 6e 6b 31 |from t1 |in tenk1|
|000060d0| 0a 64 65 73 74 72 6f 79 | 20 74 65 6d 70 0a 00 00 |.destroy| temp...|
|000060e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000060f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006100| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006110| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006120| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006180| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006190| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000061a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000061b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000061c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000061d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000061e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000061f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006200| 62 65 6e 63 68 2f 71 75 | 65 72 79 31 39 00 00 00 |bench/qu|ery19...|
|00006210| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006220| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006230| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006240| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006250| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006260| 00 00 00 00 20 20 20 34 | 34 34 20 00 20 20 20 20 |.... 4|44 . |
|00006270| 20 36 20 00 20 20 20 20 | 20 30 20 00 20 20 20 20 | 6 . | 0 . |
|00006280| 20 20 20 20 31 35 36 20 | 20 35 32 34 37 30 37 33 | 156 | 5247073|
|00006290| 35 33 31 20 20 31 32 36 | 31 35 00 20 30 00 00 00 |531 126|15. 0...|
|000062a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000062b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000062c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000062d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000062e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000062f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006300| 00 75 73 74 61 72 20 20 | 00 70 6f 73 74 67 72 65 |.ustar |.postgre|
|00006310| 73 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |s.......|........|
|00006320| 00 00 00 00 00 00 00 00 | 00 73 79 73 74 65 6d 00 |........|.system.|
|00006330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006340| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006350| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006380| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000063a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000063b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000063c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000063d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000063e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000063f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
