|
37 | 37 | (libicu) instead of system specific. |
38 | 38 | </para> |
39 | 39 | </listitem> |
| 40 | + <listitem> |
| 41 | + <para> |
| 42 | + Speedup of two-phase commit |
| 43 | + </para> |
| 44 | + </listitem> |
40 | 45 | <listitem> |
41 | 46 | <para> |
42 | 47 | Contrib module pg_trgm supports substring searches. |
@@ -157,7 +162,39 @@ commit [90e649a7afac8c76] Thu Dec 31 09:52:30 2015 +0300 |
157 | 162 | when modifying state, shared between processes. |
158 | 163 | </para> |
159 | 164 | </listitem> |
| 165 | + |
160 | 166 | </itemizedlist> |
| 167 | + </listitem> |
| 168 | + <listitem> |
| 169 | + <!-- Commit b1a1741f3a7eecae by Stas Kelvich --> |
| 170 | + <para> |
| 171 | + Speedup two phase commit by skipping two phase state files in normal path |
| 172 | + 2PC state info is written only to WAL at PREPARE, then read back |
| 173 | + from WAL at |
| 174 | + COMMIT PREPARED/ABORT PREPARED. Prepared transactions that live |
| 175 | + past one bufmgr |
| 176 | + checkpoint cycle will be written to disk in the same form as |
| 177 | + previously. Crash |
| 178 | + recovery path is not altered. Measured performance gains of |
| 179 | + 50-100% for short |
| 180 | + 2PC transactions by completely avoiding writing files and |
| 181 | + fsyncing. Other |
| 182 | + optimizations still available, further patches in related areas |
| 183 | + expected. |
| 184 | + </para> |
| 185 | + <para> |
| 186 | + Stas Kelvich and heavily edited by Simon Riggs. |
| 187 | + </para> |
| 188 | + <para> |
| 189 | + Based upon earlier ideas and patches by Michael Paquier and |
| 190 | + Heikki Linnakangas, |
| 191 | + a concrete example of how Postgres-XC has fed back ideas into |
| 192 | + PostgreSQL. |
| 193 | + </para> |
| 194 | + <para> |
| 195 | + Reviewed by Michael Paquier, Jeff Janes and Andres Freund |
| 196 | + Performance testing by Jesper Pedersen |
| 197 | + </para> |
161 | 198 | </listitem> |
162 | 199 | </itemizedlist> |
163 | 200 |
|
|