Re: Performance Improvement by reducing WAL for Update Operation

Поиск
Список
Период
Сортировка
От Amit kapila
Тема Re: Performance Improvement by reducing WAL for Update Operation
Дата
Msg-id 6C0B27F7206C9E4CA54AE035729E9C383BEB9259@szxeml509-mbx
обсуждение исходный текст
Ответы Re: Performance Improvement by reducing WAL for Update Operation  (Amit Kapila <amit.kapila@huawei.com>)
Список pgsql-hackers

On 11 January 2013 15:57, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:

>>>> I've moved this to the next CF. I'm planning to review this one first.
>>
>>> Thank you.
>
>> Just reviewing the patch now, making more sense with comments added.

> Making more sense, but not yet making complete sense.

> I'd like you to revisit the patch comments since some of them are completely unreadable.

 

I have modified most of the comments in code.

The changes in attached patch are as below:

 

1. Introduced Encoded WAL Tuple (EWT) to refer to delta encoded tuple for update operation.

   It can rename to one of below:

   a. WAL Encoded Tuple (WET)

   b. Delta Encoded WAL Tuple (DEWT)

   c. Delta WAL Encoded Tuple (DWET)

   d. any others?

 

2. I have kept the wording related to compression in modified docs, but i have tried to copy parts completely.

    IMO this is required as there are some changes w.r.t LZ compression like for New Data.

 

3. There is small coding change as it has been overwritten by one of my previous patch patches.

    Calculation of approximate length for encoded wal tuple.

    Previous Patch:

    if ((bp + (2 * new_tup_bitmaplen)) - bstart >= result_max)

    New Patch:

    if ((bp + (2 + new_tup_bitmaplen)) - bstart >= result_max)

 

   The previous patch calculation was valid if we could have exactly used LZ format.

 

 

With Regards,

Amit Kapila.

Вложения

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

Предыдущее
От: Phil Sorber
Дата:
Сообщение: Re: Teaching pg_receivexlog to follow timeline switches
Следующее
От: Amit kapila
Дата:
Сообщение: Re: Review: Patch to compute Max LSN of Data Pages