Vertica Performance Tuning

Moderator: NorbertKrupa

New Topic

57 topics

Topics

Replies

Views

Last post

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

2043 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

1108 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

4611 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

3573 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

2141 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

2538 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

2455 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

4200 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

2722 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

2423 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

3981 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

2362 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

7189 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

3309 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

1835 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

2108 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

2607 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

2243 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

2689 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

2360 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

1957 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

2260 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

1920 Views

Last post by NorbertKrupa
Thu Jul 10, 2014 4:24 pm
Partition Pruning on Date Columns Gotcha

Last post by NorbertKrupa « Wed Apr 02, 2014 5:59 pm
Replies: 5
by sramdram » Sat Aug 10, 2013 7:59 pm

5 Replies

4590 Views

Last post by NorbertKrupa
Wed Apr 02, 2014 5:59 pm
performance of simple query on from-scratch database varies

Last post by matthewcornell « Wed Mar 26, 2014 9:36 pm
Replies: 6
by matthewcornell » Fri Mar 21, 2014 4:37 pm

6 Replies

3243 Views

Last post by matthewcornell
Wed Mar 26, 2014 9:36 pm

New Topic

57 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