restoring db problems

[zedjr]

I have a 40gb db that has taken over 27 hours to restore and not quite sure totally y. Once it is restored shall i try to reindex the databse tehn do a vaccum then cluster. What process shall i take once the db is restored. I would stop it now but hopefully will be over soon. I did have the hard drive allocation at 32kb as i thought this would improve performance but read 4kb is better. So what does anyone think i shall do once db is restored and in what order. thanks

[WhiteRider]

I don't really know what the restore does, or rather how it reconstructs the database.
It may build it really neatly, in which case the cluster/vacuum may be unnecessary, but unless one of the postgres experts knows better, I would suggest you cluster/vacuum/analyse it once you've got it set up in PT3 again.

[zedjr]

do u think i should reindex also. should i do that first then cluster, vacuum analyze.

[WhiteRider]

As I understand it, the 3 processes in PT3 will do what you need.