X-Git-Url: http://git.osdn.net/view?a=blobdiff_plain;f=html%2Fpg_bigm_en-1-2.html;h=c33559ef5cc7cfab02a1fb79ee1fc2b2977f92da;hb=4f64cc6ee7433890971de10d3ef97a0e9d26e785;hp=08934a21e08671e81bfc7b4d9c197e9805b10bb2;hpb=546b14d57c4f423730f7cbe9f191e00c223ff9e5;p=pgbigm%2Fpg_bigm.git diff --git a/html/pg_bigm_en-1-2.html b/html/pg_bigm_en-1-2.html index 08934a2..c33559e 100644 --- a/html/pg_bigm_en-1-2.html +++ b/html/pg_bigm_en-1-2.html @@ -74,6 +74,9 @@ For example, x.y is 1.1 and YYYYMMDD is 20131122 if the file of the version 1.1
$ initdb -D $PGDATA --locale=C --encoding=UTF8 +$ vi $PGDATA/postgresql.conf +shared_preload_libraries = 'pg_bigm' + $ pg_ctl -D $PGDATA start $ psql -d <database name> =# CREATE EXTENSION pg_bigm; @@ -169,7 +175,11 @@ $ psql -d <database name>
Delete the following pg_bigm related settings from postgresql.conf.
pg_gin_pending_cleanup is a function that cleans up the pending list of GIN index (argument #1) by moving tuples in it to the main GIN data structure in bulk.
+ ++Note that the cleanup does not happen and the return value #1 is 0 if the argument #1 is the GIN index built with FASTUPDATE option disabled because it doesn't have a pending list. +Please see GIN Fast Update Technique for details of the pending list and FASTUPDATE option. +
++If the argument #2 is TRUE, this function uses the cost-based VACUUM delay to reduce the performance impact of the pending list cleanup. +If the argument #2 is FALSE or not supplied, this function cleans up the pending list as quickly as possible. +
++Only superusers and the owner of the GIN index can execute this function. +This function cannot be executed during recovery. +
+ ++=# SELECT pg_gin_pending_cleanup('pg_tools_idx'); + pg_gin_pending_cleanup +------------------------ + 1 +(1 row) ++
pg_bigm.last_update is a parameter that reports the last updated date of the pg_bigm module. This parameter is read-only. You cannot change the value of this parameter at all.
@@ -499,12 +540,13 @@ ERROR: out of memory