RE: Disable WAL logging to speed up data loading

Поиск
Список
Период
Сортировка
От tsunakawa.takay@fujitsu.com
Тема RE: Disable WAL logging to speed up data loading
Дата
Msg-id TYAPR01MB2990BFD09013F0C5B8080867FE689@TYAPR01MB2990.jpnprd01.prod.outlook.com
обсуждение исходный текст
Ответ на Re: Disable WAL logging to speed up data loading  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-hackers
From: Laurenz Albe <laurenz.albe@cybertec.at>
> Now I'm not saying that this feature should not go in (I set it to
> "ready for committer", because I see no technical flaw with the
> implementation), but it remains debatable if we want the feature or not.

Oh, yes, thank you very much for supporting this and other relevant two threads!


> I certainly can see David's point of view.  And we don't view MySQL as
> a role model that we want to emulate.

Yes, what MySQL was over ten years ago would not be a role model for us.  OTOH, recent MySQL under Oracle should be
improvingmuch -- adopting InnoDB as a default storage engine, transactional data dictionary, etc.  (Somewhat offtopic,
buttheir documentation quality is great.)
 


> All these things are annoying to users, but we'd rather take that than
> the complaints that a database got corrupted because somebody didn't read
> the documentation carefully.

Hmm, if that were the case, then some people would say the unlogged-table based approach is also be dangerous, saying
"Usersdon't read the manual carefully and easily think that making all tables unlogged is good for performance."
 


    Regards
Takayuki Tsunakawa


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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Proposal: Save user's original authenticated identity for logging
Следующее
От: Marina Polyakova
Дата:
Сообщение: Re: Reduce the time required for a database recovery from archive.