[GENERAL] usage of indexes for inner joins

2007-09-27 Thread Jan Theodore Galkowski
I fear this has been asked many times about PostgreSQL, and I have read the docs about how indexes are supposed to be defined and used, but I don't understand why the engine and optimizer is doing what it does in the simplest of situations. Is it that its tuning is heavily data dependent? My case

Re: [GENERAL] usage of indexes for inner joins

2007-10-01 Thread Jan Theodore Galkowski
thanks for all your useful comments. i will study all of them. a couple of inline comments below, just for clarification to the group, marked with asterisks. On Mon, 1 Oct 2007 13:13:23 -0500, "Scott Marlowe" <[EMAIL PROTECTED]> said: > On 10/1/07, Jan Theodore Galkowsk

[GENERAL] time penalties on triggers?

2007-10-04 Thread Jan Theodore Galkowski
Does anyone know, or can anyone point to information about how much triggers penalize inserts in PG tables? I'm getting a report that it is substantial, and before I investigate more. The triggers in question look like: # # CREATE OR REPLACE FUNCTION touch_lasttouched() RETURNS TRIGGER AS $touch_