Search found 118 matches
- Wed Dec 16, 2015 8:04 pm
- Forum: New to Vertica Database Administration
- Topic: How is table data stored on disk?
- Replies: 6
- Views: 62833
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 ....
- Wed Mar 11, 2015 6:25 pm
- Forum: Vertica Database Administration
- Topic: Constraint type "Values that are generated by the database"???
- Replies: 3
- Views: 8251
Re: Constraint type "Values that are generated by the database"???
Again, thanks norbertk and Jim! Great great info.
- Wed Mar 11, 2015 6:23 pm
- Forum: Vertica Database Administration
- Topic: Column Level vs Table Level Constraints
- Replies: 4
- Views: 10376
Re: Column Level vs Table Level Constraints
Thanks norbertk and Jim! This is what I needed.
- Tue Mar 10, 2015 11:28 pm
- Forum: Vertica Database Administration
- Topic: Constraint type "Values that are generated by the database"???
- Replies: 3
- Views: 8251
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...
- Tue Mar 10, 2015 11:12 pm
- Forum: Vertica Database Administration
- Topic: Column Level vs Table Level Constraints
- Replies: 4
- Views: 10376
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...
- Tue Sep 30, 2014 3:47 pm
- Forum: Vertica SQL
- Topic: Performance tuning a COUNT DISTINCT
- Replies: 6
- Views: 13228
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 --------------------------------+------------------------------------------------------------------------------------...
- Wed Sep 17, 2014 2:13 pm
- Forum: Vertica SQL
- Topic: Performance tuning a COUNT DISTINCT
- Replies: 6
- Views: 13228
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?
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?