From: | Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp> |
---|---|
To: | coelho(at)cri(dot)ensmp(dot)fr |
Cc: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | Re: Using COPY FREEZE in pgbench |
Date: | 2021-03-14 00:28:34 |
Message-ID: | 20210314.092834.1436899751241885148.t-ishii@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>> After giving it some thought, ISTM that there could also be a
>> performance improvement with copy freeze from older version, so I'd
>> suggest to add it after 9.3 where the option was added, i.e. 90300.
>
> You misunderstand about COPY FREEZE. Pre-13 COPY FREEZE does not
Oops. I meant Pre-14, not pre-13.
> contribute a performance improvement. See discussions for more details.
> https://www.postgresql.org/message-id/CAMkU%3D1w3osJJ2FneELhhNRLxfZitDgp9FPHee08NT2FQFmz_pQ@mail.gmail.com
> https://www.postgresql.org/message-id/flat/CABOikdN-ptGv0mZntrK2Q8OtfUuAjqaYMGmkdU1dCKFtUxVLrg%40mail.gmail.com
>
>> Also, I do not think it is worth to fail on a 0 pqserverversion, just
>> keep the number and consider it a very old version?
>
> If pqserverversion fails, then following PQ calls are likely fail
> too. What's a benefit to continue after pqserverversion returns 0?
>
>> Question: should there be a word about copy using the freeze option?
>> I'd say yes, in the section describing "g".
>
> Can you elaborate about "section describing "g"? I am not sure what
> you mean.
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Munro | 2021-03-14 02:35:23 | Re: A qsort template |
Previous Message | Tatsuo Ishii | 2021-03-14 00:22:21 | Re: Using COPY FREEZE in pgbench |