pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / 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> 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 12:04 Steinar H. Gunderson <sgunderson@bigfoot.com> parent: Szabolcs BALLA <szballa@confinsystems.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