The Vertica Database Forums

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?

What isolation level are you using? READ COMMITTED allows for concurrent INSERT statements.

Ideally, you should try to batch your loads.

Hi!

[DELETED]

id10t wrote:Please clarify what do you mean:

• INSERT INTO <tbl> SELECT ... FROM
• INSERT INTO <tbl> VALUES (...)

Great point.

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.

Hi!

[DELETED]

Thanks! I get it Makes complete sense, great explanation!