| From: | "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Cc: | Szabolcs BALLA <szballa(at)confinsystems(dot)com> |
| Subject: | Re: 7.4.7 vs. 8.1 |
| Date: | 2005-12-12 12:04:54 |
| Message-ID: | 20051212120454.GA3356@uio.no |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2005-12-12 13:23:42 | Re: How much expensive are row level statistics? |
| Previous Message | Andy Ballingall | 2005-12-12 09:13:55 | 2 phase commit: performance implications? |