Re: Enhance file_fdw to report processed and skipped tuples in COPY progress

2025-03-09 Thread Fujii Masao
On 2025/03/09 20:38, vignesh C wrote: I've updated the status to "withdrawn." Feel free to add it again anytime if you change your mind. Thanks! Regards, -- Fujii Masao Advanced Computing Technology Center Research and Development Headquarters NTT DATA CORPORATION

Re: Enhance file_fdw to report processed and skipped tuples in COPY progress

2025-03-09 Thread vignesh C
On Wed, 5 Mar 2025 at 21:43, Fujii Masao wrote: > > > > On 2024/11/30 15:23, Kirill Reshke wrote: > > On Fri, 11 Oct 2024 at 06:53, Fujii Masao > > wrote: > >> However, this issue already exists without the proposed patch. > >> Since file_fdw already reports progress partially, querying multiple

Re: Enhance file_fdw to report processed and skipped tuples in COPY progress

2025-03-05 Thread Fujii Masao
On 2024/11/30 15:23, Kirill Reshke wrote: On Fri, 11 Oct 2024 at 06:53, Fujii Masao wrote: However, this issue already exists without the proposed patch. Since file_fdw already reports progress partially, querying multiple file_fdw tables can lead to inaccurate or confusing progress reports.

Re: Enhance file_fdw to report processed and skipped tuples in COPY progress

2024-11-29 Thread Kirill Reshke
On Fri, 11 Oct 2024 at 06:53, Fujii Masao wrote: > However, this issue already exists without the proposed patch. > Since file_fdw already reports progress partially, querying multiple > file_fdw tables can lead to inaccurate or confusing progress reports. > You can even observe this when analyzin

Re: Enhance file_fdw to report processed and skipped tuples in COPY progress

2024-10-10 Thread Yugo Nagata
On Fri, 11 Oct 2024 10:53:10 +0900 Fujii Masao wrote: > > > On 2024/10/04 2:12, Masahiko Sawada wrote: > > Hi, > > > > On Thu, Oct 3, 2024 at 2:23 AM Fujii Masao > > wrote: > >> > >> Hi, > >> > >> Currently, file_fdw updates several columns in the pg_stat_progress_copy > >> view, > >> like

Re: Enhance file_fdw to report processed and skipped tuples in COPY progress

2024-10-10 Thread Fujii Masao
On 2024/10/04 2:12, Masahiko Sawada wrote: Hi, On Thu, Oct 3, 2024 at 2:23 AM Fujii Masao wrote: Hi, Currently, file_fdw updates several columns in the pg_stat_progress_copy view, like relid and bytes_processed, but it doesn't track tuples_processed or tuples_skipped. Monitoring these wou

Re: Enhance file_fdw to report processed and skipped tuples in COPY progress

2024-10-03 Thread Masahiko Sawada
Hi, On Thu, Oct 3, 2024 at 2:23 AM Fujii Masao wrote: > > Hi, > > Currently, file_fdw updates several columns in the pg_stat_progress_copy view, > like relid and bytes_processed, but it doesn't track tuples_processed or > tuples_skipped. Monitoring these would be particularly useful when handling

Re: Enhance file_fdw to report processed and skipped tuples in COPY progress

2024-10-03 Thread Fabrízio de Royes Mello
On Thu, Oct 3, 2024 at 6:23 AM Fujii Masao wrote: > > Hi, > > Currently, file_fdw updates several columns in the pg_stat_progress_copy view, > like relid and bytes_processed, but it doesn't track tuples_processed or > tuples_skipped. Monitoring these would be particularly useful when handling > la

Enhance file_fdw to report processed and skipped tuples in COPY progress

2024-10-03 Thread Fujii Masao
Hi, Currently, file_fdw updates several columns in the pg_stat_progress_copy view, like relid and bytes_processed, but it doesn't track tuples_processed or tuples_skipped. Monitoring these would be particularly useful when handling large data sets via file_fdw, as it helps track the progress of s