pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRestore rather than rebuild index ?
2+ messages / 2 participants
[nested] [flat]
* Restore rather than rebuild index ?
@ 2010-10-06 20:31 A J <s5aly@yahoo.com>
2010-10-06 20:53 ` Re: Restore rather than rebuild index ? Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 1 reply; 2+ messages in thread
From: A J @ 2010-10-06 20:31 UTC (permalink / raw)
To: pgsql-admin
During restore of a database (from a full backup), the general practice is to
rebuild the indexes. I think with pg_dump and pg_restore (or psql restore), the
only option is to rebuild the indexes. Am I right or is it possible to backup
indexes as well and restore them ?
Just exploring, to figure if time to rebuild a fully functional database (with
indexes) can be lower one way or the other.
Thank you,
AJ
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Restore rather than rebuild index ?
2010-10-06 20:31 Restore rather than rebuild index ? A J <s5aly@yahoo.com>
@ 2010-10-06 20:53 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 0 replies; 2+ messages in thread
From: Kevin Grittner @ 2010-10-06 20:53 UTC (permalink / raw)
To: pgsql-admin; A J <s5aly@yahoo.com>
A J <s5aly@yahoo.com> wrote:
> I think with pg_dump and pg_restore (or psql restore), the only
> option is to rebuild the indexes. Am I right or is it possible to
> backup indexes as well and restore them ?
With pg_dump it is copying in rows by value, so indexes must then be
built. If you use PITR backups, it is a block-by-block copy of the
files, including indexes -- no index rebuild is needed for that
technique.
-Kevin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-10-06 20:53 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-10-06 20:31 Restore rather than rebuild index ? A J <s5aly@yahoo.com>
2010-10-06 20:53 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox