| From: | Damir Belyalov <dam(dot)bel07(at)gmail(dot)com> |
|---|---|
| To: | torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, pavel(dot)stehule(at)gmail(dot)com |
| Subject: | Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) |
| Date: | 2022-08-15 13:23:26 |
| Message-ID: | CALH1Lgu0dqsQUm9QYdoSvgu-O9Ac5OsbE3TxxZqChUrVF+Qrjw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
>
>
> Thank you for feedback.
I improved my patch recently and tested it on different sizes of
MAX_BUFFERED_TUPLES and REPLAY_BUFFER_SIZE.
> I loaded 10000 rows which contained 1 wrong row.
> I expected I could see 9999 rows after COPY, but just saw 999 rows.
Also I implemented your case and it worked correctly.
> BTW I may be overlooking it, but have you submit this proposal to the
next CommitFest?
Good idea. Haven't done it yet.
Regards,
Damir
Postgres Professional
| Attachment | Content-Type | Size |
|---|---|---|
| 0003-COPY_IGNORE_ERRORS.patch | text/x-patch | 20.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Naylor | 2022-08-15 13:33:21 | Re: [PATCH] Optimize json_lex_string by batching character copying |
| Previous Message | Christoph Berg | 2022-08-15 12:45:24 | pg_receivewal and SIGTERM |