|
72 | 72 |
|
73 | 73 | <para> |
74 | 74 | Users should now use hstore(text, text). Since |
75 | | - <productname>PostgreSQL</productname> 9.0,we have emitted a |
76 | | -warning message when an operator named => is created because |
| 75 | + <productname>PostgreSQL</productname> 9.0,a warning message is |
| 76 | +emitted when an operator named => is created because |
77 | 77 | the <acronym>SQL</acronym> standard reserves that token for |
78 | 78 | another use. |
79 | 79 | </para> |
|
460 | 460 | </para> |
461 | 461 | </listitem> |
462 | 462 |
|
463 | | - <listitem> |
464 | | - <para> |
465 | | - Make the visibility map crash-safe (Robert Haas, Noah Misch) |
466 | | - </para> |
467 | | - |
468 | | - <para> |
469 | | - This helps vacuum be more efficient, and is necessary for |
470 | | - index-only scans. |
471 | | - </para> |
472 | | - </listitem> |
473 | | - |
474 | 463 | <listitem> |
475 | 464 | <para> |
476 | 465 | Improve GiST box and point index performance by producing better |
|
545 | 534 |
|
546 | 535 | <listitem> |
547 | 536 | <para> |
548 | | - Improve performance of <acronym>WAL</acronym> writes when multiple |
549 | | - transactions commit at the same time (Peter Geoghegan, Simon Riggs, |
550 | | - Heikki Linnakangas) |
| 537 | + Improve performance of <acronym>WAL</acronym> writes using group |
| 538 | + commit (Peter Geoghegan, Simon Riggs, Heikki Linnakangas) |
| 539 | + </para> |
| 540 | + </listitem> |
| 541 | + |
| 542 | + <listitem> |
| 543 | + <para> |
| 544 | + Make the visibility map crash-safe (Robert Haas, Noah Misch) |
| 545 | + </para> |
| 546 | + |
| 547 | + <para> |
| 548 | + This helps vacuum be more efficient, and is necessary for |
| 549 | + index-only scans. |
551 | 550 | </para> |
552 | 551 | </listitem> |
553 | 552 |
|
|
608 | 607 | <listitem> |
609 | 608 | <para> |
610 | 609 | Allow the <link linkend="pg-stat-bgwriter-view">bgwriter</link>, |
611 | | - <link linkend="guc-wal-writer-delay">walwriter</link>,and<link |
612 | | - linkend="monitoring-stats">statistics collector</link> to sleep |
613 | | - more efficiently during periods of inactivity (Peter Geoghegan, |
614 | | - Heikki Linnakangas, Tom Lane) |
| 610 | + <link linkend="guc-wal-writer-delay">walwriter</link>, <link |
| 611 | + linkend="monitoring-stats">statistics collector</link>, archiver, |
| 612 | +and checkpointer to sleepmore efficiently during periods of |
| 613 | +inactivity (Peter Geoghegan,Heikki Linnakangas, Tom Lane) |
615 | 614 | </para> |
616 | 615 |
|
617 | 616 | <para> |
618 | | - This reduces <acronym>CPU</acronym> wake-ups. |
| 617 | + This reduces <acronym>CPU</acronym> wake-ups, which dramatically |
| 618 | + reduces power consumption on idle servers. |
619 | 619 | </para> |
620 | 620 | </listitem> |
621 | 621 |
|
|
2071 | 2071 | </para> |
2072 | 2072 |
|
2073 | 2073 | <para> |
2074 | | - We already supported minor-version-specific <filename>.psqlrc</> |
| 2074 | + <application>psql</> already supported minor-version-specific |
| 2075 | + <filename>.psqlrc</> |
2075 | 2076 | files. |
2076 | 2077 | </para> |
2077 | 2078 | </listitem> |
|
2745 | 2746 |
|
2746 | 2747 | <para> |
2747 | 2748 | Specifically, only lock the old cluster if link mode is used, |
2748 | | - and do it right afterwe restorethe schema. |
| 2749 | + and do it right after the schema is restored. |
2749 | 2750 | </para> |
2750 | 2751 | </listitem> |
2751 | 2752 |
|
|