Large table load (40 millon rows) - WAL hassles
От
simon@gonzo.magellic.com (simon lai)
Тема
Large table load (40 millon rows) - WAL hassles
Дата
Msg-id
slrn9k7af7.1cl.simon@gonzo.magellic.com
Список
Дерево обсуждения
Large table load (40 millon rows) - WAL hassles simon@gonzo.magellic.com (simon lai)
Re: Large table load (40 millon rows) - WAL hassles Bruce Momjian <pgman@candle.pha.pa.us>
Version: Postgres 7.1.2 A product we are developing requires frequent loading of a large number of rows into a table. We are using the "copy file" command, but with WAL we are effectively doubling the amount of disk writing we are doing. After the rows are loaded we do a "create index". Is there a way to turn off WAL or otherwise speeding up the table loading process? Would db_restore be faster? The rows are loaded in sorted order. Does this impact index creation negatively or positively? We are currently working with test data but we estimate production data to be 6 - 9 billion rows. Is anyone else running with these volumes? Simon
В списке pgsql-general по дате отправления