Re: [PATCHES] 8.2 features?

Joe Conway <mail@joeconway.com> 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