On Wed, 18 Apr 2001, Differentiated Software Solutions Pvt. Ltd., wrote:
> Hi,
>
> There are 4 responses to our results. We will answer them to the best of our ability.
>
> MATT >This is a very very old version of postgresql. Try it again with 7.1 for
> MATT >more respectable results.
>
> Accepted. We knew this when we conducted the benchmarks. We've had
> terrible experience with postgres. Firstly on performance and more
> importantly on availablity. Some of you should try pounding postgres
> with upwards of 25 queries a second and see the results. The postgres
> server will spew out error messages and shutdown. Last year we had a
> several nightouts writing code to protect postgres from an overload of
> queries. I've written several mails to postgres mailing lists and even
> to mod_perl in desperation. Problem wasn't solved.
It's unlikely that anyone is going to be able to look into problems with
6.5.3, especially if you haven't tried the latest version yet.
> We'll try out 7.1. Maybe it is a major improvement over 6.5.3. I find
> it difficult to believe that it will improve performance by 36 times
> !!!!
No, but you can scale it to >1 web server a lot easier with a proper DB
backend.
> Here I have to add. We met one of Oracle support people in India
> to know whether Oracle will be a good alternative. He was a nice guy
> and told us that postgres is a thinner DB and should perform better
> under most circumstances. People go in for Oracle more for features
> and perhaps corporate support not for performance !!!!!!
He obviously doesn't know much about his product. A well tuned Oracle
(with an appropriate amount of memory - which 64M isn't) would easily
outperform postgresql 6.5.3, though I'm not so sure about 7.1. Make no
mistake - Oracle is fast when done right, and it scales like no
tomorrow. But you need good Oracle sysadmins for that (as you do with any
serious relational database - postgresql being no exception).
--
<Matt/>
/|| ** Founder and CTO ** ** http://axkit.com/ **
//|| ** AxKit.com Ltd ** ** XML Application Serving **
// || ** http://axkit.org ** ** XSLT, XPathScript, XSP **
// \\| // ** mod_perl news and resources: http://take23.org **
\\//
//\\
// \\
