slow multi-join query for small database (~120K t

Moderator: NorbertKrupa

Post Reply
id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: slow multi-join query for small database (~120K t

Post by id10t » Mon Feb 10, 2014 8:45 pm

Hi!

[DELETED]
Last edited by id10t on Fri May 08, 2015 4:46 pm, edited 1 time in total.

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: slow multi-join query for small database (~120K t

Post by NorbertKrupa » Tue Feb 11, 2014 3:50 pm

I'm providing the link to your StackOverflow question to avoid cross-posting and show what others have suggested.

I threw your profile results into Excel and sorted on the counter_value column. The costliest operations are (not surprisingly) the JOIN's. At this point, I would suggest that you explore Pre-join Projections and Join Predicates if you plan on using your query. Like I mentioned on your StackOverflow question, you may want to consider de-normalizing your schema (if possible).
Checkout vertica.tips for more Vertica resources.

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: slow multi-join query for small database (~120K t

Post by NorbertKrupa » Tue Feb 11, 2014 4:51 pm

Much appreciated. I don't yet know how much the communities overlap (SO, here, and http://community.vertica.com/ ) so I'm learning.
I've found that community.vertica.com is the least helpful. I've had several open questions on there for quite some time with no activity. StackOverflow and these forums seem to be the best resources IMO.
Checkout vertica.tips for more Vertica resources.

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: slow multi-join query for small database (~120K t

Post by id10t » Tue Feb 11, 2014 7:02 pm

Hi!

[DELETED]
Last edited by id10t on Fri May 08, 2015 4:46 pm, edited 1 time in total.

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: slow multi-join query for small database (~120K t

Post by id10t » Mon Feb 17, 2014 10:20 pm

Hi!

[DELETED]
Last edited by id10t on Fri May 08, 2015 4:40 pm, edited 1 time in total.

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: slow multi-join query for small database (~120K t

Post by id10t » Mon Feb 17, 2014 10:39 pm

Hi!

[DELETED]
Last edited by id10t on Fri May 08, 2015 4:40 pm, edited 1 time in total.

Post Reply

Return to “Vertica Performance Tuning”