pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedAssimilation of these "versus" and hardware threads
4+ messages / 3 participants
[nested] [flat]
* Assimilation of these "versus" and hardware threads
@ 2005-01-11 18:05 Christian Fowler <spider@viovio.com>
2005-01-11 19:36 ` Re: [PERFORM] Assimilation of these "versus" and hardware threads Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 4+ messages in thread
From: Christian Fowler @ 2005-01-11 18:05 UTC (permalink / raw)
To: pgsql-performance; pgsql-admin list <pgsql-admin@postgresql.org>
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
I snipped a few bits from recent posts to get some pages started - hope
the innocent don't mind. It's a bit postgres biased at the moment, since
well, so am I (though FireBird is now mounting a strong showing...) This
site uses a wiki so anyone interested can make contributions. We are all
short on time, so I would love any help. I haven't entered any hardware
info yet.
I'll also take a minute to plug a postgres saavy open-source project used
for this site - http://www.tikipro.org - It's a very flexible web
framework with a very powerful and extendible CMS engine. It just hit
Alpha 4, and we hope to go beta very soon. If you have feedback (or bugs),
please send me a note. (and of course dbtuning is running on postgres ;-)
[ \ /
[ >X< Christian Fowler | spider AT viovio.com
[ / \ http://www.viovio.com | http://www.tikipro.org
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [PERFORM] Assimilation of these "versus" and hardware threads
2005-01-11 18:05 Assimilation of these "versus" and hardware threads Christian Fowler <spider@viovio.com>
@ 2005-01-11 19:36 ` Josh Berkus <josh@agliodbs.com>
2005-01-11 20:52 ` Re: [ADMIN] Assimilation of these "versus" and hardware threads Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 4+ messages in thread
From: Josh Berkus @ 2005-01-11 19:36 UTC (permalink / raw)
To: Christian Fowler <spider@viovio.com>; +Cc: pgsql-performance; pgsql-admin list <pgsql-admin@postgresql.org>
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [ADMIN] Assimilation of these "versus" and hardware threads
2005-01-11 18:05 Assimilation of these "versus" and hardware threads Christian Fowler <spider@viovio.com>
2005-01-11 19:36 ` Re: [PERFORM] Assimilation of these "versus" and hardware threads Josh Berkus <josh@agliodbs.com>
@ 2005-01-11 20:52 ` Josh Berkus <josh@agliodbs.com>
2005-01-11 21:44 ` Re: [ADMIN] Assimilation of these "versus" and hardware Matthew T. O'Connor <matthew@tocr.com>
0 siblings, 1 reply; 4+ messages in thread
From: Josh Berkus @ 2005-01-11 20:52 UTC (permalink / raw)
To: pgsql-performance; +Cc: Matthew T. O'Connor <matthew@tocr.com>
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [ADMIN] Assimilation of these "versus" and hardware
2005-01-11 18:05 Assimilation of these "versus" and hardware threads Christian Fowler <spider@viovio.com>
2005-01-11 19:36 ` Re: [PERFORM] Assimilation of these "versus" and hardware threads Josh Berkus <josh@agliodbs.com>
2005-01-11 20:52 ` Re: [ADMIN] Assimilation of these "versus" and hardware threads Josh Berkus <josh@agliodbs.com>
@ 2005-01-11 21:44 ` Matthew T. O'Connor <matthew@tocr.com>
0 siblings, 0 replies; 4+ messages in thread
From: Matthew T. O'Connor @ 2005-01-11 21:44 UTC (permalink / raw)
To: Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-performance
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-01-11 21:44 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-01-11 18:05 Assimilation of these "versus" and hardware threads Christian Fowler <spider@viovio.com>
2005-01-11 19:36 ` Josh Berkus <josh@agliodbs.com>
2005-01-11 20:52 ` Josh Berkus <josh@agliodbs.com>
2005-01-11 21:44 ` Re: [ADMIN] Assimilation of these "versus" and hardware Matthew T. O'Connor <matthew@tocr.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