Search found 11 matches

by sowe
Wed Mar 08, 2017 10:48 pm
Forum: General
Topic: Vertica copy on tables with identity columns
Replies: 3
Views: 9211

Re: Vertica copy on tables with identity columns

Hi!,
Any idea to copy a table with identity field? Because for me is no a option to change all my tables for sequences...
by sowe
Mon Dec 14, 2015 1:18 pm
Forum: Vertica Installation
Topic: Load balancer best option
Replies: 6
Views: 25934

Re: Load balancer best option

done thanks for all
NorbertKrupa wrote:That's correct. See the documentation for client side connection parameters.
by sowe
Sun Dec 13, 2015 11:25 am
Forum: Vertica Installation
Topic: Load balancer best option
Replies: 6
Views: 25934

Re: Load balancer best option

NorbertKrupa wrote:The piece that's usually forgotten is that the client side must also request a load balanced connection for this to work!

Sorry but understood this part , exist a spatial parameter in jdbc or psql connection ?? or .... ?
by sowe
Fri Dec 11, 2015 9:52 pm
Forum: Vertica Installation
Topic: Load balancer best option
Replies: 6
Views: 25934

Re: Load balancer best option

Thanks i'll try thanks
by sowe
Fri Dec 11, 2015 9:38 pm
Forum: Vertica Installation
Topic: Load balancer best option
Replies: 6
Views: 25934

Load balancer best option

Hi all,
I've a cluster with 3 nodes. I want to install a load balancer in this cluster. I'm thinking using HAproxy or a round robin DNS but i don't know if exist a best option. any recomendation or solution?
Thanks
by sowe
Fri Dec 11, 2015 1:15 pm
Forum: New to Vertica SQL
Topic: Explain how to
Replies: 2
Views: 18675

Re: Explain how to

Hi JimKnicely, i run the instruction and follow the documentation https://my.vertica.com/docs/5.0/HTML/Master/16384.htm and https://my.vertica.com/docs/5.0/HTML/Master/14149.htm http://pastebin.com/BvWRNXxQ Thanks for all Hi, First, please run statistics on the tables. Your plan shows that you have ...
by sowe
Wed Dec 09, 2015 1:01 pm
Forum: New to Vertica SQL
Topic: Explain how to
Replies: 2
Views: 18675

Explain how to

Hi all , I've a question, i need optimize a query and i don't know how?. Normally i use explain instruction but the result is too confused [ http://pastebin.com/KbCB0uuH and the query http://pastebin.com/fnm4KJQZ ]. I read the documentation but need help to understand the bottleneck. Any idea? other...

Go to advanced search