Re: heads up on large text fields. - Mailing list pgsql-general

From Rob Sargent
Subject Re: heads up on large text fields.
Date
Msg-id bff6da3f-9b60-f68a-c46a-14725c81c163@gmail.com
Whole thread Raw
In response to Re: heads up on large text fields.  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-general

On 09/22/2018 06:00 AM, Andreas Kretschmer wrote:
>
>
> Am 22.09.2018 um 02:28 schrieb Rob Sargent:
>> However, I get into deep dodo when I try redirecting psql output such as
>>
>>     select ld from gt.ld\g /tmp/regen.file
>>
>
> works for me if i start psql with -t -A -o /path/to/file
> (pg 10.5, but psql from 11beta3)
>
>
> Regards, Andreas
>
OK, I'm a little slow on the uptake.  The few very wide lines (728035 
characters) demand that all the other lines be padded and with 132236 
lines you end up with a 96G file (with out the smarts provided about).





pgsql-general by date:

Previous
From: Arup Rakshit
Date:
Subject: Help to understand Actual Rows vs Plan Rows from the query planneroutput
Next
From: Tomas Vondra
Date:
Subject: Re: Help to understand Actual Rows vs Plan Rows from the queryplanner output