Search found 14 matches

by DGh
Wed Feb 26, 2014 6:46 am
Forum: New to Vertica
Topic: commits and recoveries
Replies: 4
Views: 9694

Re: commits and recoveries

Thank you Skwa and Sharon for the explanation. @Sharon - most of the ETL processes we have use the direct hint so they write into ROS. We have had some bad experiences where user dmls (to their own schema- but in the same database) went rogue and took up a lot of WOS memory, causing the last good ep...
by DGh
Mon Feb 24, 2014 8:22 am
Forum: New to Vertica
Topic: commits and recoveries
Replies: 4
Views: 9694

commits and recoveries

All, I have a few questions around the behavior of commits and when actual data is written to the disk. It seems like if I commit a really big transaction 'A' - it might take a long time after the commit has been issued for the move-out process to move the data from WOS to ROS, and until that happen...
by DGh
Mon Feb 17, 2014 7:00 am
Forum: Vertica Backup & Recovery
Topic: Object Level backup on 6.1
Replies: 5
Views: 22186

Re: Object Level backup on 6.1

Thanks sKwa, that helps!
by DGh
Wed Feb 12, 2014 11:36 pm
Forum: Vertica Backup & Recovery
Topic: Object Level backup on 6.1
Replies: 5
Views: 22186

Re: Object Level backup on 6.1

thanks ! that is some really good insight into the actual workings of vertica. I happened to have a backup of the table in another db and recreating the backup seemed to work(able to restore it successfully a few times) is all the internal knowledge about vertica's workings documented somewhere or i...
by DGh
Wed Feb 12, 2014 6:10 am
Forum: Vertica Backup & Recovery
Topic: Object Level backup on 6.1
Replies: 5
Views: 22186

Object Level backup on 6.1

Hi All, I am trying to backup(and restore to test) a bunch of tables in vertica 6.1 It works for one set where i can successfully backup and recover(after dropping from same schema)the tables. I am running a three node cluster. In this other case, however, it is throwing an error during restore. The...
by DGh
Sun Feb 02, 2014 4:45 am
Forum: Vertica Database Administration
Topic: Killing a Database Designer Process from BG
Replies: 3
Views: 7899

Re: Killing a Database Designer Process from BG

Thanks Norbertk.
the select dbd_drop_all_workspaces();
worked.

thanks again for pointing it out.
by DGh
Sun Feb 02, 2014 2:00 am
Forum: Vertica Database Administration
Topic: Killing a Database Designer Process from BG
Replies: 3
Views: 7899

Killing a Database Designer Process from BG

Hi, I am running vertica 6.1 Is there a way to kill a designer process from background? I passed a targeted training query set for the designer and it complained that it couldn't parse them(incorrect syntax in query). However, i didnt kill the process from the admintools at that point(ctrl-C) .I clo...

Go to advanced search