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 15:49 test.blob
I suspect the layouting of such wide columns problably creates a lot of
pain. I'd try \copy and doing the query after \a.
Greetings,
Andres Freund