COPY FREEZE has no warning

Поиск
Список
Период
Сортировка
Искать
От
Bruce Momjian
Тема
COPY FREEZE has no warning
Дата
Msg-id
20130123190246.GC23670@momjian.us
Список
Дерево обсуждения
COPY FREEZE has no warning Bruce Momjian <bruce@momjian.us>
Re: COPY FREEZE has no warning Bruce Momjian <bruce@momjian.us>
Re: COPY FREEZE has no warning Tom Lane <tgl@sss.pgh.pa.us>
Re: COPY FREEZE has no warning Bruce Momjian <bruce@momjian.us>
Re: COPY FREEZE has no warning Peter Eisentraut <peter_e@gmx.net>
Re: COPY FREEZE has no warning Bruce Momjian <bruce@momjian.us>
Re: COPY FREEZE has no warning Andres Freund <andres@2ndquadrant.com>
Re: COPY FREEZE has no warning Bruce Momjian <bruce@momjian.us>
Re: COPY FREEZE has no warning Tom Lane <tgl@sss.pgh.pa.us>
Re: COPY FREEZE has no warning Robert Haas <robertmhaas@gmail.com>
Re: COPY FREEZE has no warning Stephen Frost <sfrost@snowman.net>
Re: COPY FREEZE has no warning Michael Paquier <michael.paquier@gmail.com>
Re: COPY FREEZE has no warning Jeff Janes <jeff.janes@gmail.com>
Re: COPY FREEZE has no warning Bruce Momjian <bruce@momjian.us>
Re: COPY FREEZE has no warning Tom Lane <tgl@sss.pgh.pa.us>
Re: COPY FREEZE has no warning Bruce Momjian <bruce@momjian.us>
Re: COPY FREEZE has no warning Tom Lane <tgl@sss.pgh.pa.us>
Re: COPY FREEZE has no warning Bruce Momjian <bruce@momjian.us>
Re: COPY FREEZE has no warning Bruce Momjian <bruce@momjian.us>
Re: COPY FREEZE has no warning Noah Misch <noah@leadboat.com>
Re: COPY FREEZE has no warning Bruce Momjian <bruce@momjian.us>
Re: COPY FREEZE has no warning Noah Misch <noah@leadboat.com>
Re: COPY FREEZE has no warning Bruce Momjian <bruce@momjian.us>
Re: COPY FREEZE has no warning Tom Lane <tgl@sss.pgh.pa.us>
Re: COPY FREEZE has no warning Bruce Momjian <bruce@momjian.us>
Re: COPY FREEZE has no warning Noah Misch <noah@leadboat.com>
Re: COPY FREEZE has no warning Stephen Frost <sfrost@snowman.net>
Re: COPY FREEZE has no warning Bruce Momjian <bruce@momjian.us>
Re: COPY FREEZE has no warning Robert Haas <robertmhaas@gmail.com>
As a reminder, COPY FREEZE still does not issue any warning/notice if
the freezing does not happen:
     Requests copying the data with rows already frozen, just as they     would be after running the VACUUM FREEZE</> command.     This is intended as a performance option for initial data loading.     Rows will be frozen only if the table being loaded has been created     in the current subtransaction, there are no cursors open and there     are no older snapshots held by this transaction. If those conditions     are not met the command will continue without error though will not     freeze rows. It is also possible in rare cases that the request     cannot be honoured for internal reasons, hence FREEZE     is more of a guideline than a hard rule.
     Note that all other sessions will immediately be able to see the data     once it has been successfully loaded. This violates the normal rules     of MVCC visibility and by specifying this option the user acknowledges     explicitly that this is understood.

Didn't we want to issue the user some kind of feedback?

--  Bruce Momjian          http://momjian.us EnterpriseDB                             http://enterprisedb.com
 + It's impossible for everything to be true. +


В списке pgsql-hackers по дате отправления
От: Heikki Linnakangas
Дата:
Сообщение: Re: pg_ctl idempotent option
От: Bruce Momjian
Дата:
Сообщение: Re: pg_ctl idempotent option
FAQ