Skip site navigation (1) Skip section navigation (2)

Re: Postgres vr.s MySQL- style differences?

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 (view raw or flat)
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

In response to

pgsql-advocacy by date

Next:From: Lukas Kahwe SmithDate: 2007-05-28 19:37:53
Subject: Re: Postgres vr.s MySQL- style differences?
Previous:From: Andrew SullivanDate: 2007-05-28 15:01:07
Subject: Re: Postgres vr.s MySQL- style differences?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group