Re: looking for some real world performance numbers - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: looking for some real world performance numbers
Date
Msg-id 471C1EA9.7000701@commandprompt.com
Whole thread Raw
In response to Re: looking for some real world performance numbers  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-general
Dave Cramer wrote:
> snacktime wrote:
>> I'm working through the architecture design for a new product.  We
>> have a small group working on this.  It's a web app that will be using
>> ruby on rails.  The challenge I'm running into is that the latest
>> conventional wisdom seems to be that since obviously databases don't
>> scale on the web, you should just not use them at all.  I have a group
>> of otherwise very bright people trying to convince me that a rdbms is
>> not a good place to store relational data because eventually it won't
>> scale.  And of course we don't even have version 1 of our product out
>> of the door.  I'll admit we do have a very good chance of actually
>> getting tons of traffic, but my position is to use a rdbms for
>> relational data, and then if and when it won't scale any more, deal
>> with it then.
>>
>> So what would really help me is some real world numbers on how
>> postgresql is doing in the wild under pressure.  If anyone cares to
>> throw some out I would really appreciate it.
>>
>>
> I've got a client doing 18M page views/ day and postgresql isn't really
> sweating.

We have a client doing 15k/tps via a website. I would say these, "very
bright people" are "very bright but excessively ignorant".

Joshua D. Drake

>
> Dave
>> Chris
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 1: if posting/reading through Usenet, please send an appropriate
>>        subscribe-nomail command to majordomo@postgresql.org so that your
>>        message can get through to the mailing list cleanly
>>
>>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Indexes & Primary Keys (based on the same columns)
Next
From: "Harvey, Allan AC"
Date:
Subject: Re: looking for some real world performance numbers