Discussion:
Postgresql Bulk Loading
(too old to reply)
Campano, Troy
2004-05-26 14:44:02 UTC
Permalink
Does Postgresql have a bulk loading utility that allows you to load
large amounts of data and doesn't write to log files (WAL files) ?

I need to load over a gig of data a day and don't want it to write to
logs.





Thank you!



~ Troy Campano ~
Bruce Momjian
2004-05-26 15:12:54 UTC
Permalink
Post by Campano, Troy
Does Postgresql have a bulk loading utility that allows you to load
large amounts of data and doesn't write to log files (WAL files) ?
I need to load over a gig of data a day and don't want it to write to
logs.
No. We have COPY that does the load quickly, but it does still write
WAL files. However, those get recycled so it should be fast.
--
Bruce Momjian | http://candle.pha.pa.us
***@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org
Loading...