On Tue, Dec 31, 2019 at 9:38 AM Tom Lane <t...@sss.pgh.pa.us> wrote: > > This doesn't seem like a reason not to allow a higher limit, like a > megabyte or so, but I'm not sure that pushing it to the moon would be > wise. >
Just to get a mental handle on the size of queries we might be allowing before truncation, I did some very rough arithmetic on what well known texts might fit in a megabyte. By my calculations you could fit about four Animal Farms or one Madame Bovary in about a megabyte. So I think that seems like more than enough :-). (My mind kinda explores at the thought of debugging a query as long as Animal Farm.) cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
