New wal format distorts pg_xlogdump --stats

Поиск
Список
Период
Сортировка
От Andres Freund
Тема New wal format distorts pg_xlogdump --stats
Дата
Msg-id 20141125033651.GH31915@alap3.anarazel.de
обсуждение исходный текст
Ответы Re: New wal format distorts pg_xlogdump --stats  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Список pgsql-hackers
Hi,

The new WAL format calculates FPI vs plain record data like:rec_len = XLogRecGetDataLen(record) +
SizeOfXLogRecord;fpi_len= record->decoded_record->xl_tot_len - rec_len;
 

Due to the amount of data now handled outside the main data portion ,
that doesn't seem correct to me. As an example, a couple thousand
inserts with full_page_writes=off now yields:

Type                                           N      (%)          Record size      (%)             FPI size      (%)
    Combined size      (%)
 
----                                           -      ---          -----------      ---             --------      ---
    -------------      ---
 
Heap/INSERT                                30167 ( 99.53)               814509 ( 99.50)               965856 ( 99.54)
          1780365 ( 99.52)
 

I think fpi_len now needs to only count the sum of the of the actual
length of block images, and all the rest needs to be rec_len.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: postgresql.auto.conf comments
Следующее
От: Noah Misch
Дата:
Сообщение: Re: The problems of PQhost()