Re: [PERFORM] Slow restoration question

Tom Lane wrote: Eric Lam <[EMAIL PROTECTED]> writes: what is the quickest way of dumping a DB and restoring it? I have done a "pg_dump -D database | split --line-bytes 1546m part" Don't use "-D" if you want fast restore ...

[PERFORM] Slow restoration question

if there is no BEGIN and END block? I assume the reason for slow inserts in this instance is that it allows for rollback, if this is the case can I turn this off? Thanks in advance Eric Lam ---(end of broadcast)--- TIP 1: if posting/reading t