Search found 302 matches
- 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. ...
- 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...
- 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
—Sharon
- 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...
- 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
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
- 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...
- Thu Aug 20, 2015 7:18 pm
- Forum: New to Vertica
- Topic: "Key Value" feature of Vertica???
- Replies: 2
- Views: 19277