Re: pg_restore load data

On 11/16/2017 03:13 PM, bricklen wrote:
>
> On Thu, Nov 16, 2017 at 1:07 PM, Ron Johnson <ron.l.johnson@cox.net 
> <mailto:ron.l.johnson@cox.net>> wrote:
>
>     v9.2.7  (Yes, I know, it's old.  Nothing I can do about it.)
>
>     During a "whole database" restore using pg_restore of a custom dump,
>     when is the data actually loaded?  I've looked in the list output and
>     don't see any "load" statements.
>
>
> Look for COPY lines, that's how the data is restored.

$ pg_restore -l CDSHA01.dump > CDSHA01.txt
$ grep --color -i copy CDSHA01.txt
$ echo $?
1

There are lots of "restoring data", though.  I should have thought to grep 
for that.

One thing that puzzles me is how fast the tables (even large ones) loaded 
compared to how slow the pg_dump -Fc was.  Granted, I'm running -j4 but 
still, these were some really large, poorly compressible tables (the dump 
file was about as big as du -mc data/base).

-- 
World Peace Through Nuclear Pacification