Search found 25 matches

by zvika
Thu Sep 26, 2013 8:23 am
Forum: Vertica Database Administration
Topic: My Vertica presentation at IlTeachTalk
Replies: 3
Views: 7456

Re: My Vertica presentation at IlTeachTalk

Thanks a lot Jim.
Appreciate it .


p.s
I will love doing it also in English but for this meetup I needed to do it in Hebrew.

Zvika
by zvika
Tue Sep 24, 2013 11:01 pm
Forum: Vertica Database Administration
Topic: My Vertica presentation at IlTeachTalk
Replies: 3
Views: 7456

My Vertica presentation at IlTeachTalk

Hi ,

Check out my presentation "Introduction to Vertica (architecture & more)" at the IlTeachTalk meetup group.
Video ISa9BNGK1Dg (in Hebrew)
and slides http://www.slideshare.net/LivePersonDev ... cture-more.

Appreciate your feedbacks

Zvika
by zvika
Tue Sep 03, 2013 1:25 pm
Forum: Vertica Database Administration
Topic: Large deletes from two tables
Replies: 13
Views: 23423

Re: Large deletes from two tables

If you can implement partitioning than I think it's the one of the best way as every solution depend on the scenario and there is no rule for all scenarios.
Just read the documentation about partitioning it will give you the knowlege .

You will be the best person ... don't worry :-)
by zvika
Mon Sep 02, 2013 12:46 pm
Forum: Vertica Database Administration
Topic: Large deletes from two tables
Replies: 13
Views: 23423

Re: Large deletes from two tables

Hello all, I am in need of some help. I am working with Vertica (the default guy) and have a 9 raw tb licenses. Right now we have 7 TB raw used and I want to get rid of about 1TB of data. This data is located in two tables, let’s call them tableA and tableB. Each table has a common key that I want ...
by zvika
Thu Aug 22, 2013 7:21 am
Forum: Vertica Database Administration
Topic: How long does data stay in the DC tables?
Replies: 3
Views: 7249

Re: How long does data stay in the DC tables?

I agree with Sharon as you can profile a query and until you check the query profile or execution engine tables it get purged.
This is the first step to create an oracle AWR ... :-)
by zvika
Wed Aug 21, 2013 6:23 am
Forum: Vertica Database Administration
Topic: query_profiles changed in 6.1 ?
Replies: 2
Views: 5730

Re: query_profiles changed in 6.1 ?

Thanks Sharon,

I thought it got to do with the DC tables ... :-)
by zvika
Tue Aug 20, 2013 8:59 am
Forum: Vertica Database Administration
Topic: query_profiles changed in 6.1 ?
Replies: 2
Views: 5730

query_profiles changed in 6.1 ?

Hi , In version 5.1 if trace was off query_profiles table showed only the active queries (same for execution_engine_profiles). Now I see that in version 6.1 query_profiles & execution_engine_profiles are getting populate and has inactive queries even when trace is disabled . Is this true or I missed...

Go to advanced search