Re: Surprise :-( - Mailing list pgsql-general

From Jason Earl
Subject Re: Surprise :-(
Date
Msg-id 87r8g63d86.fsf@npa01zz001.simplot.com
Whole thread Raw
In response to Re: Surprise :-(  ("Mihai Gheorghiu" <tanethq@earthlink.net>)
List pgsql-general
"Mihai Gheorghiu" <tanethq@earthlink.net> writes:

> Only one of the 350k trxtype=MP records has isposted=false !!!
> I am downloading 7.2.2 right now, and, God willing, on Monday I will be able
> to apply your recommendations regarding explain analyze.
> Which leads me to the following question:
> I dump this database with pgdump in less than 15 minutes and restore it with
> psql -d mydata -f mydata.dmp in 375 minutes.
> Is there a faster way?
> Thanks again.

Uh... You might want to skip ahead and go right to the new 7.3beta1.
Otherwise you are probably going to *want* to do another dump reload
cycle in the very near future.

Just a thought.

Jason

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Slow query when joining to un-analyzed temp table...
Next
From: Mario Weilguni
Date:
Subject: Re: Date not being parsed as expected