Re: In the belly of the beast (MySQLCon)

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Scott Ribe <scott_ribe(at)killerbytes(dot)com>, 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-21 08:12:58
Message-ID: 1208765578.5600.84.camel@PCD12478
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-general

On Sun, 2008-04-20 at 11:32 -0600, Scott Marlowe wrote:
> On Sun, Apr 20, 2008 at 11:12 AM, Scott Ribe <scott_ribe(at)killerbytes(dot)com> wrote:
> > > 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 more suggestion: if you happen to use the alt_perl tools, be sure to
uncomment/change the line:

$SYNC_CHECK_INTERVAL = 1000;

In my experience it made a big difference to set that to 60000 (meaning
sync events created once per minute instead of once per second) for the
synchronizing after copy phase. The number of events generated while the
copy over is running can be so big that it will never get in sync again
otherwise...

Cheers,
Csaba.

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Gabriele Bartolini 2008-04-21 08:31:34 [Poll] Who will come at PGDay 2008?
Previous Message laser 2008-04-21 05:59:12 Re: [pgsql-www] Can somebody add a link on wiki.postgresql.org

Browse pgsql-general by date

  From Date Subject
Next Message Howard Cole 2008-04-21 08:20:22 Missing Log File
Previous Message David 2008-04-21 08:03:57 Re: Insert Rewrite rules