Re: heads up on large text fields.

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: heads up on large text fields.
Дата
Msg-id bff6da3f-9b60-f68a-c46a-14725c81c163@gmail.com
обсуждение исходный текст
Ответ на Re: heads up on large text fields.  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Список 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 по дате отправления:

Предыдущее
От: Arup Rakshit
Дата:
Сообщение: Help to understand Actual Rows vs Plan Rows from the query planneroutput
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: Help to understand Actual Rows vs Plan Rows from the queryplanner output