Search found 20 matches

by pborne
Sat Jan 11, 2014 6:44 pm
Forum: New to Vertica
Topic: INSERT IGNORE
Replies: 3
Views: 9804

Re: INSERT IGNORE

@nnani: This is not correct. Before commiting the new data loaded, you can run ANALYZE_CONSTRAINTS() to ask the engine to check constraint violations.

Check this thread:

viewtopic.php?f=48&t=845
by pborne
Sat Jan 11, 2014 6:37 pm
Forum: New to Vertica
Topic: Can not create buddy projection ?
Replies: 3
Views: 12179

Re: Can not create buddy projection ?

4GB per node?? Come on! I have 16GB in my laptop... Buy some RAM.
by pborne
Sat Jan 11, 2014 6:30 pm
Forum: Vertica Data Load
Topic: ERROR 2344: Cannot allocate sufficient memory for COPY ...
Replies: 4
Views: 11793

Re: ERROR 2344: Cannot allocate sufficient memory for COPY

Check the resource pool you are using to load the data.
by pborne
Sat Jan 11, 2014 6:22 pm
Forum: Vertica Database Administration
Topic: Projection Encoding Design
Replies: 4
Views: 9713

Re: Projection Encoding Design

How is your projection segmented?
by pborne
Sat Jan 04, 2014 8:00 pm
Forum: New to Vertica
Topic: Projection questions sort order
Replies: 3
Views: 8893

Re: Projection questions sort order

Just because you can do it doesn't mean you should! Every query can use only one projection per table for the entire query. This means that once the optimizer has determined which one it will use, the other ones become useless! This means that your query will mostly run on one node only if you don't...
by pborne
Sat Jan 04, 2014 7:56 pm
Forum: New to Vertica
Topic: Running multiple databases concurrently
Replies: 3
Views: 11070

Re: Running multiple databases concurrently

It is technically possible to run multiple instances of Vertica on the same cluster at the same time. They would use different port numbers and you have to start them up "by hand" on the command line, not by using admintools. However, this is not supported and obviously not recommended to use in pro...
by pborne
Fri Jan 03, 2014 6:09 pm
Forum: Vertica Performance Tuning
Topic: Can't optimize query
Replies: 2
Views: 7055

Re: Can't optimize query

Make sure you have foreign keys and primary keys defined.

Go to advanced search