Search found 71 matches

by dbmsuser7
Tue Mar 17, 2015 3:07 pm
Forum: Vertica Database Administration
Topic: vsql search history backwards
Replies: 0
Views: 4639

vsql search history backwards

When I use the command line editor feature of vsql, ^R doesn't function properly. Namely, it just goes to the previous command in the command history. Instead, it should do a backwards search of the command history. In /opt/vertica/config/vsqlrc it has this line \bind ^R history-search-backward # te...
by dbmsuser7
Fri Mar 13, 2015 7:07 pm
Forum: Vertica Database Administration
Topic: Tell planner to do merge join
Replies: 5
Views: 10217

Re: Tell planner to do merge join

OK.

Re posting EXPLAIN here, I'll have to get to it later today or even early next week. I don't know of a good way to anonymize the output other than doing it by hand, and that's taking a long time.
by dbmsuser7
Fri Mar 13, 2015 2:28 pm
Forum: Vertica Database Administration
Topic: Tell planner to do merge join
Replies: 5
Views: 10217

Re: Tell planner to do merge join

I'm happy to share the plan, I can just change table names. Problem is that one of the tables in the plan has no statistics. And I found that if I put stats on it, the plan just explodes---IIRC the planner couldn't even finish planning. Nonetheless I'll post one of the plans in the next hour or so. ...
by dbmsuser7
Thu Mar 12, 2015 6:53 pm
Forum: Vertica Database Administration
Topic: Tell planner to do merge join
Replies: 5
Views: 10217

Tell planner to do merge join

What methods are there for telling the planner to do a merge join? I have an INSERT...SELECT query that creates a huge table. The query is a multiple join of many tables; many of them are quite large. I don't mind the planner using a hash join in the cases where it's unavoidable or one of the tables...
by dbmsuser7
Wed Mar 11, 2015 7:16 pm
Forum: Vertica Database Administration
Topic: standalone pool memory error (concurrent queries)
Replies: 10
Views: 18556

Re: standalone pool memory error (concurrent queries)

We can't really add more projections---these tables are huge, and we're already using lots of license "space". I did use your memorycap suggestion (though I applied it to each session rather than the user). That actually worked. A twist, though, is that one process had 1/4 or so of the amount of dat...
by dbmsuser7
Tue Mar 10, 2015 2:59 pm
Forum: Vertica Database Administration
Topic: standalone pool memory error (concurrent queries)
Replies: 10
Views: 18556

Re: standalone pool memory error (concurrent queries)

It may be worth reviewing if you can make this INSERT more efficient via a merge join.
Do you mean by adding projections, so that the join column/key is sorted in both tables?
by dbmsuser7
Mon Mar 09, 2015 9:46 pm
Forum: Vertica Database Administration
Topic: standalone pool memory error (concurrent queries)
Replies: 10
Views: 18556

Re: standalone pool memory error (concurrent queries)

Thanks again. The only reason why I'm claiming it retried is from what I saw in vertica.log. I'm pretty sure it grabbed more RAM than I wanted it to, then decided t replan, then settled down with a new plan and the RAM I had thought I'd been limiting it to. I'll look into your suggestions---thanks f...

Go to advanced search