$ sudo su - postgres
$ psql
postgres=# select name, setting, context from pg_settings where name like 'autovacuum%';
postgres=# select name, setting, context from pg_settings where name like 'online_analyze.%';
$ sudo nano /etc/postgresql/10/main/postgresql.conf
$ cat /etc/postgresql/10/main/postgresql.conf | grep -v '#' | grep -v "^$"
alter system set online_analyze.enable = off;
select pg_reload_conf()
Комментариев нет:
Отправить комментарий