| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: pgsql: Add support for MERGE SQL command |
| Date: | 2022-09-20 10:26:52 |
| Message-ID: | 20220920102652.zfbxjhxjeymylrdz@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
On 2022-Sep-19, Tom Lane wrote:
> I wrote:
> > It might be better to change these to temp tables. You'd then
> > have to filter the temp schema out of the results; but since you
> > have a filtering function anyway, that doesn't seem too hard.
>
> Or even easier, ALTER TABLE SET autovacuum_enabled = 'false'
> before populating them.
Thanks, I think I'll add WITH (autovacuum_enabled=false) to all the
CREATE TABLE statements there, as attached. Tests running now, will
push shortly.
--
Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/
"Ed is the standard text editor."
http://groups.google.com/group/alt.religion.emacs/msg/8d94ddab6a9b0ad3
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2022-09-20 10:29:18 | pgsql: doc: Fix parameter name for pg_create_logical_replication_slot() |
| Previous Message | Michael Paquier | 2022-09-20 09:26:03 | pgsql: Fix incorrect variable types for origin IDs in decode.c |