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@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
