Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work

Поиск
Список
Период
Сортировка
Искать
От
Nathan Bossart
Тема
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work
Дата
Msg-id
20220215231123.GA2584239@nathanxps13
Ответ на
Список
Дерево обсуждения
Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Andres Freund <andres@anarazel.de>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Julien Rouhaud <rjuju123@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Tom Lane <tgl@sss.pgh.pa.us>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Andres Freund <andres@anarazel.de>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work "Bossart, Nathan" <bossartn@amazon.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Tom Lane <tgl@sss.pgh.pa.us>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work "Bossart, Nathan" <bossartn@amazon.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Andres Freund <andres@anarazel.de>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work "Bossart, Nathan" <bossartn@amazon.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work "Bossart, Nathan" <bossartn@amazon.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Andres Freund <andres@anarazel.de>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Andres Freund <andres@anarazel.de>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Andres Freund <andres@anarazel.de>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Thomas Munro <thomas.munro@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Andres Freund <andres@anarazel.de>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Thomas Munro <thomas.munro@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Andres Freund <andres@anarazel.de>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Tom Lane <tgl@sss.pgh.pa.us>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Tom Lane <tgl@sss.pgh.pa.us>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Thomas Munro <thomas.munro@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Tom Lane <tgl@sss.pgh.pa.us>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Thomas Munro <thomas.munro@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Thomas Munro <thomas.munro@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Michael Paquier <michael@paquier.xyz>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Michael Paquier <michael@paquier.xyz>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Michael Paquier <michael@paquier.xyz>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Ibrar Ahmed <ibrar.ahmad@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Michael Paquier <michael@paquier.xyz>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Andres Freund <andres@anarazel.de>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Andres Freund <andres@anarazel.de>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Tom Lane <tgl@sss.pgh.pa.us>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work "Bossart, Nathan" <bossartn@amazon.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work "Bossart, Nathan" <bossartn@amazon.com>
On Tue, Feb 15, 2022 at 10:37:58AM -0800, Nathan Bossart wrote:
> On Tue, Feb 15, 2022 at 10:10:34AM -0800, Andres Freund wrote:
>> I generally think it'd be a good exercise to go through an use
>> get_dirent_type() in nearly all ReadDir() style loops - it's a nice efficiency
>> win in general, and IIRC a particularly big one on windows.
>> 
>> It'd probably be good to add a reference to get_dirent_type() to
>> ReadDir[Extended]()'s docs.
> 
> Agreed.  I might give this a try.

Alright, here is a new patch set where I've tried to replace as many
stat()/lstat() calls as possible with get_dirent_type().  0002 and 0003 are
the same as v9.  I noticed a few remaining stat()/lstat() calls that don't
appear to be doing proper error checking, but I haven't had a chance to try
fixing those yet.

-- 
Nathan Bossart
Amazon Web Services: https://aws.amazon.com
В списке pgsql-hackers по дате отправления
От: Magnus Hagander
Дата:
Сообщение: Re: Observability in Postgres
От: Peter Geoghegan
Дата:
FAQ