Re: help impressing the crowd (fwd) - Mailing list pgsql-hackers

This is a post from mod_perl mailing list. I think it would be interesting
to have a *real* benhcmarks, say more or less standard Web+db application
with using modern technique like mod_perl and persistent connection to db.
I'm using postgres since 1995 and quite satisfied with  its features and
fast development, and support from mailing list. But in real life
every project needs good presentation and it's very difficult to 
explain your boss or customer that Postgres is a good software without
real benchmarks and happy stories. Also, good web site is very important,
especially for attracting of new users. There was a thread in mailing list
about new feel'n look of www.postgresql.org and I saw some very promising
variants, what's going with this ?
Regards,
    Oleg

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

---------- Forwarded message ----------
Date: Sat, 08 May 1999 14:03:39 +0000
From: Matt Sergeant <matt@sergeant.org>
To: Steve Maring <smaring@gte-es.com>
Cc: sbekman@iil.intel.com, modperl@apache.org
Subject: Re: help impressing the crowd

Steve Maring wrote:
> 
> I'm working on a customer support site for GTE Enterprise Solutions.  We
> provide real estate MLS services to REALTOR associations around the
> country.  The total customer base is about 120,000 and quickly growing.
> The site will be a main source of information for customers.  It uses
> mod_perl, OpenSSL, HTML::Embperl, Apache::Session, and PHP3 for some
> legacy stuff.  It has an architecture that feeds everything dynamically
> from a database using session management and per user routing and access
> restrictions.  I am in the process of studying design patterns right now
> to see what the best fit is for this application.  I will then be
> optimizing for database connections, database performance (PostgreSQL),
           ^^^^^^^^^^^^
 

We've found PostgreSQL to be a severe bottleneck on our system. We're
not sure how much of a speedup we can get by migrating to a better DBMS,
but we're fairly sure it would be good. Unfortunately postgreSQL just
isn't fast enough for a high transaction web site IMHO. We just haven't
had time yet to transfer it to MySQL or SQL Server (hack, puke,
choke..). But we have done some profiling that indicated that postgreSQL
was the bottleneck. All this and we're parsing XML on the server too...
(for those that don't know - XML parsing is quite a bad bottleneck in
itself).

Can't really help Stas out with the link though - it's intranet stuff
only. Although it is a company wide timesheet system for 600 (so far)
users. Going very well. I may be giving a presentation at TPC, so I
don't really want any spoilers.

-- 
<Matt/>

| FastNet Software Ltd   |   XML   |   Perl   |  Databases |
| http://come.to/fastnet | Bringing your data onto the Web |
| See web site for details, articles, FAQ's and more       |
| ICQ# 14968768          | Email for contract availabilty  |