I have 4 question which probably someone can answer.

1) I have a transaction during which no data was modified, does it
make a difference whether i send COMMIT or ROLLBACK? The effect is the
same, but whatīs about the speed?

2) Is there any general rule when the GEQO will start using an index?
Does he consider the number of tuples in the table or the number of
data pages? Or is it even more complex even if you donīt tweak the
cost setting for the GEQO?

3) Makes it sense to add a index to a table used for logging? I mean
the table can grow rather large due to many INSERTs, but is also
seldom queried. Does the index slowdown noticable INSERTs?

4) Temporary tables will always be rather slow as they canīt gain from
ANALYZE runs, correct?

Thanx in advance for any answer

Christoph Nelles


Mit freundlichen Grüssen
Evil Azrael                          mailto:[EMAIL PROTECTED]

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to