aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorAlvaro Herrera <alvherre@alvh.no-ip.org>2018-03-14 11:53:56 -0300
committerAlvaro Herrera <alvherre@alvh.no-ip.org>2018-03-14 11:59:40 -0300
commit484a4a08abe316212d67d84bb8705b06e44f862d (patch)
treec1f2a31f60ac9609097a5ee765d6ca2ce70cfa30 /doc/src
parent97d18ce27da47de2de60de8dfca8e364e71ff6fe (diff)
downloadpostgresql-484a4a08abe316212d67d84bb8705b06e44f862d.tar.gz
postgresql-484a4a08abe316212d67d84bb8705b06e44f862d.zip
Log when a BRIN autosummarization request fails
Autovacuum's 'workitem' request queue is of limited size, so requests can fail if they arrive more quickly than autovacuum can process them. Emit a log message when this happens, to provide better visibility of this. Backpatch to 10. While this represents an API change for AutoVacuumRequestWork, that function is not yet prepared to deal with external modules calling it, so there doesn't seem to be any risk (other than log spam, that is.) Author: Masahiko Sawada Reviewed-by: Fabrízio Mello, Ildar Musin, Álvaro Herrera Discussion: https://postgr.es/m/CAD21AoB1HrQhp6_4rTyHN5kWEJCEsG8YzsjZNt-ctoXSn5Uisw@mail.gmail.com
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/brin.sgml12
1 files changed, 12 insertions, 0 deletions
diff --git a/doc/src/sgml/brin.sgml b/doc/src/sgml/brin.sgml
index 23c0e05ed6c..f02e061bc1c 100644
--- a/doc/src/sgml/brin.sgml
+++ b/doc/src/sgml/brin.sgml
@@ -86,6 +86,18 @@
representation because the existing values have changed.
</para>
+ <para>
+ When autosummarization is enabled, each time a page range is filled a
+ request is sent to autovacuum for it to execute a targeted summarization
+ for that range, to be fulfilled at the end of the next worker run on the
+ same database. If the request queue is full, the request is not recorded
+ and a message is sent to the server log:
+<screen>
+LOG: request for BRIN range summarization for index "brin_wi_idx" page 128 was not recorded
+</screen>
+ When this happens, the range will be summarized normally during the next
+ regular vacuum of the table.
+ </para>
</sect2>
</sect1>