Projection constantly replicating?

JosephJoseph Vertica Customer

We are doing some schema level replication using vbr

I have a projection that is constantly replicating .... ... The "owners" of the underlying table have assured me that this only gets updated on a batch basis - say once or twice a month - yet I see it replicating all the time (i am using a query with sal_storage_id to see this )...

I have searched QUERY_REQUESTS and cannot find inserts or updates or deletes other than that expected (as mentioned this is done once/twice a month in a batch) ......I therefore have no idea as to why this large projection is constantly replicating.......

Presumably vbr is "thinking" the object has changed and so needs to replicate......

Answers

  • SankarmnSankarmn Community Edition User ✭✭

    @Joseph, in your case you should go with object level replication against schema level, where you can leave out the objects that are part of batch process.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file