Postgresql Bulk Loading
Postgresql Bulk Loading
От:
"Campano, Troy" <Troy.Campano@LibertyMutual.com>
Дата:
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 ~
Re: Postgresql Bulk Loading
От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
Campano, Troy wrote: > 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 pgman@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