pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
how many inserts in one transaction?
2+ messages / 2 participants
[nested] [flat]

* how many inserts in one transaction?
@ 2000-01-22 21:15  gav <gav@nlr.ru>
  0 siblings, 1 reply; 2+ messages in thread

From: gav @ 2000-01-22 21:15 UTC (permalink / raw)
  To: pgsql-sql

Hi,

I have a database created in postgres 6.5.3 and need insert huge
number (~10-100 thousands) of
rows in one of tables. To do that quickly I put this part of work in
transaction. My question is such: should I split this block of
insertings into many transaction to raise the speed? And
exists the limit of INSERT-commands that I can do in one transaction?

Best regards,
Alex





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [SQL] how many inserts in one transaction?
@ 2000-01-23 07:21  Christopher Sawtell <csawtell@xtra.co.nz>
  parent: gav <gav@nlr.ru>
  0 siblings, 0 replies; 2+ messages in thread

From: Christopher Sawtell @ 2000-01-23 07:21 UTC (permalink / raw)
  To: gav <gav@nlr.ru>; +Cc: pgsql-sql

On Sun, 23 Jan 2000, you wrote:
> Hi,
> 
> I have a database created in postgres 6.5.3 and need insert huge
> number (~10-100 thousands) of
> rows in one of tables. To do that quickly I put this part of work in
> transaction. My question is such: should I split this block of
> insertings into many transaction to raise the speed? And
> exists the limit of INSERT-commands that I can do in one transaction?

Do not forget that you can use COPY to create a table in PostgreSQL.

It copies from a delimited operating system text file to a PostgreSQL table.
 
Someting like this:-


CREATE TABLE district ( number serial, name varchar(25));

copy district from '/home/chris/iopen/schools/database/districts.txt' USING DELIMITERS '~';

--
Sincerely etc.,

 NAME       Christopher Sawtell - Support Engineer - iOpen Technologies Ltd.
 CELL PHONE 021 257 4451
 ICQ UIN    45863470
 EMAIL      chris @ iopen . co . nz,  csawtell @ xtra . co . nz
 CNOTES     ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz

 ---->>> Please refrain from using HTML attachments in e-mails to me. <<<----




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2000-01-23 07:21 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-01-22 21:15 how many inserts in one transaction? gav <gav@nlr.ru>
2000-01-23 07:21 ` Christopher Sawtell <csawtell@xtra.co.nz>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox