We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Projection constantly replicating? — Vertica Forum

Projection constantly replicating?

JosephJoseph Vertica Customer
in General Discussion

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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...