Heikki Linnakangas <[EMAIL PROTECTED]> writes:
> archive_mode = on disables the optimization to skip WAL-logging when 
> loading into a new table that was created in the same transaction. 

... and affects a whole bunch of other behaviors too, in processes all
across the database that could not possibly adopt a new setting
synchronously.  That's exactly why it was made a postmaster-start option
to begin with.  Simon's given no argument at all why it would be safe to
flip it on-the-fly.

                        regards, tom lane

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to