Re: heads up on large text fields.

2018-09-23 Thread Rob Sargent
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 f

Re: heads up on large text fields.

2018-09-22 Thread Andreas Kretschmer
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 -- 2ndQuadrant - The

Re: heads up on large text fields.

2018-09-21 Thread Rob Sargent
> On Sep 21, 2018, at 7:59 PM, Andres Freund wrote: > >> On 2018-09-21 18:28:37 -0600, Rob Sargent wrote: >> "/tmp/regen.file" gets very large, very fast and I have to >> pg_terminate_backend. Tried this three times, once using "\o test.blob" >> instead. >> >> h009357:loader$ ls -ltr >>

Re: heads up on large text fields.

2018-09-21 Thread Andres Freund
On 2018-09-21 18:28:37 -0600, Rob Sargent wrote: > "/tmp/regen.file" gets very large, very fast and I have to > pg_terminate_backend.  Tried this three times, once using "\o test.blob" > instead. > >h009357:loader$ ls -ltr >total 2048 >-rwxr-xr-x 1 u0138544 camplab 10002460672 Sep 21 1

heads up on large text fields.

2018-09-21 Thread Rob Sargent
Playing around with files-in-text-field.  I can happily slam a 10M file into a text field in a table defined as gtdb=# \d gt.ld     Table "gt.ld"     Column    | Type | Collation | Nullable | Default --+--+---+--+-  id