Re: Configure Postgres From SQL
От
Adrian Klaver
Тема
Re: Configure Postgres From SQL
Дата
Msg-id
201007120655.51216.adrian.klaver@gmail.com
Ответ на
Configure Postgres From SQL (Tom Wilcox)
Список
Дерево обсуждения
Configure Postgres From SQL Tom Wilcox <hungrytom@gmail.com>
Re: Configure Postgres From SQL Adrian Klaver <adrian.klaver@gmail.com>
Re: Configure Postgres From SQL Andres Freund <andres@anarazel.de>
Re: Configure Postgres From SQL Greg Smith <greg@2ndquadrant.com>
Re: Configure Postgres From SQL tv@fuzzy.cz
Re: Configure Postgres From SQL Thom Brown <thombrown@gmail.com>
On Monday 12 July 2010 6:29:14 am Tom Wilcox wrote:
> Hi,
>
> Is it possible to configure postgres from SQL?
Yes to a degree, see here:
http://www.postgresql.org/docs/8.4/interactive/functions-admin.html
>
> I am interested in turning off fsync for a set of queries (that take
> ages to run) and then turn fsync back on again afterwards.
This is one of the options not covered by above.
See here:
http://www.postgresql.org/docs/8.4/interactive/runtime-config-wal.html
Example:
test=# SELECT current_setting('fsync');
current_setting
-----------------
on
(1 row)
test=# SELECT set_config('fsync','off',false);
ERROR: parameter "fsync" cannot be changed now
>
> Cheers,
> Tom
--
Adrian Klaver
adrian.klaver@gmail.com
В списке pgsql-general по дате отправления
