| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Justin Pryzby <pryzby(at)telsasoft(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
| Cc: | Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>, Amit Langote <amitlangote09(at)gmail(dot)com>, Japin Li <japinli(at)hotmail(dot)com>, Zhihong Yu <zyu(at)yugabyte(dot)com>, Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org, Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, Daniel Westermann <dwe(at)dbi-services(dot)com>, Erik Rijkers <er(at)xs4all(dot)nl>, Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>, Andres Freund <andres(at)anarazel(dot)de> |
| Subject: | Re: support for MERGE |
| Date: | 2022-05-12 06:57:45 |
| Message-ID: | 330d62228590d25c66761d44587df5073d580810.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, 2022-05-11 at 11:33 -0500, Justin Pryzby wrote:
> Also, EXPLAIN output currently looks like this:
>
> > Merge on ex_mtarget t (actual rows=0 loops=1)
> > Tuples Inserted: 0
> > Tuples Updated: 50
> > Tuples Deleted: 0
> > Tuples Skipped: 0
>
> Should the "zero" rows be elided from the text output ?
> And/or, should it use a more compact output format ?
>
> There are two output formats already in use, so the options would look like
> this:
>
> Tuples: Inserted: 1 Updated: 2 Deleted: 3 Skipped: 4
> or
> Tuples: inserted=1 updated=2 deleted=3 skipped=4
>
> Note double spaces and capitals.
> That's separate from the question about eliding zeros.
+1 on one of the latter versions, I don't care which one.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2022-05-12 07:03:50 | Re: gitmaster access |
| Previous Message | Amit Kapila | 2022-05-12 06:45:24 | Re: bogus: logical replication rows/cols combinations |