"Peter J. Holzer" <hjp-pgsql@xxxxxx> writes: > On 2019-03-20 13:20:57 +0100, Thomas Güttler wrote: >> Strange. I saw a big difference. >> What did you test? >> I tested inserts. > The graph with the quantiles was for selects. Hmm, so there are two different code paths being considered here -- the OP is apparently talking about the speed of bytea_in, while the rest of us have been thinking about bytea_out. The question about whether the text representation is hex or "escape" style still applies, though. regards, tom lane
