Re: Out of memory error

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Out of memory error
Дата
Msg-id CAHOFxGouFSFZTvWMD=jb8ZFk9f-mmZAtUGJmwAMhZPO6OqTJMg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Out of memory error  (aditya desai <admad123@gmail.com>)
Ответы Re: Out of memory error  (aditya desai <admad123@gmail.com>)
Список pgsql-performance
It seems like that function has some syntax errors, and also doesn't do what you want since I presume the "from employee" bit would mean you get many rows inserted into that temp table for all the existing data and not the one row you are operating on at the moment the trigger fires.

It is worth noting also that if bulk operations are at all common for this table then writing this as an after statement trigger will likely be helpful for performance.

For full context, we'd need to see how the function insert_info is defined.

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

Предыдущее
От: aditya desai
Дата:
Сообщение: Re: Out of memory error
Следующее
От: aditya desai
Дата:
Сообщение: Re: Out of memory error