Vertica Performance Tuning

Moderator: NorbertKrupa

New Topic

58 topics

Topics

Replies

Views

Last post

performance of simple query on from-scratch database varies

Last post by adila10 « Tue Jan 22, 2019 11:51 am
Replies: 3
by scutter » Fri Mar 21, 2014 9:01 pm

3 Replies

57916 Views

Last post by adila10
Tue Jan 22, 2019 11:51 am
QUERY_PROFILES view, column QUERY_DURATION_US

Last post by Timbo « Tue Dec 04, 2018 2:04 pm

by Timbo » Tue Dec 04, 2018 2:04 pm

0 Replies

48039 Views

Last post by Timbo
Tue Dec 04, 2018 2:04 pm
Vertica not choosing the best projection for join?

Last post by _pj_ « Thu Apr 26, 2018 9:18 am

by _pj_ » Thu Apr 26, 2018 9:18 am

0 Replies

18490 Views

Last post by _pj_
Thu Apr 26, 2018 9:18 am
performance consideration for bulk loading

Last post by hoseiney « Wed Jul 12, 2017 4:51 pm

by hoseiney » Wed Jul 12, 2017 4:51 pm

0 Replies

16779 Views

Last post by hoseiney
Wed Jul 12, 2017 4:51 pm
Global Catalog and X Locks

Last post by Victorgm « Mon Aug 01, 2016 11:47 pm
Replies: 1
by Victorgm » Thu Jul 28, 2016 9:20 pm

1 Replies

20094 Views

Last post by Victorgm
Mon Aug 01, 2016 11:47 pm
What is the difference between the Planned Concurrency and max concurreny in Resource Pool ?

Last post by JimKnicely « Mon Apr 25, 2016 4:18 pm
Replies: 2
by vigneshn » Fri May 01, 2015 2:50 pm

2 Replies

21744 Views

Last post by JimKnicely
Mon Apr 25, 2016 4:18 pm
Output Queue Wait(us) - Execution Engine Profiles

Last post by taneja10 « Wed Apr 13, 2016 11:52 am
Replies: 2
by Janica » Wed Mar 30, 2016 11:19 pm

2 Replies

19426 Views

Last post by taneja10
Wed Apr 13, 2016 11:52 am
vnetperf - ERROR: Couldn't determine hosts via admintools:

Last post by JimKnicely « Mon Feb 08, 2016 9:41 pm
Replies: 2
by Josh » Mon Feb 08, 2016 6:12 pm

2 Replies

20856 Views

Last post by JimKnicely
Mon Feb 08, 2016 9:41 pm
analyze_statistics on "Materialize" Step

Last post by Victorgm « Wed Feb 03, 2016 5:48 pm
Replies: 5
by Victorgm » Wed Jan 27, 2016 11:44 pm

5 Replies

25819 Views

Last post by Victorgm
Wed Feb 03, 2016 5:48 pm
Can anyone explain time spent between queue_entry_timestamp and start_timestamp

Last post by VerDBA « Sun Dec 06, 2015 8:17 am

by VerDBA » Sun Dec 06, 2015 8:17 am

0 Replies

17625 Views

Last post by VerDBA
Sun Dec 06, 2015 8:17 am
Queries slowdown on server load

Last post by VerDBA « Sun Dec 06, 2015 8:02 am
Replies: 5
by andylens » Wed Dec 02, 2015 11:04 am

5 Replies

25433 Views

Last post by VerDBA
Sun Dec 06, 2015 8:02 am
Canary Query Queuing

Last post by NorbertKrupa « Sat Nov 28, 2015 10:52 pm
Replies: 5
by VerDBA » Wed Nov 25, 2015 4:43 am

5 Replies

24710 Views

Last post by NorbertKrupa
Sat Nov 28, 2015 10:52 pm
Creating Live Aggregate Projection

Last post by Timbo « Tue Nov 24, 2015 9:45 am
Replies: 7
by Timbo » Thu Nov 19, 2015 6:22 pm
1

2
7 Replies

40266 Views

Last post by Timbo
Tue Nov 24, 2015 9:45 am
INSERT speed highly depends on server load

Last post by NorbertKrupa « Sat Nov 14, 2015 10:47 pm
Replies: 3
by andylens » Sat Nov 14, 2015 1:43 pm

3 Replies

22077 Views

Last post by NorbertKrupa
Sat Nov 14, 2015 10:47 pm
Presentation on Performance Tuning

Last post by id10t « Tue Oct 06, 2015 1:17 pm
Replies: 8
by doug_harmon » Wed Oct 09, 2013 4:33 am
1

2
8 Replies

41120 Views

Last post by id10t
Tue Oct 06, 2015 1:17 pm
projection stats not getting updated

Last post by Victorgm « Mon Aug 24, 2015 7:32 pm
Replies: 9
by Victorgm » Fri Aug 21, 2015 7:16 pm
1

2
9 Replies

39013 Views

Last post by Victorgm
Mon Aug 24, 2015 7:32 pm
Help with LIMIT performance?

Last post by scutter « Wed Aug 05, 2015 8:51 pm
Replies: 2
by usli06 » Wed Aug 05, 2015 6:16 pm

2 Replies

19790 Views

Last post by scutter
Wed Aug 05, 2015 8:51 pm
Projections With Expressions

Last post by JimKnicely « Sun Jul 26, 2015 3:55 am
Replies: 3
by darinbob » Fri Jul 24, 2015 4:34 pm

3 Replies

27503 Views

Last post by JimKnicely
Sun Jul 26, 2015 3:55 am
Vertica performance on VM

Last post by atantawy « Tue Jul 21, 2015 7:58 am
Replies: 4
by atantawy » Sat Jul 18, 2015 12:40 am

4 Replies

23522 Views

Last post by atantawy
Tue Jul 21, 2015 7:58 am
How to know if my partition is getting hit in vertica

Last post by NorbertKrupa « Mon Jul 13, 2015 2:53 am
Replies: 4
by Amit » Tue Jul 07, 2015 2:42 pm

4 Replies

30945 Views

Last post by NorbertKrupa
Mon Jul 13, 2015 2:53 am
Vertica Performance Engineering Essentials

Last post by adrian.oprea « Fri Mar 20, 2015 3:50 pm
Replies: 2
by JimKnicely » Wed Mar 19, 2014 4:08 pm

2 Replies

18371 Views

Last post by adrian.oprea
Fri Mar 20, 2015 3:50 pm
Spread Monitoring

Last post by NorbertKrupa « Wed Jan 28, 2015 4:30 pm
Replies: 1
by Timbo » Wed Jan 28, 2015 3:34 pm

1 Replies

18992 Views

Last post by NorbertKrupa
Wed Jan 28, 2015 4:30 pm
Partition table by year

Last post by Timbo « Thu Jan 22, 2015 11:20 am
Replies: 2
by Timbo » Tue Jan 20, 2015 6:02 pm

2 Replies

20309 Views

Last post by Timbo
Thu Jan 22, 2015 11:20 am
Update dimension table and pre-join projection

Last post by peleroy « Sun Dec 21, 2014 4:23 pm
Replies: 3
by peleroy » Sat Dec 20, 2014 6:01 pm

3 Replies

21446 Views

Last post by peleroy
Sun Dec 21, 2014 4:23 pm
Insufficient resources to execute plan

Last post by NorbertKrupa « Thu Jul 10, 2014 4:24 pm
Replies: 1
by veena » Thu Jul 10, 2014 4:05 pm

1 Replies

17091 Views

Last post by NorbertKrupa
Thu Jul 10, 2014 4:24 pm

New Topic

58 topics

Return to Board Index

Forum permissions

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum