Re: pg 7.4.x - pg_restore impossibly slow - Mailing list pgsql-performance

From patrick keshishian
Subject Re: pg 7.4.x - pg_restore impossibly slow
Date
Msg-id 53b425b00604140010v718aa171p19d9253ce58d0006@mail.gmail.com
Whole thread Raw
In response to Re: pg 7.4.x - pg_restore impossibly slow  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-performance
On 4/13/06, Jim C. Nasby <jnasby@pervasive.com> wrote:
> On Thu, Apr 13, 2006 at 06:26:00PM -0700, patrick keshishian wrote:
> > $ dropdb dbname
> > $ createdb dbname
> > $ pg_restore -vsOd dbname dbname.DUMP
>
> That step is pointless, because the next pg_restore will create the
> schema for you anyway.

Yes, I noticed this with the verbose output (random
non-standard option "-v").

I was providing all information (read: exact steps taken)
which may have been relevant to my post/question, so
that, I would avoid being guilty of omitting any possibly
significant, yet random information.

Thanks for the insight,
--patrick

pgsql-performance by date:

Previous
From: "patrick keshishian"
Date:
Subject: Re: pg 7.4.x - pg_restore impossibly slow
Next
From: Francisco Reyes
Date:
Subject: Re: Inserts optimization?