How to calculate the table size, which is right select audit('table_name','table'); select object_schema,object_name,size_bytes/power(1024,3) "Size(GB)" from user_audits where object_schema='object_schema'; is shows the size of the table as 21gb select sum(used_bytes) as used_bytes, sum(ros_used_byt...

Hi,

I am trying to understand the difference between segmented projections and bubby projections. Does segmented projections called buddy projections and how does Vertica allocate space and reclaim space after dropping or running manual purge.


Thanks
VerticaDBA

Hi,

We want to refresh Vertica database from production to a dev box and want it make as a automatic process.
Has anyone done this before and do you have the steps to a do this without causing an outage


Thanks

Hi Jm can you let me know what's my next step is


Thanks

Hi Jim,

It says

authentication_method
-----------------------
Unknown
(1 row)


Thanks

I am running into a security issue with testing my ldap authentication. The parameter I am passing is ClientAuthentication = local all ldap “ldap://xxxxxxxxxx/CN=xxxxxx,CN=Users,DC=xxxxx,DC=xxx,DC=xxxxxx,DC=xxxxx" The test account name is testldap and with I login as vsql -Utestldap it logs me in wi...

This is awesome, thank you