Thu Jan 15 11:24:11 PST 2009
- Previous message: [Slony1-general] Failover fails on small replication clusters
- Next message: [Slony1-general] Re: execute script locking
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
if i run execute script() with the "execute only on" option to limit it to one node, does slony only take locks on that node, or does it lock all tables on all nodes? i'm using it to run some table compaction. alternatively is it safe to run a query like this outside of execute script: "alter table user_event_log alter column user_id type integer;" where the user_id is already an integer (and is the PK). this is the trick i use to compact the table and indexes after a large data purge. I'm running Pg 8.3 and slonly 1.2.14 on freebsd 7.0 thanks!
- Previous message: [Slony1-general] Failover fails on small replication clusters
- Next message: [Slony1-general] Re: execute script locking
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list