API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 29th, 2022
59
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.25 KB | None | 0 0
raw download clone embed print report
  1. -[ RECORD 1 ]---+------------------------------------------------------------------------------------------
  2. name | autovacuum
  3. setting | on
  4. unit |
  5. category | Autovacuum
  6. short_desc | Starts the autovacuum subprocess.
  7. extra_desc |
  8. context | sighup
  9. vartype | bool
  10. source | configuration file
  11. min_val |
  12. max_val |
  13. enumvals |
  14. boot_val | on
  15. reset_val | on
  16. sourcefile | /etc/postgresql/12/main/postgresql.conf
  17. sourceline | 576
  18. pending_restart | f
  19. -[ RECORD 2 ]---+------------------------------------------------------------------------------------------
  20. name | autovacuum_analyze_scale_factor
  21. setting | 0.1
  22. unit |
  23. category | Autovacuum
  24. short_desc | Number of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples.
  25. extra_desc |
  26. context | sighup
  27. vartype | real
  28. source | default
  29. min_val | 0
  30. max_val | 100
  31. enumvals |
  32. boot_val | 0.1
  33. reset_val | 0.1
  34. sourcefile |
  35. sourceline |
  36. pending_restart | f
  37. -[ RECORD 3 ]---+------------------------------------------------------------------------------------------
  38. name | autovacuum_analyze_threshold
  39. setting | 50
  40. unit |
  41. category | Autovacuum
  42. short_desc | Minimum number of tuple inserts, updates, or deletes prior to analyze.
  43. extra_desc |
  44. context | sighup
  45. vartype | integer
  46. source | default
  47. min_val | 0
  48. max_val | 2147483647
  49. enumvals |
  50. boot_val | 50
  51. reset_val | 50
  52. sourcefile |
  53. sourceline |
  54. pending_restart | f
  55. -[ RECORD 4 ]---+------------------------------------------------------------------------------------------
  56. name | autovacuum_freeze_max_age
  57. setting | 200000000
  58. unit |
  59. category | Autovacuum
  60. short_desc | Age at which to autovacuum a table to prevent transaction ID wraparound.
  61. extra_desc |
  62. context | postmaster
  63. vartype | integer
  64. source | default
  65. min_val | 100000
  66. max_val | 2000000000
  67. enumvals |
  68. boot_val | 200000000
  69. reset_val | 200000000
  70. sourcefile |
  71. sourceline |
  72. pending_restart | f
  73. -[ RECORD 5 ]---+------------------------------------------------------------------------------------------
  74. name | autovacuum_max_workers
  75. setting | 3
  76. unit |
  77. category | Autovacuum
  78. short_desc | Sets the maximum number of simultaneously running autovacuum worker processes.
  79. extra_desc |
  80. context | postmaster
  81. vartype | integer
  82. source | default
  83. min_val | 1
  84. max_val | 262143
  85. enumvals |
  86. boot_val | 3
  87. reset_val | 3
  88. sourcefile |
  89. sourceline |
  90. pending_restart | f
  91. -[ RECORD 6 ]---+------------------------------------------------------------------------------------------
  92. name | autovacuum_multixact_freeze_max_age
  93. setting | 400000000
  94. unit |
  95. category | Autovacuum
  96. short_desc | Multixact age at which to autovacuum a table to prevent multixact wraparound.
  97. extra_desc |
  98. context | postmaster
  99. vartype | integer
  100. source | default
  101. min_val | 10000
  102. max_val | 2000000000
  103. enumvals |
  104. boot_val | 400000000
  105. reset_val | 400000000
  106. sourcefile |
  107. sourceline |
  108. pending_restart | f
  109. -[ RECORD 7 ]---+------------------------------------------------------------------------------------------
  110. name | autovacuum_naptime
  111. setting | 60
  112. unit | s
  113. category | Autovacuum
  114. short_desc | Time to sleep between autovacuum runs.
  115. extra_desc |
  116. context | sighup
  117. vartype | integer
  118. source | default
  119. min_val | 1
  120. max_val | 2147483
  121. enumvals |
  122. boot_val | 60
  123. reset_val | 60
  124. sourcefile |
  125. sourceline |
  126. pending_restart | f
  127. -[ RECORD 8 ]---+------------------------------------------------------------------------------------------
  128. name | autovacuum_vacuum_cost_delay
  129. setting | 2
  130. unit | ms
  131. category | Autovacuum
  132. short_desc | Vacuum cost delay in milliseconds, for autovacuum.
  133. extra_desc |
  134. context | sighup
  135. vartype | real
  136. source | default
  137. min_val | -1
  138. max_val | 100
  139. enumvals |
  140. boot_val | 2
  141. reset_val | 2
  142. sourcefile |
  143. sourceline |
  144. pending_restart | f
  145. -[ RECORD 9 ]---+------------------------------------------------------------------------------------------
  146. name | autovacuum_vacuum_cost_limit
  147. setting | -1
  148. unit |
  149. category | Autovacuum
  150. short_desc | Vacuum cost amount available before napping, for autovacuum.
  151. extra_desc |
  152. context | sighup
  153. vartype | integer
  154. source | default
  155. min_val | -1
  156. max_val | 10000
  157. enumvals |
  158. boot_val | -1
  159. reset_val | -1
  160. sourcefile |
  161. sourceline |
  162. pending_restart | f
  163. -[ RECORD 10 ]--+------------------------------------------------------------------------------------------
  164. name | autovacuum_vacuum_scale_factor
  165. setting | 0.05
  166. unit |
  167. category | Autovacuum
  168. short_desc | Number of tuple updates or deletes prior to vacuum as a fraction of reltuples.
  169. extra_desc |
  170. context | sighup
  171. vartype | real
  172. source | configuration file
  173. min_val | 0
  174. max_val | 100
  175. enumvals |
  176. boot_val | 0.2
  177. reset_val | 0.05
  178. sourcefile | /etc/postgresql/12/main/postgresql.conf
  179. sourceline | 589
  180. pending_restart | f
  181. -[ RECORD 11 ]--+------------------------------------------------------------------------------------------
  182. name | autovacuum_vacuum_threshold
  183. setting | 50
  184. unit |
  185. category | Autovacuum
  186. short_desc | Minimum number of tuple updates or deletes prior to vacuum.
  187. extra_desc |
  188. context | sighup
  189. vartype | integer
  190. source | default
  191. min_val | 0
  192. max_val | 2147483647
  193. enumvals |
  194. boot_val | 50
  195. reset_val | 50
  196. sourcefile |
  197. sourceline |
  198. pending_restart | f
  199. -[ RECORD 12 ]--+------------------------------------------------------------------------------------------
  200. name | autovacuum_work_mem
  201. setting | -1
  202. unit | kB
  203. category | Resource Usage / Memory
  204. short_desc | Sets the maximum memory to be used by each autovacuum worker process.
  205. extra_desc |
  206. context | sighup
  207. vartype | integer
  208. source | default
  209. min_val | -1
  210. max_val | 2147483647
  211. enumvals |
  212. boot_val | -1
  213. reset_val | -1
  214. sourcefile |
  215. sourceline |
  216. pending_restart | f
  217. -[ RECORD 13 ]--+------------------------------------------------------------------------------------------
  218. name | log_autovacuum_min_duration
  219. setting | -1
  220. unit | ms
  221. category | Reporting and Logging / What to Log
  222. short_desc | Sets the minimum execution time above which autovacuum actions will be logged.
  223. extra_desc | Zero prints all actions. -1 turns autovacuum logging off.
  224. context | sighup
  225. vartype | integer
  226. source | default
  227. min_val | -1
  228. max_val | 2147483647
  229. enumvals |
  230. boot_val | -1
  231. reset_val | -1
  232. sourcefile |
  233. sourceline |
  234. pending_restart | f
  235. -[ RECORD 14 ]--+------------------------------------------------------------------------------------------
  236. name | vacuum_cleanup_index_scale_factor
  237. setting | 0.1
  238. unit |
  239. category | Client Connection Defaults / Statement Behavior
  240. short_desc | Number of tuple inserts prior to index cleanup as a fraction of reltuples.
  241. extra_desc |
  242. context | user
  243. vartype | real
  244. source | default
  245. min_val | 0
  246. max_val | 1e+10
  247. enumvals |
  248. boot_val | 0.1
  249. reset_val | 0.1
  250. sourcefile |
  251. sourceline |
  252. pending_restart | f
  253. -[ RECORD 15 ]--+------------------------------------------------------------------------------------------
  254. name | vacuum_cost_delay
  255. setting | 0
  256. unit | ms
  257. category | Resource Usage / Cost-Based Vacuum Delay
  258. short_desc | Vacuum cost delay in milliseconds.
  259. extra_desc |
  260. context | user
  261. vartype | real
  262. source | default
  263. min_val | 0
  264. max_val | 100
  265. enumvals |
  266. boot_val | 0
  267. reset_val | 0
  268. sourcefile |
  269. sourceline |
  270. pending_restart | f
  271. -[ RECORD 16 ]--+------------------------------------------------------------------------------------------
  272. name | vacuum_cost_limit
  273. setting | 200
  274. unit |
  275. category | Resource Usage / Cost-Based Vacuum Delay
  276. short_desc | Vacuum cost amount available before napping.
  277. extra_desc |
  278. context | user
  279. vartype | integer
  280. source | default
  281. min_val | 1
  282. max_val | 10000
  283. enumvals |
  284. boot_val | 200
  285. reset_val | 200
  286. sourcefile |
  287. sourceline |
  288. pending_restart | f
  289. -[ RECORD 17 ]--+------------------------------------------------------------------------------------------
  290. name | vacuum_cost_page_dirty
  291. setting | 20
  292. unit |
  293. category | Resource Usage / Cost-Based Vacuum Delay
  294. short_desc | Vacuum cost for a page dirtied by vacuum.
  295. extra_desc |
  296. context | user
  297. vartype | integer
  298. source | default
  299. min_val | 0
  300. max_val | 10000
  301. enumvals |
  302. boot_val | 20
  303. reset_val | 20
  304. sourcefile |
  305. sourceline |
  306. pending_restart | f
  307. -[ RECORD 18 ]--+------------------------------------------------------------------------------------------
  308. name | vacuum_cost_page_hit
  309. setting | 1
  310. unit |
  311. category | Resource Usage / Cost-Based Vacuum Delay
  312. short_desc | Vacuum cost for a page found in the buffer cache.
  313. extra_desc |
  314. context | user
  315. vartype | integer
  316. source | default
  317. min_val | 0
  318. max_val | 10000
  319. enumvals |
  320. boot_val | 1
  321. reset_val | 1
  322. sourcefile |
  323. sourceline |
  324. pending_restart | f
  325. -[ RECORD 19 ]--+------------------------------------------------------------------------------------------
  326. name | vacuum_cost_page_miss
  327. setting | 10
  328. unit |
  329. category | Resource Usage / Cost-Based Vacuum Delay
  330. short_desc | Vacuum cost for a page not found in the buffer cache.
  331. extra_desc |
  332. context | user
  333. vartype | integer
  334. source | default
  335. min_val | 0
  336. max_val | 10000
  337. enumvals |
  338. boot_val | 10
  339. reset_val | 10
  340. sourcefile |
  341. sourceline |
  342. pending_restart | f
  343. -[ RECORD 20 ]--+------------------------------------------------------------------------------------------
  344. name | vacuum_defer_cleanup_age
  345. setting | 0
  346. unit |
  347. category | Replication / Master Server
  348. short_desc | Number of transactions by which VACUUM and HOT cleanup should be deferred, if any.
  349. extra_desc |
  350. context | sighup
  351. vartype | integer
  352. source | default
  353. min_val | 0
  354. max_val | 1000000
  355. enumvals |
  356. boot_val | 0
  357. reset_val | 0
  358. sourcefile |
  359. sourceline |
  360. pending_restart | f
  361. -[ RECORD 21 ]--+------------------------------------------------------------------------------------------
  362. name | vacuum_freeze_min_age
  363. setting | 50000000
  364. unit |
  365. category | Client Connection Defaults / Statement Behavior
  366. short_desc | Minimum age at which VACUUM should freeze a table row.
  367. extra_desc |
  368. context | user
  369. vartype | integer
  370. source | default
  371. min_val | 0
  372. max_val | 1000000000
  373. enumvals |
  374. boot_val | 50000000
  375. reset_val | 50000000
  376. sourcefile |
  377. sourceline |
  378. pending_restart | f
  379. -[ RECORD 22 ]--+------------------------------------------------------------------------------------------
  380. name | vacuum_freeze_table_age
  381. setting | 150000000
  382. unit |
  383. category | Client Connection Defaults / Statement Behavior
  384. short_desc | Age at which VACUUM should scan whole table to freeze tuples.
  385. extra_desc |
  386. context | user
  387. vartype | integer
  388. source | default
  389. min_val | 0
  390. max_val | 2000000000
  391. enumvals |
  392. boot_val | 150000000
  393. reset_val | 150000000
  394. sourcefile |
  395. sourceline |
  396. pending_restart | f
  397. -[ RECORD 23 ]--+------------------------------------------------------------------------------------------
  398. name | vacuum_multixact_freeze_min_age
  399. setting | 5000000
  400. unit |
  401. category | Client Connection Defaults / Statement Behavior
  402. short_desc | Minimum age at which VACUUM should freeze a MultiXactId in a table row.
  403. extra_desc |
  404. context | user
  405. vartype | integer
  406. source | default
  407. min_val | 0
  408. max_val | 1000000000
  409. enumvals |
  410. boot_val | 5000000
  411. reset_val | 5000000
  412. sourcefile |
  413. sourceline |
  414. pending_restart | f
  415. -[ RECORD 24 ]--+------------------------------------------------------------------------------------------
  416. name | vacuum_multixact_freeze_table_age
  417. setting | 150000000
  418. unit |
  419. category | Client Connection Defaults / Statement Behavior
  420. short_desc | Multixact age at which VACUUM should scan whole table to freeze tuples.
  421. extra_desc |
  422. context | user
  423. vartype | integer
  424. source | default
  425. min_val | 0
  426. max_val | 2000000000
  427. enumvals |
  428. boot_val | 150000000
  429. reset_val | 150000000
  430. sourcefile |
  431. sourceline |
  432. pending_restart | f
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!