Search found 93 matches
- Mon Oct 28, 2013 9:24 pm
- Forum: Vertica Database Administration
- Topic: A lot of records in the QUERY_EVENTS table...
- Replies: 0
- Views: 4882
A lot of records in the QUERY_EVENTS table...
Hello, I was checking out the records in the QUERY_EVENTS table. Does anyone know if I should be worried about these records? In particular the SMALL_MERGE_REPLACED, MERGE_CONVERTED_TO_UNION and WOS_SPILL records :?: dbadmin=> select distinct event_category, event_type, count(*) from query_events gr...
- Fri Oct 25, 2013 2:19 pm
- Forum: Vertica SQL Functions
- Topic: How to convert an epoch to a timetamp?
- Replies: 0
- Views: 7233
How to convert an epoch to a timetamp?
Howdy, On page 205 of the sql reference guide there is a little blurb about how to convert an epoch back into a timestamp: Here is how you can convert an epoch value back to a timestamp: SELECT TIMESTAMP WITH TIME ZONE 'epoch' + 982384720 * INTERVAL '1 second'; However, that conversion doesn't seem ...
- Wed Oct 16, 2013 4:04 pm
- Forum: Vertica SQL
- Topic: Recommended Sequence Cache Size
- Replies: 2
- Views: 6581
Re: Recommended Sequence Cache Size
Thanks, Jim! Awesome time tests!
- Tue Oct 15, 2013 1:33 pm
- Forum: Vertica SQL
- Topic: Recommended Sequence Cache Size
- Replies: 2
- Views: 6581
Recommended Sequence Cache Size
Hi, The default size of a sequence cache is 250,000. That seems awful high to me considering if I only insert a few rows per session I'll lose a lot of the sequence values and they'll be huge gaps in my primary key. Does anyone have a recommendation on a cache size? I've tried no cache, but the perf...
- Tue Oct 08, 2013 5:25 pm
- Forum: New to Vertica Database Administration
- Topic: How much space is used if HistoryRetentionTime is increased?
- Replies: 3
- Views: 7550
Re: How much space is used if HistoryRetentionTime is increa
Hmm. Ok, thanks, sKwa. I suppose that makes sense.
- Tue Oct 08, 2013 4:17 pm
- Forum: New to Vertica Database Administration
- Topic: How much space is used if HistoryRetentionTime is increased?
- Replies: 3
- Views: 7550
How much space is used if HistoryRetentionTime is increased?
Hello,
Is there a way to tell how much disk space I am using if increase the HistoryRetentionTime parameter to a 24 hour period using the command SELECT SET_CONFIG_PARAMETER ('HistoryRetentionTime', '86400'); ?
Also, does this storage count against my license allowance?
Is there a way to tell how much disk space I am using if increase the HistoryRetentionTime parameter to a 24 hour period using the command SELECT SET_CONFIG_PARAMETER ('HistoryRetentionTime', '86400'); ?
Also, does this storage count against my license allowance?
- Sun Sep 22, 2013 5:06 pm
- Forum: New to Vertica Database Administration
- Topic: Change Owner of View
- Replies: 2
- Views: 6006
Re: Change Owner of View
Thanks, Jim. I kind of figured as much. Thanks for a nice work around