pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedhow 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>
2000-01-23 07:21 ` Re: [SQL] how many inserts in one transaction? Christopher Sawtell <csawtell@xtra.co.nz>
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-22 21:15 how many inserts in one transaction? gav <gav@nlr.ru>
@ 2000-01-23 07:21 ` Christopher Sawtell <csawtell@xtra.co.nz>
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