marcothesane
Administrator
marcothesane Administrator
Reactions
-
Re: Question on UTF-8
As @mosheg said - any column_name VARCHAR(n) or code_name CHAR(2) is always for a variable length or fixed length string encoded in UTF-8. This means that a string containing the Euro sign four times… (View Post)1 -
Re: partition deletion request takes a long time
Looking at it again, your hierarchical partitioning clause that you are using is not hierarchical. Matched with my table, it would be: ALTER TABLE hierpart PARTITION BY ((dt)::DATE) GROUP BY (DATE_TR… (View Post)1 -
Re: partition deletion request takes a long time
It looks like you are trying to drop partitions in a table with hierarchical partitioning - where at least a range of the partition keys you intend to drop are in grouped partitions. What is happenin… (View Post)1 -
Re: How to analyse high query performance variabilty?
Dear Joerg - I can see that you have COPY with SOURCE KAFKASOURCE(), meaning that you have activated at least a Kafka source, if not a Vertica Kafka micro batch scheduler. Best practice, indeed, is t… (View Post)1 -
Re: How to generate a stalled truncate query?
A TRUNCATE is a DDL operation, and it requires both an exclusive lock on the truncated table and on the global catalogue. And if it cannot acquire that lock, it waits for 5 minutes, by default. The d… (View Post)1