Cédric Villemain cedric.villemain at dalibo.com
Thu Feb 14 08:05:16 PST 2008
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



More information about the Slony1-general mailing list