| From: | "G(dot) Anthony Reina" <reina(at)nsi(dot)edu> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Can I dump/undump database for better performance? |
| Date: | 1998-09-24 20:52:47 |
| Message-ID: | 360AB11F.A55354C8@nsi.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(at)nsi(dot)edu //
// //
///////////////////////////////////////////////////////
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fred Bennett | 1998-09-25 03:57:48 | d: command not found during compilation. |
| Previous Message | Bernhard Ertl | 1998-09-24 11:30:33 | Postgres on Solaris Intel/Sparc |