Re: Insert taking too long

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Insert taking too long
Дата
Msg-id 7134.1194886162@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Insert taking too long  ("Blanco, Jose" <blancoj@umich.edu>)
Список pgsql-bugs
"Blanco, Jose" <blancoj@umich.edu> writes:
> 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.

This is not a bug.

You might get some help on pgsql-performance, but you'll need to provide
a lot more information about what your script is doing.

            regards, tom lane

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

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