Stats sender and 2pc minor problem

Поиск
Список
Период
Сортировка
От Stas Kelvich
Тема Stats sender and 2pc minor problem
Дата
Msg-id EB57BF68-C06D-4737-BDDC-4BA778F4E62B@postgrespro.ru
обсуждение исходный текст
Ответы Re: Stats sender and 2pc minor problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hello.

Statistics sender logic during usual commit and two-phase commit do not strictly matches each other and that leads to
delta_live_tuples added to n_live_tup in case of truncate in two phase commit.

That can be see in following example:

CREATE TABLE trunc_stats_test5(id serial);
INSERT INTO trunc_stats_test5 DEFAULT VALUES;
INSERT INTO trunc_stats_test5 DEFAULT VALUES;
INSERT INTO trunc_stats_test5 DEFAULT VALUES;
BEGIN;
TRUNCATE trunc_stats_test5;
PREPARE TRANSACTION 'twophase_stats';
COMMIT PREPARED 'twophase_stats';

After that pg_stat_user_tables will have n_live_tup = 3 instead of 0.

Fix along with test is attached.


--
Stas Kelvich
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company


Вложения

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Add PGDLLEXPORT to PG_FUNCTION_INFO_V1
Следующее
От: Peter Eisentraut
Дата:
Сообщение: pg_dump: Simplify internal archive version handling