Insert statements really slow
| От | Waller, David |
|---|---|
| Тема | Insert statements really slow |
| Дата | |
| Msg-id | DEC16B2C3347C64BAC476767D0B36229038AC4F7@JACO.sccompanies.com обсуждение исходный текст |
| Ответы |
Re: Insert statements really slow
Re: Insert statements really slow Re: Insert statements really slow |
| Список | pgsql-general |
I have an application that I am porting from MySQL to PostgreSQL and I am working on the import Perl script that process the data.
The data is web log data and each line has a variable amount of the fields (mostly because of cookies) so I am using a lot of insert statements.
In MySQL I go through a file in about 2 minutes and it is taking about 30 in PG. I have removed all but the primary key index and have done a BEGIN and COMMIT after turning off AUTOCOMMIT.
What other things should I be looking at to spped this up?
Dave Waller
В списке pgsql-general по дате отправления: