Skip to main content
Question

eon performance

  • Nov 7, 2021 3:19 PM UTC
  • 4 replies
  • 24 views

vcarusi
Forum|alt.badge.img+1

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

4 replies

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • Nov 8, 2021 9:44 PM UTC

How are you measuring write performance?


vcarusi
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • Nov 9, 2021 6:48 AM UTC

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.


vcarusi
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • Nov 9, 2021 8:39 PM UTC

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

Any idea ?


vcarusi
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • Nov 11, 2021 5:48 PM UTC