From: Evil Azrael <evilazrael@evilazrael.de>
To: pgsql-performance@postgresql.org
Subject: Various Questions
Date: Mon, 1 Dec 2003 14:07:50 +0100
Message-ID: <924548300.20031201140750@evilazrael.de> (raw)
Hi!
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:evilazrael@evilazrael.de
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: evilazrael@evilazrael.de
Subject: Re: Various Questions
In-Reply-To: <924548300.20031201140750@evilazrael.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox