Re: No flamefest please, MySQL vs. PostgreSQL AGAIN - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: No flamefest please, MySQL vs. PostgreSQL AGAIN
Date
Msg-id 20030513121031.GB17278@libertyrms.info
Whole thread Raw
In response to Re: No flamefest please, MySQL vs. PostgreSQL AGAIN  (timeless postgres <pvspam-postgres@hacklab.net>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: No flamefest please, MySQL vs. PostgreSQL AGAIN
Next
From: Andrew Sullivan
Date:
Subject: Re: database running slow