pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
7.4.7 vs. 8.1
2+ messages / 2 participants
[nested] [flat]

* 7.4.7 vs. 8.1
@ 2005-12-12 08:54 Szabolcs BALLA <szballa@confinsystems.com>
  2005-12-12 12:04 ` Re: 7.4.7 vs. 8.1 Steinar H. Gunderson <sgunderson@bigfoot.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Szabolcs BALLA @ 2005-12-12 08:54 UTC (permalink / raw)
  To: pgsql-performance

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







^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: 7.4.7 vs. 8.1
  2005-12-12 08:54 7.4.7 vs. 8.1 Szabolcs BALLA <szballa@confinsystems.com>
@ 2005-12-12 12:04 ` Steinar H. Gunderson <sgunderson@bigfoot.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Steinar H. Gunderson @ 2005-12-12 12:04 UTC (permalink / raw)
  To: pgsql-performance; +Cc: Szabolcs BALLA <szballa@confinsystems.com>

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/



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-12-12 12:04 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-12-12 08:54 7.4.7 vs. 8.1 Szabolcs BALLA <szballa@confinsystems.com>
2005-12-12 12:04 ` Steinar H. Gunderson <sgunderson@bigfoot.com>

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