| From: | Jason Earl <jason(dot)earl(at)simplot(dot)com> |
|---|---|
| To: | "Mihai Gheorghiu" <tanethq(at)earthlink(dot)net> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Surprise :-( |
| Date: | 2002-09-06 23:33:29 |
| Message-ID: | 87r8g63d86.fsf@npa01zz001.simplot.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Mihai Gheorghiu" <tanethq(at)earthlink(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mario Weilguni | 2002-09-07 07:37:22 | Re: Date not being parsed as expected |
| Previous Message | Stephan Szabo | 2002-09-06 22:50:31 | Re: Slow query when joining to un-analyzed temp table... |