| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: 1 milion data insertion |
| Date: | 2002-07-26 18:46:55 |
| Message-ID: | 20020726144655.K18001@mail.libertyrms.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
On Fri, Jul 26, 2002 at 03:34:12PM -0300, Elielson Fontanezi wrote:
>
> the log has overflowed.
No, new WAL files were created. You can increase the number of
preallocated WAL files so that you don't get these messages. See the
administrator docs.
> But, from you, great PostGres DBA's, what is the best way to
> insert a large number of data?
With COPY, just as you did.
> Is there a way to turn off the log?
No.
> Is there a way to commit each 100 records?
Sure. Use Perl or something to copy and commit every so many records.
A
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Elielson Fontanezi | 2002-07-26 18:58:48 | The best book |
| Previous Message | Marc Spitzer | 2002-07-26 18:46:00 | Re: 1 milion data insertion |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Albertson | 2002-07-26 19:15:06 | Re: 1 milion data insertion |
| Previous Message | Marc Spitzer | 2002-07-26 18:46:00 | Re: 1 milion data insertion |