Re: [HACKERS] Re: [HACKERS] GSoC 2015 proposal: Improve the performance of “ALTER TABLE .. SET LOGGED / UNLOGGED” statement

Поиск
Список
Период
Сортировка
От Fabrízio de Royes Mello
Тема Re: [HACKERS] Re: [HACKERS] GSoC 2015 proposal: Improve the performance of “ALTER TABLE .. SET LOGGED / UNLOGGED” statement
Дата
Msg-id CAFcNs+rRpWLVHm3J7wPO9DYCVTzNM3wD=KXAPhY8RCxFqbZn=A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Re: [HACKERS] GSoC 2015 proposal: Improve the performance of “ALTER TABLE .. SET LOGGED / UNLOGGED” statement  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers

On Thu, Jul 9, 2015 at 10:56 AM, Andres Freund <andres@anarazel.de> wrote:
>
> On 2015-07-09 10:39:35 -0300, Fabrízio de Royes Mello wrote:
> > If the "wal_level=minimal" we don't need to force the wal log of the
> > contents. If the "wal_level != minimal" we need just to xlog all the pages,
> > but in both cases we don't need the extra job to create a new datafiles and
> > copy the contents between them. So we'll improve performance, or am I
> > missing something?
>
> Sure. It'll be a bit faster. I just don't see the peformance increase in
> not that common situations being worth the price we'll pay in
> development, code review, debugging and then maintaining some nontrivial
> code. If this were likely to be a 15 line patch, I'd think differently.

Well, this will not be a 15 line patch, but I'll try to simplify as much as possible.

Regards,

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Timbira: http://www.timbira.com.br
>> Blog: http://fabriziomello.github.io
>> Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
>> Github: http://github.com/fabriziomello

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Set of patch to address several Coverity issues
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: Waits monitoring