The Hermit Hacker wrote:
> 
> Will you accept modifications to this if submit'd, to make better use of
> features that PostgreSQL has to improve performance?  Just downloaded it
> and am going to look her through, just wondering if it would be a waste of
> time for me to suggest changes though :)

If you can figure out an algorithm that shows these nested messages more
efficiently on postgres, then that would be a pretty compelling reason
to move SourceForge to Postgres instead of MySQL, which is totally
reaching its limits on our site. Right now, neither database appears
like it will work, so Oracle is starting to loom on the horizon.

Tim

-- 
Founder - PHPBuilder.com / Geocrawler.com
Lead Developer - SourceForge
VA Linux Systems
408-542-5723

Wed, 05 Jul 2000 10:00:39 -0700
Tim Perdue <tperdue@valinux.com>
Re: Article on MySQL vs. Postgres

I've taken this offlist with Tim/Ben to see what we can come up with
... the thread is/has become too "heated" to get anything productive done
...


On Wed, 5 Jul 2000, Tim Perdue wrote:

> The Hermit Hacker wrote:
> > 
> > Will you accept modifications to this if submit'd, to make better use of
> > features that PostgreSQL has to improve performance?  Just downloaded it
> > and am going to look her through, just wondering if it would be a waste of
> > time for me to suggest changes though :)
> 
> If you can figure out an algorithm that shows these nested messages more
> efficiently on postgres, then that would be a pretty compelling reason
> to move SourceForge to Postgres instead of MySQL, which is totally
> reaching its limits on our site. Right now, neither database appears
> like it will work, so Oracle is starting to loom on the horizon.
> 
> Tim
> 
> -- 
> Founder - PHPBuilder.com / Geocrawler.com
> Lead Developer - SourceForge
> VA Linux Systems
> 408-542-5723
> 
> 

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 


Wed, 5 Jul 2000 14:01:38 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
Re: Article on MySQL vs. Postgres
> The Hermit Hacker wrote:
> > 
> > Will you accept modifications to this if submit'd, to make better use of
> > features that PostgreSQL has to improve performance?  Just downloaded it
> > and am going to look her through, just wondering if it would be a waste of
> > time for me to suggest changes though :)
> 
> If you can figure out an algorithm that shows these nested messages more
> efficiently on postgres, then that would be a pretty compelling reason
> to move SourceForge to Postgres instead of MySQL, which is totally
> reaching its limits on our site. Right now, neither database appears
> like it will work, so Oracle is starting to loom on the horizon.

All I can say is, "Yikes".  Let's see if we can help this guy.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Thu, 6 Jul 2000 16:45:49 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Article on MySQL vs. Postgres

Way ahead of you :)


Ben and I are workign with Tim on this ... I've provided Ben with an
account on postgresql.org that he can use, with access to a v7.0 database
as well as web ... 



On Thu, 6 Jul 2000, Bruce Momjian wrote:

> > The Hermit Hacker wrote:
> > > 
> > > Will you accept modifications to this if submit'd, to make better use of
> > > features that PostgreSQL has to improve performance?  Just downloaded it
> > > and am going to look her through, just wondering if it would be a waste of
> > > time for me to suggest changes though :)
> > 
> > If you can figure out an algorithm that shows these nested messages more
> > efficiently on postgres, then that would be a pretty compelling reason
> > to move SourceForge to Postgres instead of MySQL, which is totally
> > reaching its limits on our site. Right now, neither database appears
> > like it will work, so Oracle is starting to loom on the horizon.
> 
> All I can say is, "Yikes".  Let's see if we can help this guy.
> 
> -- 
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
> 
> 

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 


Thu, 6 Jul 2000 18:13:31 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
Re: Article on MySQL vs. Postgres