Re: [ADMIN] [PERFORM] Assimilation of these versus and hardware threads

[Josh Berkus]

People:

 All of these recent threads about fastest hardware and who's better than
 who has inspired me to create a new website:

 http://www.dbtuning.org

Well, time to plug my web site, too, I guess:
http://www.powerpostgresql.com

I've got a configuration primer up there, and the 8.0 Annotated .Conf file 
will be coming this week.

That web site runs on Framewerk, a PostgreSQL-based CMS developed by our own 
Gavin Roy.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


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

Re: [ADMIN] [PERFORM] Assimilation of these versus and hardware threads

[Josh Berkus]

Matt,

 I had one comment on the pg_autovacuum section.  Near the bottom it
 lists some of it's limitations, and I want to clarify the 1st one: Does
 not reset the transaction counter.  I assume this is talking about the
 xid wraparound problem?  If so, then that bullet can be removed.
 pg_autovacuum does check for xid wraparound and perform a database wide
 vacuum analyze when it's needed.

Keen.   That's an 8.0 fix?

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

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

   http://archives.postgresql.org