Re: [ADMIN] [PERFORM] Assimilation of these "versus" and hardware threads
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
Josh Berkus wrote: 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? Nope, been there since before 7.4 was released. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [ADMIN] [PERFORM] Assimilation of these "versus" and hardware threads
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