Tue Sep 28 23:47:10 PDT 2004
- Previous message: [Slony1-general] Call for 1.0.3 Patches/Needs
- Next message: [Slony1-general] Can't afford hot-join - what are my options
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
I've got a problem: One of my 24/7 databases has access requirements / performance constraints, which make it impossible for me to do the standard initial hot-join (copy) on some multi-million row tables as it messes up pg and os caches in a way that makes standard production queries too slow. Is there any way I can either 1) make the initial copy less agressive - can I somehow throttle it or perform it in smaller chunks ? or 2) avoid it alltogether - could I load regular backup and start replication from there - somehow pg_dump seems to do fine ? btw, runtime replication load is reasonable and does not seem to cause any problems. ------------- Hannu
- Previous message: [Slony1-general] Call for 1.0.3 Patches/Needs
- Next message: [Slony1-general] Can't afford hot-join - what are my options
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list