RE: Disable WAL logging to speed up data loading
От
osumi.takamichi@fujitsu.com
Тема
RE: Disable WAL logging to speed up data loading
Дата
Msg-id
OSBPR01MB488821D9347C14D3F5013209EDFF0@OSBPR01MB4888.jpnprd01.prod.outlook.com
Ответ на
RE: Disable WAL logging to speed up data loading (tsunakawa.takay@fujitsu.com)
Список
Дерево обсуждения
Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: Disable WAL logging to speed up data loading Amul Sul <sulamul@gmail.com>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Disable WAL logging to speed up data loading Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Disable WAL logging to speed up data loading Fujii Masao <masao.fujii@oss.nttdata.com>
Re: Disable WAL logging to speed up data loading Kyotaro Horiguchi <horikyota.ntt@gmail.com>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Disable WAL logging to speed up data loading Fujii Masao <masao.fujii@oss.nttdata.com>
Re: Disable WAL logging to speed up data loading Kyotaro Horiguchi <horikyota.ntt@gmail.com>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Disable WAL logging to speed up data loading Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Disable WAL logging to speed up data loading Fujii Masao <masao.fujii@oss.nttdata.com>
Re: Disable WAL logging to speed up data loading Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Disable WAL logging to speed up data loading Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Disable WAL logging to speed up data loading Kyotaro Horiguchi <horikyota.ntt@gmail.com>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Disable WAL logging to speed up data loading Laurenz Albe <laurenz.albe@cybertec.at>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Disable WAL logging to speed up data loading Laurenz Albe <laurenz.albe@cybertec.at>
Re: Disable WAL logging to speed up data loading Laurenz Albe <laurenz.albe@cybertec.at>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Disable WAL logging to speed up data loading Laurenz Albe <laurenz.albe@cybertec.at>
Re: Disable WAL logging to speed up data loading Fujii Masao <masao.fujii@oss.nttdata.com>
Re: Disable WAL logging to speed up data loading Laurenz Albe <laurenz.albe@cybertec.at>
Re: Disable WAL logging to speed up data loading Fujii Masao <masao.fujii@oss.nttdata.com>
Re: Disable WAL logging to speed up data loading Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Disable WAL logging to speed up data loading Robert Haas <robertmhaas@gmail.com>
Re: Disable WAL logging to speed up data loading Magnus Hagander <magnus@hagander.net>
Re: Disable WAL logging to speed up data loading Stephen Frost <sfrost@snowman.net>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Disable WAL logging to speed up data loading Stephen Frost <sfrost@snowman.net>
Re: Disable WAL logging to speed up data loading Kyotaro Horiguchi <horikyota.ntt@gmail.com>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Disable WAL logging to speed up data loading "David G. Johnston" <david.g.johnston@gmail.com>
Re: Disable WAL logging to speed up data loading Stephen Frost <sfrost@snowman.net>
Re: Disable WAL logging to speed up data loading "David G. Johnston" <david.g.johnston@gmail.com>
Re: Disable WAL logging to speed up data loading Stephen Frost <sfrost@snowman.net>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Disable WAL logging to speed up data loading Laurenz Albe <laurenz.albe@cybertec.at>
Re: Disable WAL logging to speed up data loading Stephen Frost <sfrost@snowman.net>
Re: Disable WAL logging to speed up data loading Kyotaro Horiguchi <horikyota.ntt@gmail.com>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Disable WAL logging to speed up data loading Stephen Frost <sfrost@snowman.net>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: Disable WAL logging to speed up data loading Laurenz Albe <laurenz.albe@cybertec.at>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Disable WAL logging to speed up data loading Masahiko Sawada <sawada.mshk@gmail.com>
Re: Disable WAL logging to speed up data loading Kyotaro Horiguchi <horikyota.ntt@gmail.com>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: Disable WAL logging to speed up data loading Kyotaro Horiguchi <horikyota.ntt@gmail.com>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Disable WAL logging to speed up data loading Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Disable WAL logging to speed up data loading Masahiko Sawada <sawada.mshk@gmail.com>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Disable WAL logging to speed up data loading Masahiko Sawada <sawada.mshk@gmail.com>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Disable WAL logging to speed up data loading Masahiko Sawada <sawada.mshk@gmail.com>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Disable WAL logging to speed up data loading Masahiko Sawada <sawada.mshk@gmail.com>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: Disable WAL logging to speed up data loading Robert Haas <robertmhaas@gmail.com>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: Disable WAL logging to speed up data loading Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Disable WAL logging to speed up data loading Masahiko Sawada <sawada.mshk@gmail.com>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Disable WAL logging to speed up data loading Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Disable WAL logging to speed up data loading movead li <lchch1990@sina.cn>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: Disable WAL logging to speed up data loading Kyotaro Horiguchi <horikyota.ntt@gmail.com>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: Disable WAL logging to speed up data loading David Steele <david@pgmasters.net>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: Disable WAL logging to speed up data loading Stephen Frost <sfrost@snowman.net>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: Disable WAL logging to speed up data loading Stephen Frost <sfrost@snowman.net>
Re: Disable WAL logging to speed up data loading Laurenz Albe <laurenz.albe@cybertec.at>
Re: Disable WAL logging to speed up data loading Stephen Frost <sfrost@snowman.net>
Re: Disable WAL logging to speed up data loading Laurenz Albe <laurenz.albe@cybertec.at>
Re: Disable WAL logging to speed up data loading Stephen Frost <sfrost@snowman.net>
Re: Disable WAL logging to speed up data loading Laurenz Albe <laurenz.albe@cybertec.at>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: Disable WAL logging to speed up data loading Stephen Frost <sfrost@snowman.net>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: Disable WAL logging to speed up data loading Stephen Frost <sfrost@snowman.net>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Disable WAL logging to speed up data loading vignesh C <vignesh21@gmail.com>
Re: Disable WAL logging to speed up data loading Stephen Frost <sfrost@snowman.net>
Re: Disable WAL logging to speed up data loading Michael Paquier <michael@paquier.xyz>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Disable WAL logging to speed up data loading Stephen Frost <sfrost@snowman.net>
Re: Disable WAL logging to speed up data loading Laurenz Albe <laurenz.albe@cybertec.at>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: Disable WAL logging to speed up data loading Michael Paquier <michael@paquier.xyz>
Re: Disable WAL logging to speed up data loading Simon Riggs <simon@2ndquadrant.com>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: Disable WAL logging to speed up data loading Michael Paquier <michael@paquier.xyz>
Re: Disable WAL logging to speed up data loading Simon Riggs <simon@2ndquadrant.com>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
RE: Disable WAL logging to speed up data loading "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
RE: Disable WAL logging to speed up data loading "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Hello On Friday, Nov 20, 2020 9:33 AM Tsunakawa, Takayuki wrote: > From: Kyotaro Horiguchi > > At Thu, 19 Nov 2020 11:04:17 -0500, Stephen Frost > > > * Laurenz Albe (laurenz.albe@cybertec.at) wrote: > > > > I missed that this is only a warning when I looked at it before. > > > > Yes, it should be a fatal error. > > > > > > Yeah, the more that I think about it, the more that I tend to agree > > > with this. Does anyone want to argue against changing this into a > FATAL..? > > > > I don't come up with a use case where someone needs to set > > wal_level=minimal for archive recovery. So +1 to change it to FATAL. It seems we reached the agreement for this fix. > Thank you all. I'd like to give Osumi-san an opportunity to write a patch and > showing the evidence of successful test if you don't mind. He is very young > and newbie to Postgres, so even a small contribution would encourage him to > make further contributions. Sure. Let me do that, including the test. Best, Takamichi Osumi
В списке pgsql-hackers по дате отправления