Search found 302 matches

by scutter
Sat Nov 14, 2015 3:25 pm
Forum: Vertica Performance Tuning
Topic: INSERT speed highly depends on server load
Replies: 3
Views: 19046

Re: INSERT speed highly depends on server load

One question is whether the INSERTs slowed down because they were queueing on the resource pools, or because system resources were truly pegged. But you definitely don’t want to load large amounts of data using individual INSERT statements. Use COPY - the files don’t need to be local to the server. ...
by scutter
Fri Nov 13, 2015 8:08 pm
Forum: New to Vertica Database Administration
Topic: Partitions and ROS Containers
Replies: 3
Views: 23677

Re: Partitions and ROS Containers

A few additional comments beyond what Jim wrote. - The “active” partitions (1 or more) will have more than one ROS container, until they become “past partitions” - Past partitions may have more than one ROS container. Originally the TM would aggressively merge past partitions into a single ROS conta...
by scutter
Tue Oct 27, 2015 9:52 pm
Forum: Vertica Database Administration
Topic: Vertica Node crashed - help :(
Replies: 7
Views: 21147

Re: Vertica Node crashed - help :(

The ErrorReport.txt that was attached points a finger at a specific query. Does that query consistently cause a node to crash? I know it’s challenging to do that sort of testing where you know that a successful test result means you’ve crashed a node….

—Sharon
by scutter
Wed Oct 14, 2015 10:35 pm
Forum: New to Vertica Database Development
Topic: Can a UDx communicate back to the DB?
Replies: 3
Views: 21492

Re: Can a UDx communicate back to the DB?

Hi Sarah, Suppose you create a UDTF and your logic for the UDTF is in the processPartition() method. You probably wouldn’t want a query to the database to occur within processPartition() because that method will be invoked for every partition of data - so potentially many times on each node. Most UD...
by scutter
Tue Oct 13, 2015 8:31 pm
Forum: New to Vertica Database Development
Topic: Can a UDx communicate back to the DB?
Replies: 3
Views: 21492

Re: Can a UDx communicate back to the DB?

Hi Sarah,

I haven’t written a UDx that does that, but my understanding is that a UDx can do anything that you choose to code. You would need to consider if the UDx is running across multiple partitions in parallel and how that would interract with the database.

—Sharon
by scutter
Tue Sep 29, 2015 2:11 am
Forum: New to Vertica Database Administration
Topic: Resource allocation strategy for a use case
Replies: 3
Views: 7997

Re: Resource allocation strategy for a use case

Hi Fred, You are correct - once a query begins executing, it won’t queue. If the query needs additional memory but can’t get it (in this case because of the maxmemorysize on the resource pool), the query will immediately “fail”. But Vertica will also “retry” queries several times before they truly f...
by scutter
Thu Aug 20, 2015 7:18 pm
Forum: New to Vertica
Topic: "Key Value" feature of Vertica???
Replies: 2
Views: 19277

Re: "Key Value" feature of Vertica???

Do you mean the Routable Query API?
https://my.vertica.com/docs/7.1.x/HTML/ ... erview.htm

—Sharon

Go to advanced search