From 520fcbfe4e42e4d953c5515638fcdd107ab6bab5 Mon Sep 17 00:00:00 2001 From: sherlockcpp <63178771+sherlockcpp@users.noreply.github.com> Date: Sun, 5 Apr 2020 21:18:31 +0800 Subject: [PATCH] Add description of *ScanRegExp hints in the document. English version of hint list is missing regexp versions of scan hints. Add them. --- doc/hint_list.html | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/doc/hint_list.html b/doc/hint_list.html index 07bcbc9..19cf411 100755 --- a/doc/hint_list.html +++ b/doc/hint_list.html @@ -26,7 +26,7 @@ -Scan method +Scan method SeqScan(table) Forces sequential scan on the table TidScan(table) @@ -37,6 +37,8 @@ Forces index only scan on the table. Rstricts to specfied indexes if any. Index scan may be used if index only scan is not available. Available for PostgreSQL 9.2 and later. BitmapScan(table[ index...]) Forces bitmap scan on the table. Restoricts to specfied indexes if any. +IndexScanRegexp(table[ POSIX Regexp...])
IndexOnlyScanRegexp(table[ POSIX Regexp...])
BitmapScanRegexp(table[ POSIX Regexp...]) + Forces index scan or index only scan (For PostgreSQL 9.2 and later) or bitmap scan on the table. Restricts to indexes that matches the specified POSIX regular expression pattern NoSeqScan(table) Forces not to do sequential scan on the table. NoTidScan(table) -- 2.11.0