Re: Delete large amount of records and INSERT (with indexes) goes VERY slow

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Delete large amount of records and INSERT (with indexes) goes VERY slow
Дата
Msg-id 3652.1049983204@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Delete large amount of records and INSERT (with indexes) goes VERY slow  (Peter Nixon <listuser@peternixon.net>)
Ответы Re: Delete large amount of records and INSERT (with indexes) goes VERY slow
Список pgsql-general
Дерево обсуждения 
Peter Nixon <listuser@peternixon.net> writes:
> Yes. But that still doesn't explain the speed. I am not joking when I said I
> was getting only ONE INSERT every 30 seconds - 1 minute!!!

The insertion itself couldn't possibly take that long; the problem had
to be in auxiliary operations invoked by the insert.  Do you have any
triggers on that table?  Any foreign references to or from it?  What
indexes are on the table?

            regards, tom lane

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

Предыдущее
От: Himmet Karaman
Дата:
Сообщение: PLEASE HELP ME URGENT about choosing only the ones that i want while entering the data to postgresql with pgaccess on linux or windows or pgadmin II
Следующее
От: Guy Fraser
Дата:
Сообщение: Re: ANN: EMS PostgreSQL Query and PostgreSQL Extract released