Insert taking too long

Поиск
Список
Период
Сортировка
От Blanco, Jose
Тема Insert taking too long
Дата
Msg-id E0217C87D1BA1043AC897ACFA468CEE60148C2F1@ECLUST2-VS3.adsroot.itcs.umich.edu
обсуждение исходный текст
Ответ на Re: Postgresql Domain Names  (Linda O <linda@artemiswoman.com>)
Ответы Re: Insert taking too long  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Recently, we ran an 'vacummdb --full' on our database, and I'm finding
that a scrip that use to take just a couple of ours to run, is now
taking 12 hours to run.  It's a perl script that does a lot of inserting
into a few tables.  I've tried dropping indices to speed up the inserts,
but this does not help.  I'm kind of lost as to why this is happening.
Any ideas out there?

Thanks!
Jose

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Jawad Hussain"
Дата:
Сообщение: BUG #3745: I am unable to load the data in postgresql DB
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Insert taking too long