Re: [PERFORM] performance - triggers, row existence etc.

2005-04-11 Thread Tambet Matiisen
... > > 2) Is there some (performance) difference between BEFORE and AFTER >triggers? I believe there's no measurable difference. > BEFORE triggers might be faster, because you get a chance to reject the record before it is inserted into table. Common practice is to put validity checks into

Re: [PERFORM] performance - triggers, row existence etc.

2005-04-10 Thread John A Meinel
[EMAIL PROTECTED] wrote: Hello, I'm just in the middle of performance tunning of our database running on PostgreSQL, and I've several questions (I've searched the online docs, but without success). 1) When I first use the EXPLAIN ANALYZE command, the time is much larger than in case of subsequent