Postgres Pro
Downloads
Home   >   mailing lists

Re: [PHP] Data insert - Mailing list pgsql-admin

From Jim C. Nasby
Subject Re: [PHP] Data insert
Date
Msg-id 20050823005752.GI17203@pervasive.com
Whole thread Raw
In response to Data insert  (Postgres Admin <postgres@productivitymedia.com>)
List pgsql-admin
Tree view 
On Sun, Aug 21, 2005 at 06:35:22AM +0100, Aldor wrote:
> if you want to insert biiig data volumes try either using COPY instead
> of INSERT - it will run much much faster

And if for some reason you have to stick with inserts, group them into
transactions; it will perform much better than individual transactions.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software        http://pervasive.com        512-569-9461

pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: postgres optimization (effective_cache_size)
Next
From: "Sivakumar K"
Date:
Subject: Re: error codes in postgresql