Обсуждение: 7.4.7 vs. 8.1

Поиск
Список
Период
Сортировка

7.4.7 vs. 8.1

От
Szabolcs BALLA
Дата:
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





Re: 7.4.7 vs. 8.1

От
"Steinar H. Gunderson"
Дата:
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/