On Tue, Dec 31, 2019 at 10:16 AM Andrew Dunstan <andrew.duns...@2ndquadrant.com> wrote: > > 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.) >
Turns out my arithmetic was a bit off. Animal Farm is 90 kb, Madame Bovary 678 Kb. cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services