Should I distribute my inserts on different nodes?
Moderator: NorbertKrupa
Should I distribute my inserts on different nodes?
I have 4 nodes and 4 long running SQL insert as select statements that insert data into the same table. Each insert statement run for hours. Is it better to have 4 connections to one node where each session runs one of the insert statements, or one connection per node per insert statement?
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Should I distribute my inserts on different nodes?
What isolation level are you using? READ COMMITTED allows for concurrent INSERT statements.
Ideally, you should try to batch your loads.
Ideally, you should try to batch your loads.
Checkout vertica.tips for more Vertica resources.
Re: Should I distribute my inserts on different nodes?
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Mon May 04, 2015 10:17 pm, edited 1 time in total.
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Should I distribute my inserts on different nodes?
Great point.id10t wrote:Please clarify what do you mean:
- INSERT INTO <tbl> SELECT ... FROM
- INSERT INTO <tbl> VALUES (...)
Checkout vertica.tips for more Vertica resources.
Re: Should I distribute my inserts on different nodes?
Thanks for the responses, guys!
I am doing 4 "INSERT INTO <tbl> SELECT ... FROM" statements.
So, it's recommended that I do each insert on its own node? That makes sense.
I am doing 4 "INSERT INTO <tbl> SELECT ... FROM" statements.
So, it's recommended that I do each insert on its own node? That makes sense.
Re: Should I distribute my inserts on different nodes?
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Mon May 04, 2015 10:15 pm, edited 1 time in total.
Re: Should I distribute my inserts on different nodes?
Thanks! I get it Makes complete sense, great explanation!