Hi,

I am ready to install ver. 8.1 to our db server, but I have some
questions about it.
When I use autovacuum (8.1) is it required to use "vacuum analyze" for
maintenance or autovacuum is enough?
We have 2 processors (hyperthread) and is it needed to configure the
psql to use it or is it enough to configure the kernel base only?
Is 8.1 stable?

Thanks
Szabek





---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

On Mon, Dec 12, 2005 at 09:54:30AM +0100, Szabolcs BALLA wrote:
> When I use autovacuum (8.1) is it required to use "vacuum analyze" for
> maintenance or autovacuum is enough?

autovacuum should be enough.

> We have 2 processors (hyperthread) and is it needed to configure the
> psql to use it or is it enough to configure the kernel base only?

Turn _off_ hyperthreading; it's more likely to do harm than good.

> Is 8.1 stable?

Yes. Note that 8.1.1 should be out quite soon.

/* Steinar */
--
Homepage: http://www.sesse.net/

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend