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
Ответ на
Список
Дерево обсуждения
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 по дате отправления
От: Tom Lane
Дата:
От: Masahiko Sawada
Дата:
FAQ