SHARE
TWEET

Untitled

a guest Mar 25th, 2019 64 in 245 days
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. user@debian:~$ ./test64.sh
  2. The files belonging to this database system will be owned by user "user".
  3. This user must also own the server process.
  4.  
  5. The database cluster will be initialized with locale "en_US.UTF-8".
  6. The default database encoding has accordingly been set to "UTF8".
  7. The default text search configuration will be set to "english".
  8.  
  9. Data page checksums are disabled.
  10.  
  11. creating directory ./data64 ... ok
  12. creating subdirectories ... ok
  13. selecting default max_connections ... 100
  14. selecting default shared_buffers ... 128MB
  15. selecting dynamic shared memory implementation ... posix
  16. creating configuration files ... ok
  17. running bootstrap script ... ok
  18. performing post-bootstrap initialization ... ok
  19. syncing data to disk ... ok
  20.  
  21. WARNING: enabling "trust" authentication for local connections
  22. You can change this by editing pg_hba.conf or using the option -A, or
  23. --auth-local and --auth-host, the next time you run initdb.
  24.  
  25. Success. You can now start the database server using:
  26.  
  27.     /usr/local/pgsql/bin/pg_ctl -D ./data64 -l logfile start
  28.  
  29. server starting
  30. CREATE DATABASE
  31. NOTICE:  table "pgbench_history" does not exist, skipping
  32. NOTICE:  table "pgbench_tellers" does not exist, skipping
  33. NOTICE:  table "pgbench_accounts" does not exist, skipping
  34. NOTICE:  table "pgbench_branches" does not exist, skipping
  35. creating tables...
  36. 100000 of 10000000 tuples (1%) done (elapsed 0.13 s, remaining 12.79 s)
  37. 200000 of 10000000 tuples (2%) done (elapsed 0.29 s, remaining 14.22 s)
  38. 300000 of 10000000 tuples (3%) done (elapsed 0.48 s, remaining 15.50 s)
  39. ...
  40. 9800000 of 10000000 tuples (98%) done (elapsed 17.23 s, remaining 0.35 s)
  41. 9900000 of 10000000 tuples (99%) done (elapsed 17.41 s, remaining 0.18 s)
  42. 10000000 of 10000000 tuples (100%) done (elapsed 17.54 s, remaining 0.00 s)
  43. vacuum...
  44. set primary keys...
  45. done.
  46. starting vacuum...end.
  47. transaction type: <builtin: TPC-B (sort of)>
  48. scaling factor: 100
  49. query mode: simple
  50. number of clients: 100
  51. number of threads: 1
  52. number of transactions per client: 10
  53. number of transactions actually processed: 1000/1000
  54. latency average = 341.543 ms
  55. tps = 292.788988 (including connections establishing)
  56. tps = 292.955840 (excluding connections establishing)
  57. waiting for server to shut down.... done
  58. server stopped
  59. --------------------------------------------------------------------------------
  60. user@debian:~$ ./test32.sh
  61. The files belonging to this database system will be owned by user "user".
  62. This user must also own the server process.
  63.  
  64. The database cluster will be initialized with locale "en_US.UTF-8".
  65. The default database encoding has accordingly been set to "UTF8".
  66. The default text search configuration will be set to "english".
  67.  
  68. Data page checksums are disabled.
  69.  
  70. creating directory ./data32 ... ok
  71. creating subdirectories ... ok
  72. selecting default max_connections ... 100
  73. selecting default shared_buffers ... 128MB
  74. selecting dynamic shared memory implementation ... posix
  75. creating configuration files ... ok
  76. running bootstrap script ... ok
  77. performing post-bootstrap initialization ... ok
  78. syncing data to disk ... ok
  79.  
  80. WARNING: enabling "trust" authentication for local connections
  81. You can change this by editing pg_hba.conf or using the option -A, or
  82. --auth-local and --auth-host, the next time you run initdb.
  83.  
  84. Success. You can now start the database server using:
  85.  
  86.     pg_ctl -D ./data32 -l logfile start
  87.  
  88. server starting
  89. CREATE DATABASE
  90. NOTICE:  table "pgbench_history" does not exist, skipping
  91. NOTICE:  table "pgbench_tellers" does not exist, skipping
  92. NOTICE:  table "pgbench_accounts" does not exist, skipping
  93. NOTICE:  table "pgbench_branches" does not exist, skipping
  94. creating tables...
  95. 100000 of 10000000 tuples (1%) done (elapsed 0.11 s, remaining 10.84 s)
  96. 200000 of 10000000 tuples (2%) done (elapsed 0.24 s, remaining 11.57 s)
  97. 300000 of 10000000 tuples (3%) done (elapsed 0.36 s, remaining 11.57 s)
  98. ...
  99. 9800000 of 10000000 tuples (98%) done (elapsed 15.12 s, remaining 0.31 s)
  100. 9900000 of 10000000 tuples (99%) done (elapsed 15.27 s, remaining 0.15 s)
  101. 10000000 of 10000000 tuples (100%) done (elapsed 15.41 s, remaining 0.00 s)
  102. vacuum...
  103. set primary keys...
  104. done.
  105. starting vacuum...end.
  106. transaction type: <builtin: TPC-B (sort of)>
  107. scaling factor: 100
  108. query mode: simple
  109. number of clients: 100
  110. number of threads: 1
  111. number of transactions per client: 10
  112. number of transactions actually processed: 1000/1000
  113. latency average = 355.038 ms
  114. tps = 281.659833 (including connections establishing)
  115. tps = 281.828470 (excluding connections establishing)
  116. waiting for server to shut down.... done
  117. server stopped
  118. --------------------------------------------------------------------------
  119. user@debian:~$ ./test32.sh
  120. The files belonging to this database system will be owned by user "user".
  121. This user must also own the server process.
  122.  
  123. The database cluster will be initialized with locale "en_US.UTF-8".
  124. The default database encoding has accordingly been set to "UTF8".
  125. The default text search configuration will be set to "english".
  126.  
  127. Data page checksums are disabled.
  128.  
  129. creating directory ./data32 ... ok
  130. creating subdirectories ... ok
  131. selecting default max_connections ... 100
  132. selecting default shared_buffers ... 128MB
  133. selecting dynamic shared memory implementation ... posix
  134. creating configuration files ... ok
  135. running bootstrap script ... ok
  136. performing post-bootstrap initialization ... ok
  137. syncing data to disk ... ok
  138.  
  139. WARNING: enabling "trust" authentication for local connections
  140. You can change this by editing pg_hba.conf or using the option -A, or
  141. --auth-local and --auth-host, the next time you run initdb.
  142.  
  143. Success. You can now start the database server using:
  144.  
  145.     pg_ctl -D ./data32 -l logfile start
  146.  
  147. server starting
  148. CREATE DATABASE
  149. NOTICE:  table "pgbench_history" does not exist, skipping
  150. NOTICE:  table "pgbench_tellers" does not exist, skipping
  151. NOTICE:  table "pgbench_accounts" does not exist, skipping
  152. NOTICE:  table "pgbench_branches" does not exist, skipping
  153. creating tables...
  154. 100000 of 10000000 tuples (1%) done (elapsed 0.17 s, remaining 16.51 s)
  155. 200000 of 10000000 tuples (2%) done (elapsed 0.37 s, remaining 18.30 s)
  156. 300000 of 10000000 tuples (3%) done (elapsed 0.55 s, remaining 17.73 s)
  157. ...
  158. 9800000 of 10000000 tuples (98%) done (elapsed 18.77 s, remaining 0.38 s)
  159. 9900000 of 10000000 tuples (99%) done (elapsed 18.93 s, remaining 0.19 s)
  160. 10000000 of 10000000 tuples (100%) done (elapsed 19.10 s, remaining 0.00 s)
  161. vacuum...
  162. set primary keys...
  163. done.
  164. starting vacuum...end.
  165. transaction type: <builtin: TPC-B (sort of)>
  166. scaling factor: 100
  167. query mode: simple
  168. number of clients: 100
  169. number of threads: 1
  170. number of transactions per client: 10
  171. number of transactions actually processed: 1000/1000
  172. latency average = 423.503 ms
  173. tps = 236.125613 (including connections establishing)
  174. tps = 236.248619 (excluding connections establishing)
  175. waiting for server to shut down..... done
  176. server stopped
  177. -------------------------------------------------------------------------------
  178. user@debian:~$ ./test64.sh
  179. The files belonging to this database system will be owned by user "user".
  180. This user must also own the server process.
  181.  
  182. The database cluster will be initialized with locale "en_US.UTF-8".
  183. The default database encoding has accordingly been set to "UTF8".
  184. The default text search configuration will be set to "english".
  185.  
  186. Data page checksums are disabled.
  187.  
  188. creating directory ./data64 ... ok
  189. creating subdirectories ... ok
  190. selecting default max_connections ... 100
  191. selecting default shared_buffers ... 128MB
  192. selecting dynamic shared memory implementation ... posix
  193. creating configuration files ... ok
  194. running bootstrap script ... ok
  195. performing post-bootstrap initialization ... ok
  196. syncing data to disk ... ok
  197.  
  198. WARNING: enabling "trust" authentication for local connections
  199. You can change this by editing pg_hba.conf or using the option -A, or
  200. --auth-local and --auth-host, the next time you run initdb.
  201.  
  202. Success. You can now start the database server using:
  203.  
  204.     /usr/local/pgsql/bin/pg_ctl -D ./data64 -l logfile start
  205.  
  206. server starting
  207. CREATE DATABASE
  208. NOTICE:  table "pgbench_history" does not exist, skipping
  209. NOTICE:  table "pgbench_tellers" does not exist, skipping
  210. NOTICE:  table "pgbench_accounts" does not exist, skipping
  211. NOTICE:  table "pgbench_branches" does not exist, skipping
  212. creating tables...
  213. 100000 of 10000000 tuples (1%) done (elapsed 0.12 s, remaining 12.06 s)
  214. 200000 of 10000000 tuples (2%) done (elapsed 0.29 s, remaining 14.12 s)
  215. 300000 of 10000000 tuples (3%) done (elapsed 0.51 s, remaining 16.38 s)
  216. ...
  217. 9800000 of 10000000 tuples (98%) done (elapsed 17.78 s, remaining 0.36 s)
  218. 9900000 of 10000000 tuples (99%) done (elapsed 17.97 s, remaining 0.18 s)
  219. 10000000 of 10000000 tuples (100%) done (elapsed 18.14 s, remaining 0.00 s)
  220. vacuum...
  221. set primary keys...
  222. done.
  223. starting vacuum...end.
  224. transaction type: <builtin: TPC-B (sort of)>
  225. scaling factor: 100
  226. query mode: simple
  227. number of clients: 100
  228. number of threads: 1
  229. number of transactions per client: 10
  230. number of transactions actually processed: 1000/1000
  231. latency average = 396.510 ms
  232. tps = 252.200258 (including connections establishing)
  233. tps = 252.326603 (excluding connections establishing)
  234. waiting for server to shut down.... done
  235. server stopped
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top