Joe Conway <[EMAIL PROTECTED]> writes:
> I did some testing today against mysql and found that it will easily 
> absorb insert statements with 1 million targetlists provided you set 
> max_allowed_packet high enough for the server. It peaked out at about 
> 600MB, compared to my test similar last night where it was using about 
> 3.8 GB when I killed it.

> So the question is, do we care?

What's the performance like relative to mysql?  It seems hard to believe
that we can afford the overhead of a separate INSERT statement per row
(duplicating all the work of parse analysis, rewrite, planning, executor
start/stop) ... at least not without looking mighty bad.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to