Fri Sep 12 08:09:13 PDT 2008
- Previous message: [Slony1-general] Disabling slony trigger during a transaction
- Next message: [Slony1-general] Disabling slony trigger during a transaction
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Andrew Sullivan wrote: > On Fri, Sep 12, 2008 at 04:00:12PM +0200, Cyril SCETBON wrote: > >> Cause we have a lot of update (14 Millions) to do. It takes 12/14 hours if >> we want to keep a replication with a tolerated lag. If we load it directly >> on each host in parallel ot takes 2/3 hours. I've used the >> alterTableRestore and alterTableForReplication to load data but it stop >> replication and I don't want it. >> > > Wait, you want to bulk load a given table and still be replicating > that table (because it is receiving data in other transactions) > _also_? yes !!! but the field bulk updated won't be updated by our application at the same time > Forget it. Can't be done. > > A > > -- Cyril SCETBON - Ingénieur bases de données AUSY pour France Télécom - OPF/PORTAILS/DOP/HEBEX Tél : +33 (0)4 97 12 87 60 Jabber : cscetbon at jabber.org France Telecom - Orange 790 Avenue du Docteur Maurice Donat Bâtiment Marco Polo C2 - Bureau 202 06250 Mougins France *********************************** Ce message et toutes les pieces jointes (ci-apres le 'message') sont confidentiels et etablis a l'intention exclusive de ses destinataires. Toute utilisation ou diffusion non autorisee est interdite. Tout message electronique est susceptible d'alteration. Le Groupe France Telecom decline toute responsabilite au titre de ce message s'il a ete altere, deforme ou falsifie. Si vous n'etes pas destinataire de ce message, merci de le detruire immediatement et d'avertir l'expediteur. *********************************** This message and any attachments (the 'message') are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. Messages are susceptible to alteration. France Telecom Group shall not be liable for the message if altered, changed or falsified. If you are not recipient of this message, please cancel it immediately and inform the sender. ************************************
- Previous message: [Slony1-general] Disabling slony trigger during a transaction
- Next message: [Slony1-general] Disabling slony trigger during a transaction
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list