From: | Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Relaxing COPY FREEZE restrictions |
Date: | 2021-06-24 14:03:39 |
Message-ID: | CANbhV-HpmBXAqYwiHXV=J4kb=LO5J7hK50nS3kvCwpShGKR52Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
COPY FREEZE throws ERRORs if you use it inappropriately. This makes it
very hard to use in practice.
ERRORs should be replaced by NOTICEs, or just silence. That treats
FREEZE as an optional performance tweak, which is more appropriate for
its use case.
In particular, the need to throw ERRORs leads us to disallow the
FREEZE option for partitioned tables. It would be better to test each
partition to see if the optimization can be applied at the point we
open each partition. If we can, good. If not, no worries.
If we agree, I can code a patch to do this.
Relaxing this will make it easier to add support for FREEZE into pg_restore.
Thanks
--
Simon Riggs http://www.EnterpriseDB.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2021-06-24 14:03:43 | pgbench using COPY FREEZE |
Previous Message | Heikki Linnakangas | 2021-06-24 13:42:20 | Re: Add tests for UNBOUNDED syntax ambiguity |