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

[PERFORM] performance - triggers, row existence etc.

2005-04-09 Thread tv
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 invocations of