Postgres Pro
Downloads
Home   >   mailing lists

Can I dump/undump database for better performance? - Mailing list pgsql-admin

From G. Anthony Reina
Subject Can I dump/undump database for better performance?
Date
Msg-id 360AB11F.A55354C8@nsi.edu
Whole thread Raw
List pgsql-admin
Tree view 
If I dump a database, destroy the database, recreate the database and
then re-install the dump, will it run faster than just vacuuming the
existing database?

Other than vacuumming is there anything else that can be done to speed
up simple searches?

Thanks.
-Tony Reina


--

                        ( @@ )
 ////////////////////oOO*(__)*OOo///////////////////////
//                                                    //
// G. Anthony Reina, MD                               //
// The Neurosciences Institute                        //
// 10640 John Jay Hopkins Drive                       //
// San Diego, CA   92121  USA                         //
//                                                    //
// Voice: (619) 626-2000     FAX: (619) 626-2199      //
// E-mail: reina@nsi.edu                              //
//                                                    //
///////////////////////////////////////////////////////

pgsql-admin by date:

Previous
From: Bernhard Ertl
Date:
Subject: Postgres on Solaris Intel/Sparc
Next
From: Fred Bennett
Date:
Subject: d: command not found during compilation.