forked frompostgres/postgres
- Notifications
You must be signed in to change notification settings - Fork6
Commit9ce346e
committed
Report progress of startup operations that take a long time.
Users sometimes get concerned whe they start the server and itemits a few messages and then doesn't emit any more messages fora long time. Generally, what's happening is either that thesystem is taking a long time to apply WAL, or it's taking along time to reset unlogged relations, or it's taking a longtime to fsync the data directory, but it's not easy to tellwhich is the case.To fix that, add a new 'log_startup_progress_interval' setting,by default 10s. When an operation that is known to be potentiallylong-running takes more than this amount of time, we'll log astatus update each time this interval elapses.To avoid undesirable log chatter, don't log anything about WALreplay when in standby mode.Nitin Jadhav and Robert Haas, reviewed by Amul Sul, BharathRupireddy, Justin Pryzby, Michael Paquier, and Álvaro Herrera.Discussion:https://postgr.es/m/CA+TgmoaHQrgDFOBwgY16XCoMtXxsrVGFB2jNCvb7-ubuEe1MGg@mail.gmail.comDiscussion:https://postgr.es/m/CAMm1aWaHF7VE69572_OLQ+MgpT5RUiUDgF1x5RrtkJBLdpRj3Q@mail.gmail.com1 parent732e667 commit9ce346e
File tree
10 files changed
+181
-3
lines changed- doc/src/sgml
- src
- backend
- access/transam
- postmaster
- storage/file
- utils/misc
- include
- postmaster
- utils
10 files changed
+181
-3
lines changedLines changed: 24 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
6549 | 6549 |
| |
6550 | 6550 |
| |
6551 | 6551 |
| |
| 6552 | + | |
| 6553 | + | |
| 6554 | + | |
| 6555 | + | |
| 6556 | + | |
| 6557 | + | |
| 6558 | + | |
| 6559 | + | |
| 6560 | + | |
| 6561 | + | |
| 6562 | + | |
| 6563 | + | |
| 6564 | + | |
| 6565 | + | |
| 6566 | + | |
| 6567 | + | |
| 6568 | + | |
| 6569 | + | |
| 6570 | + | |
| 6571 | + | |
| 6572 | + | |
| 6573 | + | |
| 6574 | + | |
| 6575 | + | |
6552 | 6576 |
| |
6553 | 6577 |
| |
6554 | 6578 |
| |
|
Lines changed: 14 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
79 | 79 |
| |
80 | 80 |
| |
81 | 81 |
| |
| 82 | + | |
82 | 83 |
| |
83 | 84 |
| |
84 | 85 |
| |
| |||
6718 | 6719 |
| |
6719 | 6720 |
| |
6720 | 6721 |
| |
| 6722 | + | |
| 6723 | + | |
| 6724 | + | |
| 6725 | + | |
| 6726 | + | |
6721 | 6727 |
| |
6722 | 6728 |
| |
6723 | 6729 |
| |
| |||
7491 | 7497 |
| |
7492 | 7498 |
| |
7493 | 7499 |
| |
| 7500 | + | |
| 7501 | + | |
| 7502 | + | |
| 7503 | + | |
7494 | 7504 |
| |
7495 | 7505 |
| |
7496 | 7506 |
| |
7497 | 7507 |
| |
7498 | 7508 |
| |
7499 | 7509 |
| |
7500 | 7510 |
| |
| 7511 | + | |
| 7512 | + | |
| 7513 | + | |
| 7514 | + | |
7501 | 7515 |
| |
7502 | 7516 |
| |
7503 | 7517 |
| |
|
Lines changed: 4 additions & 2 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
10 | 10 |
| |
11 | 11 |
| |
12 | 12 |
| |
13 |
| - | |
| 13 | + | |
| 14 | + | |
14 | 15 |
| |
15 | 16 |
| |
16 | 17 |
| |
17 | 18 |
| |
18 | 19 |
| |
19 |
| - | |
| 20 | + | |
| 21 | + | |
20 | 22 |
| |
21 | 23 |
| |
22 | 24 |
| |
|
Lines changed: 71 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
59 | 59 |
| |
60 | 60 |
| |
61 | 61 |
| |
| 62 | + | |
| 63 | + | |
| 64 | + | |
| 65 | + | |
| 66 | + | |
| 67 | + | |
| 68 | + | |
| 69 | + | |
| 70 | + | |
| 71 | + | |
| 72 | + | |
| 73 | + | |
| 74 | + | |
| 75 | + | |
| 76 | + | |
| 77 | + | |
62 | 78 |
| |
63 | 79 |
| |
64 | 80 |
| |
| |||
282 | 298 |
| |
283 | 299 |
| |
284 | 300 |
| |
| 301 | + | |
| 302 | + | |
| 303 | + | |
| 304 | + | |
| 305 | + | |
| 306 | + | |
| 307 | + | |
| 308 | + | |
| 309 | + | |
| 310 | + | |
| 311 | + | |
| 312 | + | |
| 313 | + | |
| 314 | + | |
| 315 | + | |
| 316 | + | |
| 317 | + | |
| 318 | + | |
| 319 | + | |
| 320 | + | |
| 321 | + | |
| 322 | + | |
| 323 | + | |
| 324 | + | |
| 325 | + | |
| 326 | + | |
| 327 | + | |
| 328 | + | |
| 329 | + | |
| 330 | + | |
| 331 | + | |
| 332 | + | |
| 333 | + | |
| 334 | + | |
| 335 | + | |
| 336 | + | |
| 337 | + | |
| 338 | + | |
| 339 | + | |
| 340 | + | |
| 341 | + | |
| 342 | + | |
| 343 | + | |
| 344 | + | |
| 345 | + | |
| 346 | + | |
| 347 | + | |
| 348 | + | |
| 349 | + | |
| 350 | + | |
| 351 | + | |
| 352 | + | |
| 353 | + | |
| 354 | + | |
| 355 | + |
Lines changed: 20 additions & 1 deletion
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
96 | 96 |
| |
97 | 97 |
| |
98 | 98 |
| |
| 99 | + | |
99 | 100 |
| |
100 | 101 |
| |
101 | 102 |
| |
| |||
3381 | 3382 |
| |
3382 | 3383 |
| |
3383 | 3384 |
| |
| 3385 | + | |
| 3386 | + | |
| 3387 | + | |
3384 | 3388 |
| |
3385 | 3389 |
| |
3386 | 3390 |
| |
| |||
3465 | 3469 |
| |
3466 | 3470 |
| |
3467 | 3471 |
| |
| 3472 | + | |
| 3473 | + | |
| 3474 | + | |
3468 | 3475 |
| |
3469 | 3476 |
| |
3470 | 3477 |
| |
| |||
3487 | 3494 |
| |
3488 | 3495 |
| |
3489 | 3496 |
| |
| 3497 | + | |
| 3498 | + | |
| 3499 | + | |
| 3500 | + | |
3490 | 3501 |
| |
3491 | 3502 |
| |
3492 | 3503 |
| |
3493 | 3504 |
| |
3494 | 3505 |
| |
3495 |
| - | |
3496 | 3506 |
| |
3497 | 3507 |
| |
3498 | 3508 |
| |
3499 | 3509 |
| |
3500 | 3510 |
| |
3501 | 3511 |
| |
| 3512 | + | |
| 3513 | + | |
| 3514 | + | |
3502 | 3515 |
| |
3503 | 3516 |
| |
3504 | 3517 |
| |
| |||
3601 | 3614 |
| |
3602 | 3615 |
| |
3603 | 3616 |
| |
| 3617 | + | |
| 3618 | + | |
| 3619 | + | |
3604 | 3620 |
| |
3605 | 3621 |
| |
3606 | 3622 |
| |
| |||
3630 | 3646 |
| |
3631 | 3647 |
| |
3632 | 3648 |
| |
| 3649 | + | |
| 3650 | + | |
| 3651 | + | |
3633 | 3652 |
| |
3634 | 3653 |
| |
3635 | 3654 |
| |
|
Lines changed: 12 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
17 | 17 |
| |
18 | 18 |
| |
19 | 19 |
| |
| 20 | + | |
20 | 21 |
| |
21 | 22 |
| |
22 | 23 |
| |
| |||
65 | 66 |
| |
66 | 67 |
| |
67 | 68 |
| |
| 69 | + | |
| 70 | + | |
| 71 | + | |
68 | 72 |
| |
69 | 73 |
| |
70 | 74 |
| |
| |||
136 | 140 |
| |
137 | 141 |
| |
138 | 142 |
| |
| 143 | + | |
| 144 | + | |
| 145 | + | |
| 146 | + | |
| 147 | + | |
| 148 | + | |
| 149 | + | |
| 150 | + | |
139 | 151 |
| |
140 | 152 |
| |
141 | 153 |
| |
|
Lines changed: 13 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
71 | 71 |
| |
72 | 72 |
| |
73 | 73 |
| |
| 74 | + | |
74 | 75 |
| |
75 | 76 |
| |
76 | 77 |
| |
| |||
3570 | 3571 |
| |
3571 | 3572 |
| |
3572 | 3573 |
| |
| 3574 | + | |
| 3575 | + | |
| 3576 | + | |
| 3577 | + | |
| 3578 | + | |
| 3579 | + | |
| 3580 | + | |
| 3581 | + | |
| 3582 | + | |
| 3583 | + | |
| 3584 | + | |
| 3585 | + | |
3573 | 3586 |
| |
3574 | 3587 |
| |
3575 | 3588 |
| |
|
Lines changed: 5 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
523 | 523 |
| |
524 | 524 |
| |
525 | 525 |
| |
| 526 | + | |
| 527 | + | |
| 528 | + | |
| 529 | + | |
| 530 | + | |
526 | 531 |
| |
527 | 532 |
| |
528 | 533 |
| |
|
Lines changed: 17 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
12 | 12 |
| |
13 | 13 |
| |
14 | 14 |
| |
| 15 | + | |
| 16 | + | |
| 17 | + | |
| 18 | + | |
| 19 | + | |
| 20 | + | |
| 21 | + | |
| 22 | + | |
| 23 | + | |
| 24 | + | |
| 25 | + | |
| 26 | + | |
| 27 | + | |
15 | 28 |
| |
16 | 29 |
| |
17 | 30 |
| |
18 | 31 |
| |
19 | 32 |
| |
20 | 33 |
| |
21 | 34 |
| |
| 35 | + | |
| 36 | + | |
| 37 | + | |
| 38 | + | |
22 | 39 |
|
Lines changed: 1 addition & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
33 | 33 |
| |
34 | 34 |
| |
35 | 35 |
| |
| 36 | + | |
36 | 37 |
| |
37 | 38 |
| |
38 | 39 |
| |
|
0 commit comments
Comments
(0)