From: Justin Pryzby Date: Mon, 26 Oct 2020 16:26:07 -0500 Subject: [PATCH 2/3] from stephen --- doc/src/sgml/func.sgml | 14 +++++--------- doc/src/sgml/gin.sgml | 19 ++++++++----------- 2 files changed, 13 insertions(+), 20 deletions(-) diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 5c27cc2b13..1ea88a8c67 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -2309,15 +2309,11 @@ repeat('Pg', 4) PgPgPgPg - Before PostgreSQL 8.3, these functions would - silently accept values of several non-string data types as well, due to - the presence of implicit coercions from those data types to - text. Those coercions have been removed because they frequently - caused surprising behaviors. However, the string concatenation operator - (||) still accepts non-string input, so long as at least one - input is of a string type, as shown in . For other cases, insert an explicit - coercion to text if you need to duplicate the previous behavior. + The string concatenation operator (||) will accept + non-string input, so long as at least one input is of string type, as shown + in . For other cases, inserting an + explicit coercion to text can be used to have non-string input + accepted. diff --git a/doc/src/sgml/gin.sgml b/doc/src/sgml/gin.sgml index 67754f52f6..cfbb1e0761 100644 --- a/doc/src/sgml/gin.sgml +++ b/doc/src/sgml/gin.sgml @@ -569,17 +569,14 @@ Create vs. insert - Insertion into a GIN index can be slow - due to the likelihood of many keys being inserted for each item. - So, for bulk insertions into a table it is advisable to drop the GIN - index and recreate it after finishing bulk insertion. - - - - As of PostgreSQL 8.4, this advice is less - necessary since delayed indexing is used (see for details). But for very large updates - it may still be best to drop and recreate the index. + Building a GIN index after all of the data has been + loaded will typically be faster than creating the index and then filling + it. There may also be cases where, for a sufficiently large update, + dropping the GIN index, then performing the update, + and then recreating the index will be faster than a routine update, + however, one should review the delayed indexing technique used for + GIN (see for + details) and the options it provides. -- 2.17.0 --1ppIqr1kl39GnwQx Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="0003-Remove-references-to-old-server-behavior.patch"