| From: | Rob Sargent <robjsargent(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: heads up on large text fields. |
| Date: | 2018-09-23 21:34:40 |
| Message-ID: | bff6da3f-9b60-f68a-c46a-14725c81c163@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2018-09-23 22:41:32 | Re: Help to understand Actual Rows vs Plan Rows from the query planner output |
| Previous Message | Arup Rakshit | 2018-09-23 20:21:19 | Help to understand Actual Rows vs Plan Rows from the query planner output |