diff options
| author | Peter Geoghegan <pg@bowt.ie> | 2018-08-08 12:56:28 -0700 |
|---|---|---|
| committer | Peter Geoghegan <pg@bowt.ie> | 2018-08-08 12:56:28 -0700 |
| commit | f85537a88dda4aa015f9a1b4a43189395d36b328 (patch) | |
| tree | 1afe820f8112193be05a1ad63cede7f053404d20 | |
| parent | 2332020d6d1912bff4c03a8c2b37ad1c8b184281 (diff) | |
Doc: Correct description of amcheck example query.
The amcheck documentation incorrectly claimed that its example query
verifies every catalog index in the database. In fact, the query only
verifies the 10 largest indexes (as determined by pg_class.relpages).
Adjust the description accordingly.
Backpatch: 10-, where contrib/amcheck was introduced.
| -rw-r--r-- | doc/src/sgml/amcheck.sgml | 18 |
1 files changed, 8 insertions, 10 deletions
diff --git a/doc/src/sgml/amcheck.sgml b/doc/src/sgml/amcheck.sgml index dd71dbd679b..fc0ade5b801 100644 --- a/doc/src/sgml/amcheck.sgml +++ b/doc/src/sgml/amcheck.sgml @@ -35,7 +35,7 @@ functions. </para> <para> - <filename>amcheck</> functions may be used only by superusers. + <filename>amcheck</> functions may only be used by superusers. </para> <sect2> @@ -81,13 +81,12 @@ ORDER BY c.relpages DESC LIMIT 10; | pg_amop_fam_strat_index | 5 (10 rows) </screen> - This example shows a session that performs verification of every - catalog index in the database <quote>test</>. Details of just - the 10 largest indexes verified are displayed. Since no error - is raised, all indexes tested appear to be logically consistent. - Naturally, this query could easily be changed to call - <function>bt_index_check</function> for every index in the - database where verification is supported. + This example shows a session that performs verification of the + 10 largest catalog indexes in the database <quote>test</>. + Since no error is raised, all indexes tested appear to be + logically consistent. Naturally, this query could easily be + changed to call <function>bt_index_check</function> for every + index in the database where verification is supported. </para> <para> <function>bt_index_check</function> acquires an <literal>AccessShareLock</> @@ -230,8 +229,7 @@ ORDER BY c.relpages DESC LIMIT 10; </listitem> <listitem> <para> - Corruption caused by faulty RAM, and the broader memory subsystem - and operating system. + Corruption caused by faulty RAM, or the broader memory subsystem. </para> <para> <productname>PostgreSQL</> does not protect against correctable |