| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | avpro avpro <avprowebeden(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: trigger Before or After |
| Date: | 2014-11-11 13:58:49 |
| Message-ID: | 54621619.2040505@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
On 11/10/2014 10:38 PM, avpro avpro wrote:
> hi,
>
> in the pgsql documentation
> (http://www.postgresql.org/docs/9.1/static/sql-createtrigger.html)
>
> i haven't seen anything referring to: how is affected the data inserted
> in the new table by a trigger Before Insert compared with a trigger
> After Insert? and anything related to performance
See bottom of above page and here:
http://www.postgresql.org/docs/9.1/static/trigger-definition.html
>
> thank you
> have a sunny day
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2014-11-11 15:35:22 | Re: pg_get_expr() hangs with uncommitted DDL transaction |
| Previous Message | Thomas Kellerer | 2014-11-11 12:33:12 | pg_get_expr() hangs with uncommitted DDL transaction |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2014-11-11 17:11:03 | Re: Lock pileup causes server to stall |
| Previous Message | Albe Laurenz | 2014-11-11 08:19:43 | Re: [GENERAL] trigger Before or After |