From: | Chris Browne <cbbrowne(at)acm(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: In the belly of the beast (MySQLCon) |
Date: | 2008-04-21 14:56:21 |
Message-ID: | 60abjnp88a.fsf@dba2.int.libertyrms.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-general |
nagy(at)ecircle-ag(dot)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(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...
+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.
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Browne | 2008-04-21 14:58:52 | pg_bulkloader (was Re: In the belly of the beast (MySQLCon)) |
Previous Message | David Fetter | 2008-04-21 13:35:54 | Re: [Poll] Who will come at PGDay 2008? |
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Browne | 2008-04-21 14:58:52 | pg_bulkloader (was Re: In the belly of the beast (MySQLCon)) |
Previous Message | zedware | 2008-04-21 10:10:33 | Re: How to tell if 64 bit vs 32 bit engine? |