COPY FROM how long should take ?

Поиск
Список
Период
Сортировка
Искать
От
Condor
Тема
COPY FROM how long should take ?
Дата
Msg-id
28a8ab0473dd9f84460fdaeb876f0c3c@stz-bg.com
Список
Дерево обсуждения
COPY FROM how long should take ? Condor <condor@stz-bg.com>
Re: COPY FROM how long should take ? Jayadevan M <Jayadevan.Maymala@ibsplc.com>
Re: COPY FROM how long should take? Condor <condor@stz-bg.com>
Re: COPY FROM how long should take ? pasman pasmański <pasman.p@gmail.com>
Hello,
today I try to restore on of my tables with copy from file that I made 
before.
The file is 2.4 GB, only integers ... took me 3 hours and 30 min and I 
hit
CTRL+C on i7 processor with 8 GB memory, sata 2 hard drive. I modify 
some
psql conf file values and increase memory, work, wal, temp, check point 
segments to 55
Is that normal ? Whole file is 37 mil lines. When I hit enter it was on 
line
as logs says 26 million. I run it twice and second time after 45 min I 
again hit
CTRL+C and in logs I see it was again on 26 million line. Well, the 
line number
is approximately. Is everything normal ?

Postgresql 9.0.4

-- 
Regards,
Condor
В списке pgsql-general по дате отправления
От: Massa, Harald Armin
Дата:
От: Merlin Moncure
Дата:
FAQ