pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Assimilation 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