From: | Lukas Kahwe Smith <smith(at)pooteeweet(dot)org> |
---|---|
To: | Brian Hurt <bhurt(at)janestcapital(dot)com> |
Subject: | Re: Postgres vr.s MySQL- style differences? |
Date: | 2007-05-28 19:31:59 |
Message-ID: | 465B2E2F.3030605@pooteeweet.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy |
Brian Hurt wrote:
>
> Take, for example, inserting large numbers of records into a table. As
> someone who was raised on Postgres (so to speak), when loading large
> numbers (more than 10 or so) records into a table I immediate start
> reaching for a copy command. And our code base is littered with copies-
> from simple programs that given a CSV file and a table name burst-load a
> table, to complicated libraries that use multithreaded queues and switch
> between copies and transactional inserts depending upon how much data
> needs to be copied. But someone used to MySQL would just start firing
> off lone, non-transactional insert statements, and their code base
> wouldn't contain such programs or libraries.
Just to make sure that nobody gets confused here. MySQL has LODA DATA
INFILE as their COPY alternative, which performs marvelously.
regards,
Lukas
From | Date | Subject | |
---|---|---|---|
Next Message | Lukas Kahwe Smith | 2007-05-28 19:37:53 | Re: Postgres vr.s MySQL- style differences? |
Previous Message | Andrew Sullivan | 2007-05-28 15:01:07 | Re: Postgres vr.s MySQL- style differences? |