Search found 23 matches

Go to advanced search

by Rick
Wed Aug 01, 2012 4:28 pm
Forum: New to Vertica Database Administration
Topic: Dropping data does not free space
Replies: 3
Views: 8002

Re: Dropping data does not free space

move the ancient history mark?

also, have you committed the purge/deletion? (I cant remember if you have to commit or not lol)
by Rick
Wed Aug 01, 2012 4:12 pm
Forum: DBeaver
Topic: DBeaver Forum Link
Replies: 4
Views: 24431

Re: DBeaver Forum Link

I'd guess mySQL
by Rick
Wed Aug 01, 2012 4:02 pm
Forum: Vertica Data Load
Topic: SQL Server vs. Vertica Bulk Load
Replies: 6
Views: 17840

Re: SQL Server vs. Vertica Bulk Load

Seems consistent. Some benchmarking I did recently allowed me to load 1,228,260 rows Vertica in 16.3 seconds copying from a file.

Vertica is pretty nippy.
by Rick
Wed Aug 01, 2012 10:10 am
Forum: Vertica Database Administration
Topic: Read Only User
Replies: 3
Views: 13340

Re: Read Only User

Code: Select all

=> create role rolename;
=> grant usage on schema schemaname to rolename;
=> grant select on schemaname.table name to rolename;
=> grant rolename to username
=> alter user username default role rolename
by Rick
Tue Jul 31, 2012 2:28 pm
Forum: Vertica Performance Tuning
Topic: Slow Inserts
Replies: 7
Views: 20645

Re: Slow Inserts

Use copy instead if you can. Much faster
by Rick
Tue Jul 31, 2012 9:21 am
Forum: Vertica SQL
Topic: Alternative to CHECK
Replies: 4
Views: 10075

Re: Alternative to CHECK

Thanks :)
by Rick
Mon Jul 30, 2012 2:08 pm
Forum: Vertica SQL
Topic: Alternative to CHECK
Replies: 4
Views: 10075

Alternative to CHECK

I'm running Vertica 5, and i noticed that when making tables, vertica apparantly doesn't support CHECK constraints. I was wondering if there is any alternative to this in vertica?
Thanks

Go to advanced search