From: | Martin Weinberg <weinberg(at)osprey(dot)astro(dot)umass(dot)edu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | weinberg(at)osprey(dot)astro(dot)umass(dot)edu |
Subject: | Copying an index from one copy of a database to another |
Date: | 2001-01-10 16:12:20 |
Message-ID: | 200101101612.LAA27264@osprey.astro.umass.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Folks,
We have a database with 1.2 billion records (about 300GB not
including indices).
The data is static but indices are build and dropped as needed.
Because the indexing is time consuming, we would like to maintain
two separate copies of the database: one for indexing and one for
production.
The question is:
Is there a way to copy the index from one copy of the database
to another copy without copying all of the data?
Right now, we are copying the entire data directory, which is
a bit painful.
--Martin
===========================================================================
Martin Weinberg Phone: (413) 545-3821
Dept. of Physics and Astronomy FAX: (413) 545-2117/0648
530 Graduate Research Tower
University of Massachusetts
Amherst, MA 01003-4525
From | Date | Subject | |
---|---|---|---|
Next Message | William Staniewicz | 2001-01-10 16:23:08 | converting .xls to delimited file |
Previous Message | Mirko Zeibig | 2001-01-10 16:02:28 | variable name RESULT in PLPGSQL does not work (PG7.1) |