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

763 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

4283 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

3212 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

1658 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

2201 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

1999 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

4019 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

2288 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

1984 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

3233 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

2042 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

6480 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

2834 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

1586 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

1660 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

2261 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

1898 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

2406 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

2068 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

1630 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

1978 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

1736 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

4188 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

2861 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

4257 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