| From: | Samrat Revagade <revagade(dot)samrat(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Speed up Switchover |
| Date: | 2013-07-26 06:00:10 |
| Message-ID: | 1374818410945-5765235.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> secondary without having to rsync the data as it can take up to 10 hours.
pg_rewind (https://github.com/vmware/pg_rewind) is what you need.
But I think it has a problem regarding the hint bits which Robert Hass
pointed out.
You can still solve hint bit problem by enabling new checksum feature, But
you have to face consequences such as performance overhead.
You can find the discussion about that on following link:
http://www.postgresql.org/message-id/flat/CA+TgmoY4j+p7JY69ry8GpOSMMdZNYqU6dtiONPrcxaVG+SPByg(at)mail(dot)gmail(dot)com#CA+TgmoY4j+p7JY69ry8GpOSMMdZNYqU6dtiONPrcxaVG+SPByg@mail.gmail.com
-----
Greetings,
Samrat Revagade,
NTT-DATA-OSS Center (Pune)
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Speed-up-Switchover-tp5765160p5765235.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2013-07-26 06:17:24 | Re: Speed up Switchover |
| Previous Message | Amit Langote | 2013-07-26 05:58:51 | Re: Fastest Index/Algorithm to find similar sentences |