Re: In the belly of the beast (MySQLCon)

From: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
To: Alan Hodgson <ahodgson(at)simkin(dot)ca>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: In the belly of the beast (MySQLCon)
Date: 2008-04-20 17:12:16
Message-ID: C430D590.9567C%scott_ribe@killerbytes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-general

> I am going to play with this and see where it breaks, but it's going to be
> an enormous time investment to babysit it.

One thing to remember, since you've already got backup in place and this
replica would just be for upgrading, not a hot spare, turn off fsync during
the initial subscription. My data set is quite a bit smaller, and I've
gotten into the habit of turning off fsync during the initial post-upgrade
load, to shorten my downtime.

--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 722-0567 voice

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Scott Marlowe 2008-04-20 17:32:58 Re: In the belly of the beast (MySQLCon)
Previous Message Joshua D. Drake 2008-04-20 03:03:46 Booth at LWE confirmed

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-04-20 17:32:58 Re: In the belly of the beast (MySQLCon)
Previous Message Craig Ringer 2008-04-19 18:16:19 Re: Initial ugly reverse-translator