forked frompostgres/postgres
- Notifications
You must be signed in to change notification settings - Fork6
Commit53f1ca5
committed
Allow hint bits to be set sooner for temporary and unlogged tables.
We need not wait until the commit record is durably on disk, becausein the event of a crash the page we're updating with hint bits willbe gone anyway. Per off-list report from Heikki Linnakangas, thiscan significantly degrade the performance of unlogged tables; I wasable to show a 2x speedup from this patch on a pgbench run with scalefactor 15. In practice, this will mostly help small, heavily updatedtables, because on larger tables you're unlikely to run into the samerow again before the commit record makes it out to disk.1 parentb6335a3 commit53f1ca5
3 files changed
+38
-5
lines changedLines changed: 29 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1929 | 1929 |
| |
1930 | 1930 |
| |
1931 | 1931 |
| |
| 1932 | + | |
| 1933 | + | |
| 1934 | + | |
| 1935 | + | |
| 1936 | + | |
| 1937 | + | |
| 1938 | + | |
| 1939 | + | |
| 1940 | + | |
| 1941 | + | |
| 1942 | + | |
| 1943 | + | |
| 1944 | + | |
| 1945 | + | |
| 1946 | + | |
| 1947 | + | |
| 1948 | + | |
| 1949 | + | |
| 1950 | + | |
| 1951 | + | |
| 1952 | + | |
| 1953 | + | |
| 1954 | + | |
| 1955 | + | |
| 1956 | + | |
| 1957 | + | |
| 1958 | + | |
| 1959 | + | |
| 1960 | + | |
1932 | 1961 |
| |
1933 | 1962 |
| |
1934 | 1963 |
| |
|
Lines changed: 7 additions & 5 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
82 | 82 |
| |
83 | 83 |
| |
84 | 84 |
| |
85 |
| - | |
86 |
| - | |
87 |
| - | |
88 |
| - | |
| 85 | + | |
| 86 | + | |
| 87 | + | |
| 88 | + | |
| 89 | + | |
| 90 | + | |
89 | 91 |
| |
90 | 92 |
| |
91 | 93 |
| |
| |||
113 | 115 |
| |
114 | 116 |
| |
115 | 117 |
| |
116 |
| - | |
| 118 | + | |
117 | 119 |
| |
118 | 120 |
| |
119 | 121 |
| |
|
Lines changed: 2 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
192 | 192 |
| |
193 | 193 |
| |
194 | 194 |
| |
| 195 | + | |
| 196 | + | |
195 | 197 |
| |
196 | 198 |
| |
197 | 199 |
| |
|
0 commit comments
Comments
(0)