Hi, We have a web-app platform that uses Vertica server. Our machines are on cloud, from AWS. Vertica cluster has 3 nodes, m3.2xlarge, 8 vCPU, 30 GB memory. SIze of the db files - 25 GB. The database contains around 10 tables, maximum 15.000.000 records/table, 1000 columns/table. The tables have onl...

Hi,
We have 2 clusters (3 nodes) on AWS.
They are working well.
Veronica

Using the following select : select --i.node_name,i.session_id,i.transaction_id,i.statement_id,i.request_id, i.time,i.request, r.memory_acquired_mb, r.request_duration_ms , r.success, a.request_type, a.pool_name, a.memory_inuse_kb/1024 memory_inuse_mb, a.acquisition_timestamp, a.release_timestamp, e...

Vertica Analytic Database v7.1.1-0

On mc-activity-resource pool monitoring-query details by pools in xxxx_pool, I see for each query , one row for each node. For the queries that are running, I have 3 rows (=3nodes) , with the same transaction_id, column 'Execution ended'= 'Currently running' , column 'memory usage'=2,5G. Also, for o...

Hi, I have the following situation: - resource pool configured to use max 25 G memory create resource pool xxxx_pool memorysize '30%' maxmemorysize '95%' priority 100 runtimepriority MEDIUM runtimeprioritythreshold 30 queuetimeout 120 runtimecap '10 seconds' cascade to general - 6 SELECTs running, t...

solved

The Vertica server is installed on Amazon EC2. There was an issue related to the instance/machine : "The instance is running on degraded hardware"