Some info about Vertica trace

[zvika]

Thanks! So you installed the console? Did you install it on its own server? I was think about sticking it on one of my nodes but the docs say not to do that. Maybe I'll just wait until version 6.

Well ... As i said it's not mature enough .
Wait for version 6 if you can .

p.s

yes we installed it on a separate machine .

[sahoo]

Hi ,

I have some issue regarding load balancing

Below is the sql and the output .

select node_name,count(*) from query_requests group by 1;

node_name count
v_pmdb_node0001 77895
v_pmdb_node0002 2393
v_pmdb_node0003 15


I have set the load balance policy to roundrobin and ksafe 1 with 3 nodes


Can you tell me why the load is not distributed ?

[NorbertKrupa]

Can you tell me why the load is not distributed ?

The client must also request a load balanced session (defined by a connection parameter such as ConnectionLoadBalance in ODBC/JDBC). See more in my blog post.