Re: Freeze the inserted tuples during CTAS?

From: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
To: Paul Guo <guopa(at)vmware(dot)com>
Cc: Darafei Komяpa Praliaskouski <me(at)komzpa(dot)net>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Freeze the inserted tuples during CTAS?
Date: 2021-03-03 05:35:28
Message-ID: CAD21AoBeGyNoFWYD5_mS2FhymCnXk_y=WJBrCsR0US+wgKcuxw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Feb 21, 2021 at 4:46 PM Paul Guo <guopa(at)vmware(dot)com> wrote:
>
> Attached is the v2 version that fixes a test failure due to plan change (bitmap index scan -> index only scan).

I think this is a good idea.

BTW, how much does this patch affect the CTAS performance? I expect
it's negligible but If there is much performance degradation due to
populating visibility map, it might be better to provide a way to
disable it.

Regards,

--
Masahiko Sawada
EDB: https://www.enterprisedb.com/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2021-03-03 05:47:18 Re: buildfarm windows checks / tap tests on windows
Previous Message Masahiro Ikeda 2021-03-03 05:33:03 Re: About to add WAL write/fsync statistics to pg_stat_wal view