Re: In the belly of the beast (MySQLCon) - Mailing list pgsql-general

From Chris Browne
Subject Re: In the belly of the beast (MySQLCon)
Date
Msg-id 60abjnp88a.fsf@dba2.int.libertyrms.com
Whole thread Raw
In response to Re: In the belly of the beast (MySQLCon)  (Alan Hodgson <ahodgson@simkin.ca>)
List pgsql-general
nagy@ecircle-ag.com (Csaba Nagy) writes:
> 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@killerbytes.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...

+1

I'm adding a note about that to the "best practices" in the admin guide.
--
select 'cbbrowne' || '@' || 'linuxfinances.info';
http://cbbrowne.com/info/lsf.html
Disco is to music what Etch-A-Sketch is to art.

pgsql-general by date:

Previous
From: Ivano Luberti
Date:
Subject: Re: JDBC addBatch more efficient?
Next
From: David Wall
Date:
Subject: Re: JDBC addBatch more efficient?