| From: | "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com> |
|---|---|
| To: | "'Andrey V(dot) Lepikhov'" <a(dot)lepikhov(at)postgrespro(dot)ru> |
| Cc: | "tanghy(dot)fnst(at)cn(dot)fujitsu(dot)com" <tanghy(dot)fnst(at)cn(dot)fujitsu(dot)com>, Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru>, Michael Paquier <michael(at)paquier(dot)xyz>, Ashutosh Bapat <ashutosh(dot)bapat(at)2ndquadrant(dot)com>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>, PostgreSQL-Dev <pgsql-hackers(at)postgresql(dot)org>, Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, "houzj(dot)fnst(at)cn(dot)fujitsu(dot)com" <houzj(dot)fnst(at)cn(dot)fujitsu(dot)com>, Amit Langote <amitlangote09(at)gmail(dot)com> |
| Subject: | RE: [POC] Fast COPY FROM command for the table with foreign partitions |
| Date: | 2021-02-09 08:30:37 |
| Message-ID: | TYAPR01MB2990C093482A67F3AC29E2F2FE8E9@TYAPR01MB2990.jpnprd01.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
From: Andrey V. Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>
> I tried to use 1E4 - 1E8 rows in a tuple buffer. But the results weren't
> impressive.
I guess that's because the 64 KB threshold came first.
> We can use one more GUC instead of a precompiled constant.
Yes, agreed.
> > Why don't we focus on committing the basic part and addressing the
> extended part (0003 and 0004) separately later?
> I focused only on the 0001 and 0002 patches.
> > As Tang-san and you showed, the basic part already demonstrated
> impressive improvement. If there's no objection, I'd like to make this ready for
> committer in a few days.
> Good.
Glad to hear that.
Regards
Takayuki Tsunakawa
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josef Šimánek | 2021-02-09 08:32:48 | Re: Improvements and additions to COPY progress reporting |
| Previous Message | Kyotaro Horiguchi | 2021-02-09 08:29:31 | Re: libpq debug log |