Vertica Performance Tuning

Moderator: NorbertKrupa

New Topic

56 topics

Topics

Replies

Views

Last post

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

169 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

3941 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

2901 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

1308 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

1931 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

1635 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

3820 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

1922 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

1572 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

2427 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

1734 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

5782 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

2410 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

1301 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

1383 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

1861 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

1571 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

2131 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

1794 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

1317 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

1681 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

1475 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

3773 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

2449 Views

Last post by matthewcornell
Wed Mar 26, 2014 9:36 pm
slow multi-join query for small database (~120K t

Last post by matthewcornell « Fri Mar 14, 2014 7:31 pm
Replies: 9
by matthewcornell » Mon Feb 10, 2014 6:28 pm
1

2
9 Replies

3785 Views

Last post by matthewcornell
Fri Mar 14, 2014 7:31 pm

New Topic

56 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