Kouhei Sutou
null+****@clear*****
Thu Nov 3 18:17:37 JST 2016
Kouhei Sutou 2016-11-03 18:17:37 +0900 (Thu, 03 Nov 2016) New Revision: d2ce40a4514e995a4b87f952cc4cb6396e206eef https://github.com/pgroonga/pgroonga.github.io/commit/d2ce40a4514e995a4b87f952cc4cb6396e206eef Message: Document pgroonga.enable_wal Added files: reference/parameters/enable_wal.md Modified files: reference/index.md Modified: reference/index.md (+2 -0) =================================================================== --- reference/index.md 2016-11-03 17:48:33 +0900 (578a23d) +++ reference/index.md 2016-11-03 18:17:37 +0900 (7ddd16c) @@ -100,6 +100,8 @@ If you use them, you need to use [incompatible case steps](../upgrade/#incompati * [`pgroonga.lock_timeout` parameter](parameters/lock_timeout.html) + * [`pgroonga.enable_wal` parameter](parameters/enable_wal.html) + ## Tuning Normally, you don't need to tune PGroonga because PGroonga works well by default. Added: reference/parameters/enable_wal.md (+45 -0) 100644 =================================================================== --- /dev/null +++ reference/parameters/enable_wal.md 2016-11-03 18:17:37 +0900 (08284ed) @@ -0,0 +1,45 @@ +--- +title: "pgroonga.enable_wal parameter" +--- + +# `pgroonga.enable_wal` parameter + +Since 1.1.6. + +It's still an experimental feature. If you find a problem, please [report it](https://github.com/pgroonga/pgroonga/issues/new). + +## Summary + +`pgroonga.enable_wal` parameter controls whether [WAL](https://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/runtime-config-wal.html) is enabled or not. + +PGroonga supports WAL with PostgreSQL 9.6 or later. `pgroonga.enable_wal` parameter is meaningless with PostgreSQL 9.5 or earlier. + +If you enable WAL support, you can use PostgreSQL's streaming replication feature. See [replication](../replication.html) for details. + +If you enable WAL support, update performance will be decreased because some extra disk writes are needed. + +The default value is `off`. It means that PGroonga doesn't generate WAL even when you're using PostgreSQL 9.6 or later. It'll be `on` by default when this feature is marked as stable. + +## Syntax + +In SQL: + +```sql +SET pgroonga.enable_wal = boolean; +``` + +In `postgresql.conf`: + +```text +pgroonga.enable_wal = boolean +``` + +`boolean` is a boolean value. There are some literals for boolean such as `on`, `off`, `true`, `false`, `yes` and `no`. + +## Usage + +Here is an example to enable WAL support: + +```sql +SET pgroonga.enable_wal = on; +``` -------------- next part -------------- HTML����������������������������...Download