- Notifications
You must be signed in to change notification settings - Fork5
Commit3134d88
committed
Add new buffers_backend_fsync field to pg_stat_bgwriter.
This new field counts the number of times that a backend which writes abuffer out to the OS must also fsync() it. This happens when thebgwriter fsync request queue is full, and is generally detrimental toperformance, so it's good to know when it's happening. Along the way,log a new message at level DEBUG1 whenever we fail to hand off an fsync,so that the problem can also be seen in examination of log files(if the logging level is cranked up high enough).Greg Smith, with minor tweaks by me.1 parent8d70ed8 commit3134d88
File tree
10 files changed
+34
-8
lines changed- doc/src/sgml
- src
- backend
- catalog
- postmaster
- storage/smgr
- utils/adt
- include
- catalog
- test/regress/expected
10 files changed
+34
-8
lines changedLines changed: 4 additions & 2 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
264 | 264 |
| |
265 | 265 |
| |
266 | 266 |
| |
267 |
| - | |
268 |
| - | |
| 267 | + | |
| 268 | + | |
| 269 | + | |
| 270 | + | |
269 | 271 |
| |
270 | 272 |
| |
271 | 273 |
| |
|
Lines changed: 1 addition & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
537 | 537 |
| |
538 | 538 |
| |
539 | 539 |
| |
| 540 | + | |
540 | 541 |
| |
541 | 542 |
| |
542 | 543 |
| |
|
Lines changed: 12 additions & 4 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
102 | 102 |
| |
103 | 103 |
| |
104 | 104 |
| |
105 |
| - | |
| 105 | + | |
| 106 | + | |
| 107 | + | |
106 | 108 |
| |
107 | 109 |
| |
108 | 110 |
| |
109 | 111 |
| |
110 |
| - | |
111 |
| - | |
| 112 | + | |
| 113 | + | |
112 | 114 |
| |
113 | 115 |
| |
114 | 116 |
| |
| |||
132 | 134 |
| |
133 | 135 |
| |
134 | 136 |
| |
| 137 | + | |
135 | 138 |
| |
136 | 139 |
| |
137 | 140 |
| |
| |||
1084 | 1087 |
| |
1085 | 1088 |
| |
1086 | 1089 |
| |
1087 |
| - | |
| 1090 | + | |
1088 | 1091 |
| |
1089 | 1092 |
| |
1090 | 1093 |
| |
1091 | 1094 |
| |
1092 | 1095 |
| |
| 1096 | + | |
| 1097 | + | |
1093 | 1098 |
| |
1094 | 1099 |
| |
1095 | 1100 |
| |
| |||
1137 | 1142 |
| |
1138 | 1143 |
| |
1139 | 1144 |
| |
| 1145 | + | |
| 1146 | + | |
1140 | 1147 |
| |
| 1148 | + | |
1141 | 1149 |
| |
1142 | 1150 |
| |
1143 | 1151 |
| |
|
Lines changed: 1 addition & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
4188 | 4188 |
| |
4189 | 4189 |
| |
4190 | 4190 |
| |
| 4191 | + | |
4191 | 4192 |
| |
4192 | 4193 |
| |
4193 | 4194 |
| |
|
Lines changed: 3 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1224 | 1224 |
| |
1225 | 1225 |
| |
1226 | 1226 |
| |
| 1227 | + | |
| 1228 | + | |
| 1229 | + | |
1227 | 1230 |
| |
1228 | 1231 |
| |
1229 | 1232 |
| |
|
Lines changed: 7 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
78 | 78 |
| |
79 | 79 |
| |
80 | 80 |
| |
| 81 | + | |
81 | 82 |
| |
82 | 83 |
| |
83 | 84 |
| |
| |||
1164 | 1165 |
| |
1165 | 1166 |
| |
1166 | 1167 |
| |
| 1168 | + | |
| 1169 | + | |
| 1170 | + | |
| 1171 | + | |
| 1172 | + | |
| 1173 | + | |
1167 | 1174 |
| |
1168 | 1175 |
| |
1169 | 1176 |
| |
|
Lines changed: 1 addition & 1 deletion
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
53 | 53 |
| |
54 | 54 |
| |
55 | 55 |
| |
56 |
| - | |
| 56 | + | |
57 | 57 |
| |
58 | 58 |
|
Lines changed: 2 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
3117 | 3117 |
| |
3118 | 3118 |
| |
3119 | 3119 |
| |
| 3120 | + | |
| 3121 | + | |
3120 | 3122 |
| |
3121 | 3123 |
| |
3122 | 3124 |
| |
|
Lines changed: 2 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
360 | 360 |
| |
361 | 361 |
| |
362 | 362 |
| |
| 363 | + | |
363 | 364 |
| |
364 | 365 |
| |
365 | 366 |
| |
| |||
562 | 563 |
| |
563 | 564 |
| |
564 | 565 |
| |
| 566 | + | |
565 | 567 |
| |
566 | 568 |
| |
567 | 569 |
| |
|
Lines changed: 1 addition & 1 deletion
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1293 | 1293 |
| |
1294 | 1294 |
| |
1295 | 1295 |
| |
1296 |
| - | |
| 1296 | + | |
1297 | 1297 |
| |
1298 | 1298 |
| |
1299 | 1299 |
| |
|
0 commit comments
Comments
(0)