eon performance

vcarusivcarusi ✭✭
in General Discussion

Hi,
I am using vertica 10 - community edition, 1 node, aws.
I migrated my db to eon.
Unfortunately, the writing speed is halved. The reading speed in affected only when the query is executed the 1st time.
I allocated enough space in the depot location and pinned the most used tables, enabled UseDepotForWrites, UseDepotForReads.
Did anyone have the issue and managed to solve ?
Thank you!
Veronica

Tagged:

Answers

  • SruthiASruthiA Administrator

    How are you measuring write performance?

  • vcarusivcarusi ✭✭

    I use the query_requests table and an own table where is stored the duration of each phase of me application. In this 2nd table I have stored durations for the same phases when vertica9.3 was used, and when vertica10+eon is used.

  • vcarusivcarusi ✭✭
    edited November 2021

    It seems that the InitPlan phase lasts around 2-3 min.

    Any idea ?

  • vcarusivcarusi ✭✭

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 ...