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@libertyrms.info> M2P 2A8
+1 416 646 3304 x110