Search found 25 matches

by Victorgm
Mon Aug 22, 2016 6:09 pm
Forum: Vertica Database Administration
Topic: CPU Usage by Query
Replies: 1
Views: 19103

Re: CPU Usage by Query

My guess is Oracle's tool is querying the operating system for CPU usage, and not querying Vertica's system tables. Between the OS and Vertica, CPU readings can be very different. To look at the CPU usage from Vertica's perspective, use Management Console or query Vertica's system tables yourself. M...
by Victorgm
Mon Aug 22, 2016 4:18 pm
Forum: Vertica Database Administration
Topic: Backup Vertica to S3
Replies: 9
Views: 39816

Re: Backup Vertica to S3

I was referring to data files that were used to load the Vertica cluster. In your case, it sounds like that would be the HDFS files. I highly recommend you read Ralph Kimball's Data Warehouse Toolkit. It is a free PDF, but don't be fooled by the word "free" - it is a real book, the technical writing...
by Victorgm
Wed Aug 10, 2016 4:56 pm
Forum: Vertica Database Administration
Topic: Backup Vertica to S3
Replies: 9
Views: 39816

Re: Backup Vertica to S3

Yes, exactly.
I believe you would still have to move the files to a Linux file system before using them for recovery.
It's a typical DW backup strategy.
Whichever strategy you choose, test it. I can't emphasize that enough.
by Victorgm
Tue Aug 09, 2016 2:51 pm
Forum: Vertica Database Administration
Topic: Backup Vertica to S3
Replies: 9
Views: 39816

Re: Backup Vertica to S3

Yes, that's a lot of disk space. Which brings me back to my earlier point about using the original data files (that were used to load the DW) as a recovery option rather than vbr.py. It's a very conventional recovery strategy for DW's. Is this not an option for some reason? I only use vbr.py for the...
by Victorgm
Mon Aug 08, 2016 8:15 pm
Forum: Vertica Database Administration
Topic: Backup Vertica to S3
Replies: 9
Views: 39816

Re: Backup Vertica to S3

I explored this last year, and here is what I found (keep in mind things may have changed since then): I didn't try backing-up to S3 but I did try loading (via the COPY command) from S3, and learned a few things. S3 is not a conventional file system (unlike Linux's ext3 & ext4) so you will need a th...
by Victorgm
Mon Aug 01, 2016 11:47 pm
Forum: Vertica Performance Tuning
Topic: Global Catalog and X Locks
Replies: 1
Views: 17545

Re: Global Catalog and X Locks

select version() ;
Vertica Analytic Database v7.1.2-1
Running on Amazon's AMI

Go to advanced search