Re: Out of memory error - Mailing list pgsql-performance

From Michael Lewis
Subject Re: Out of memory error
Date
Msg-id CAHOFxGouFSFZTvWMD=jb8ZFk9f-mmZAtUGJmwAMhZPO6OqTJMg@mail.gmail.com
Whole thread Raw
In response to Re: Out of memory error  (aditya desai <admad123@gmail.com>)
Responses Re: Out of memory error  (aditya desai <admad123@gmail.com>)
List 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 by date:

Previous
From: aditya desai
Date:
Subject: Re: Out of memory error
Next
From: aditya desai
Date:
Subject: Re: Out of memory error