Search found 149 matches
- Mon Oct 22, 2012 10:40 pm
- Forum: New to Vertica Database Administration
- Topic: Default location for exception and rejected data files
- Replies: 3
- Views: 7679
Re: Default location for exception and rejected data files
You can change it via the copy command officially. Unofficially, I wonder if making the directory a mount to another location works.
- Sun Oct 21, 2012 6:43 pm
- Forum: New to Vertica
- Topic: List tables with stale statistics
- Replies: 5
- Views: 9212
Re: List tables with stale statistics
I would still recommend running it nightly but I would simply run it for all tables that you load data into during that day. You don't need to first check for stale statistics first.
- Wed Oct 17, 2012 4:40 pm
- Forum: Vertica Migration
- Topic: Oracle to Vertica process !
- Replies: 2
- Views: 16598
Re: Oracle to Vertica process !
If you are looking for a product to do it, I hear good things about Wisdomforce but I don't know if its a good fit for you. If you are looking for other ideas, can you batch the changes ... say every X minutes? Do you have PK definitions on your tables?
- Wed Oct 17, 2012 4:37 pm
- Forum: Vertica Database Administration
- Topic: Dropping Projections
- Replies: 6
- Views: 13209
Re: Dropping Projections
Just curious, how many rows in your table?
- Wed Oct 17, 2012 4:36 pm
- Forum: New to Vertica
- Topic: List tables with stale statistics
- Replies: 5
- Views: 9212
Re: List tables with stale statistics
Ok - 5 will warn of stale statistics much more than 6 will because of the way Vertica changed collection. I would not worry about this too much in 6. On a side not, I would the latest 6 and not 6.0.0-1.
- Tue Oct 16, 2012 7:49 pm
- Forum: New to Vertica
- Topic: List tables with stale statistics
- Replies: 5
- Views: 9212
Re: List tables with stale statistics
Which version of vertica?
- Tue Oct 16, 2012 3:12 pm
- Forum: General
- Topic: Demos of Vertica
- Replies: 3
- Views: 7689
Re: Demos of Vertica
Looking at the SSB one - do you know of published results for other databases?