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

Re: Postgres tuning?

From: "Dann Corbit" <DCorbit(at)connx(dot)com>
To: "Simon Windsor" <simon(dot)windsor(at)cornfield(dot)org(dot)uk>
Cc: "Postgres List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres tuning?
Date: 2004-06-29 23:31:27
Message-ID: 54798A299E68514AB7C4DEBA25F03BE101BAC8@postal.corporate.connx.com (view raw or flat)
Thread:
Lists: pgsql-general
Using the COPY command:
http://techdocs.postgresql.org/techdocs/usingcopy.php
http://www.postgresql.com/docs/7.4/static/sql-copy.html

Using the COPY API:
http://www.postgresql.com/docs/7.4/static/libpq-copy.html

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org 
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of 
> wespvp(at)syntegra(dot)com
> Sent: Tuesday, June 29, 2004 4:02 PM
> To: Simon Windsor; Postgres List
> Subject: Re: [GENERAL] Postgres tuning?
> 
> 
> On 6/29/04 4:30 PM, "Simon Windsor" 
> <simon(dot)windsor(at)cornfield(dot)org(dot)uk> wrote:
> 
> > I am in the process of converting a small multi-user 
> application from 
> > MySQL, and most queries are performing better. The only noticeable 
> > exception is a batch load, which is half the speed of MySQL version.
> 
> If you're talking about loading up and array and telling it 
> to load the array with a single INSERT, you can't do that.  
> You have to insert a record at a time.  I wish it were 
> possible - I could really use it.
> 
> The closest thing is COPY.  I've been told COPY does such a 
> bulk load.  The down side of COPY is that you have to know 
> the column order - ok for initial loads, but dangerous for 
> application usage.
> 
> > begin;
> > insert into ... (repeat a few thousand to million times) commit;
> 
> This does not accomplish the bulk load - it only makes all of 
> the inserts part of a single transaction for atomic commit or 
> rollback.
> 
> Wes
> 
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to 
> majordomo(at)postgresql(dot)org)
> 

pgsql-general by date

Next:From: Alvaro HerreraDate: 2004-06-29 23:35:16
Subject: Re: Postgres tuning?
Previous:From: wespvpDate: 2004-06-29 23:01:51
Subject: Re: Postgres tuning?

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