Re: Plz Heeeelp! performance settings

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Plz Heeeelp! performance settings
Дата
Msg-id 489B1004.4050105@archonet.com
обсуждение исходный текст
Ответ на Database size Vs performance degradation  ("Dave North" <DNorth@signiant.com>)
Список pgsql-performance
dforums wrote:
 > The delete is global, the procedure is called for each line/tracks.
 >  > So - are you calling this function 14000 times to inject your data?
 >  > You're doing this in one transaction, yes?
 > NO I have to make it 14000 times cause, I use some inserted information
 > for other insert to make links between data.

Why does that stop you putting all 14000 calls in one transaction?


--
   Richard Huxton
   Archonet Ltd

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

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Plz Heeeelp! performance settings
Следующее
От: "Joshua Shanks"
Дата:
Сообщение: Re: query planner not using the correct index