Re: temp table "on commit delete rows": transaction overhead

Поиск
Список
Период
Сортировка
От Artiom Makarov
Тема Re: temp table "on commit delete rows": transaction overhead
Дата
Msg-id w2ud448ea361003310042t91d5f283pb3daccbe19dfcb7@mail.gmail.com
обсуждение исходный текст
Ответ на Re: temp table "on commit delete rows": transaction overhead  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
2010/3/30 Tom Lane <tgl@sss.pgh.pa.us>:

> I don't recall any operations at transaction start for such tables,
> but there may be some.
>
Both in СommitTransaction(void) and  PrepareTransaction(void) we can
see PreCommit_on_commit_actions() call;

Here PreCommit_on_commit_actions()
<CUT>
            case ONCOMMIT_DELETE_ROWS:
                oids_to_truncate = lappend_oid(oids_to_truncate, oc->relid);
                break;
<CUT>

As a my opinion, the same action taked place at transaction start and commit.

To truncate rows of any temp tables, both  changed and unchanged(!)
after transaction looks as little reinsurance. Well.
But why do the same action _before_ any transaction?

В списке pgsql-performance по дате отправления:

Предыдущее
От: Christiaan Willemsen
Дата:
Сообщение: Re: Using high speed swap to improve performance?
Следующее
От: Ľubomír Varga
Дата:
Сообщение: Some question