Re: No flamefest please, MySQL vs. PostgreSQL AGAIN

On Mon, May 12, 2003 at 04:02:42PM -0700, timeless postgres wrote:
> Maybe I don't understand how to ask the question. I want to know how to
> insert (say) 10M rows into a table quickly. I mean... VERY quickly.

You probably want a different word from "insert", since it has a
specific meaning.

> Would it be faster if I put a single transaction around that? Would it
> be faster to do the following?

Yes, you want COPY. It's the fastest.

> > [point-in-time recovery] might be there in 7.4 ... it ain't there today
>
> Would it be better to hang out on hackers to find out about this?

Probably.

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110