Search found 118 matches

by becky
Wed Dec 16, 2015 8:04 pm
Forum: New to Vertica Database Administration
Topic: How is table data stored on disk?
Replies: 6
Views: 8427

Re: How is table data stored on disk?

Hi guys, I upgraded to 7.2. I not I thought that the only files asscoiated with data are the .fb and .pidx files. But I now see .gt files: [dbadmin@BK 277]$ ls -lrt total 4 -rw------- 1 dbadmin verticadba 438 Dec 16 13:50 0267ea83948962386adc79978bf46adc00a0000000024745_0.gt Anyone know what these ....
by becky
Wed Mar 11, 2015 6:23 pm
Forum: Vertica Database Administration
Topic: Column Level vs Table Level Constraints
Replies: 4
Views: 1201

Re: Column Level vs Table Level Constraints

Thanks norbertk and Jim! This is what I needed.
by becky
Tue Mar 10, 2015 11:28 pm
Forum: Vertica Database Administration
Topic: Constraint type "Values that are generated by the database"???
Replies: 3
Views: 915

Constraint type "Values that are generated by the database"???

Me again :) I have another question about constraints. The Admin Guide mentions a constraint type "Values that are generated by the database". What is that? Here is the link: http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/AdministratorsGuide/Constraints/WorkingWithConstraints.htm%3FTocPat...
by becky
Tue Mar 10, 2015 11:12 pm
Forum: Vertica Database Administration
Topic: Column Level vs Table Level Constraints
Replies: 4
Views: 1201

Column Level vs Table Level Constraints

Hi guys, In most databases there are column level constraints which have scope only to the column it is defined, and table level constraints which can see every column in the table. Does that concept exist in Vertica? Or are all of the constraint types (PK, FK, NOT NULL and DEFAULT) at the column le...
by becky
Tue Sep 30, 2014 3:47 pm
Forum: Vertica SQL
Topic: Performance tuning a COUNT DISTINCT
Replies: 6
Views: 1845

Re: Performance tuning a COUNT DISTINCT

Anyone know what these parameters do? dbadmin=> select parameter_name, description from configuration_parameters where parameter_name ilike '%distinct%'; parameter_name | description --------------------------------+------------------------------------------------------------------------------------...
by becky
Wed Sep 17, 2014 2:13 pm
Forum: Vertica SQL
Topic: Performance tuning a COUNT DISTINCT
Replies: 6
Views: 1845

Re: Performance tuning a COUNT DISTINCT

Thanks, guys.

I tried the approximate count distinct function and the query never returns! Well, I let it run for about two minutes and just canceled it. The COUNT DISTINCT is faster in my database. Is that weird?

:o :shock: :o

Go to advanced search