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

48079 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

25834 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

14020 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

12211 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

16659 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

18177 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

15998 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

16444 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

20104 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

14784 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

20328 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

19749 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

31892 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

17426 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

33327 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

31846 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

15320 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

17575 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

18469 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

24560 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

15240 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

14740 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

16187 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

16844 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

13590 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