Thu Feb 14 08:05:16 PST 2008
- Previous message: [Slony1-general] adding index without telling Slony
- Next message: [Slony1-general] adding index without telling Slony
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Craig James a écrit : > On a replicated table, can I add an index without telling Slony? Say > if I have a replicated table foo(a,b,c,...), could I do "create index > ifoo on foo(a)" on the master node without using Slony's EXECUTE SCRIPT? > > The reason for this is to experiment with performance. I'm not sure > which index might be best, and I don't want to propagate the index to > the slave node until I've tested several solutions. > > Thanks, > Craig > _______________________________________________ > Slony1-general mailing list > Slony1-general at lists.slony.info > http://lists.slony.info/mailman/listinfo/slony1-general Slony doesn't care of index, feel free to adjust index on specific node to specific usage -- Cédric Villemain Administrateur de Base de Données Cel: +33 (0)6 74 15 56 53 http://dalibo.com - http://dalibo.org
- Previous message: [Slony1-general] adding index without telling Slony
- Next message: [Slony1-general] adding index without telling Slony
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list