Re: COPY ... FROM and index usage
| От | Dimitri Fontaine |
|---|---|
| Тема | Re: COPY ... FROM and index usage |
| Дата | |
| Msg-id | 200711041901.55596.dfontaine@hi-media.com обсуждение исходный текст |
| Ответ на | COPY ... FROM and index usage (Reg Me Please <regmeplease@gmail.com>) |
| Ответы |
Re: COPY ... FROM and index usage
|
| Список | pgsql-general |
Hi, Le Sunday 04 November 2007 11:22:19 Reg Me Please, vous avez écrit : > That is, should I drop all indexes during a "COPY ... FROM" in order to > gain the maximum speed to load data? When looking for a way to speed up data loading, you may want to consider pgbulkload, a project which optimizes index creation while loading data, and bypass constraints: it's useful when you know you trust input. As I've never used it myself, I can only provides following links: http://pgfoundry.org/projects/pgbulkload http://pgfoundry.org/docman/view.php/1000261/456/20060709_pg_bulkload.pdf Regards, -- dim
В списке pgsql-general по дате отправления: