Database start time accuracy

[piglet]

Hi,

I hope everyone is doing well.

Hey, has anyone noticed any problems with the accuracy of the date and time returned from the start_time column of the databases system table?

Code: Select all

dbadmin=> select * from databases;
-[ RECORD 1 ]------+-------------------------------------------------------------
database_id        | 45025996275704964
database_name      | sales01
owner_id           | 45025996275704962
owner_name         | dbadmin
start_time         | 2012-08-17 08:02:54.035238-04
compliance_message | The database is in compliance with respect to raw data size.
export_subnet      | 0

This is a production database and I've not restarted the database in months! I'm not sure why it is reporting it was started on 08/17/2012...

Thanks!

[id10t]

Hi!

It because error_tolerance and confidence_level. Vertica do not performs FULL audit coz' it expensive and you can see it by error estimation in select get_compliance_status(); and check in table/s LICENSE_AUDITS and USER_AUDITS