Vertica - Please include option to disable comments altogether

[alattke-chwy]

This is related to issue #14625 .
Reading from comments system table (even though it is not populated in our DB) takes a long time and is I/O intensive.
I am on version 22.0.4.202205011839.
Please provide an option to disable comments altogether as it takes 14s in test env and over a min in a busy prod cluster.

[LonwoLonwo]

Ok, thanks for the idea.

[alattke-chwy]

Hi @LonwoLonwo . We are in the process of reviewing DBeaver vs DBVisualizer. Could you let me know if this bug fix is on the roadmap?

[LonwoLonwo]

We added lazy comments loading in #16396

Now tables loading should be faster in DBeaver.

[LonwoLonwo]

So for now it is interesting to know - what type of comments prepare you disable now?

[alattke-chwy]

Thanks for replying. I updated to Version 22.1.0.202206051253. I no longer see this in the Navigation panel, but the Object Properties tab/panel it still happens.

When an object (ex. Table) is opened, this query that is being executed is:

request | select object_type, "comment", child_object from v_catalog.comments where object_schema ='${OBJECT_SCHEMA}' and object_name ='${OBJECT_NAME}'
min_duration_ms     | 11660
max_duration_ms     | 12533
sum_duration_ms     | 24193
count   | 2

So, 2 identical queries, each taking ~12s are running consecutively when building object and tapping into comments system table. (Also, 12s is in an idle system, on a busy system like our prod cluster this takes more than 30s).
If there's an option to disable this in the settings, I am not seeing it.

Thank you!

[LonwoLonwo]

There is no option for now. But it is in our plans.

[alattke-chwy]

Thank you!

[alattke-chwy]

Hi! Can anyone provide an update on this please?

[LonwoLonwo]

Hello @alattke-chwy

You can see more data about this ticket in the "Milestone" section.

[alattke-chwy]

Hi. Can someone provide an update to this ticket please?

[alattke-chwy]

@LonwoLonwo could you please provide an update on this?

[LonwoLonwo]

[LonwoLonwo]

Implemented.

Available in the last DBeaver release.