Re: Integrity on large sites - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Integrity on large sites
Date
Msg-id 4655B839.60409@commandprompt.com
Whole thread Raw
In response to Re: Integrity on large sites  (Dave Page <dpage@postgresql.org>)
Responses Re: Integrity on large sites
Re: Integrity on large sites
List pgsql-general
Dave Page wrote:

>> problem with your setup. Granted, MySQL is a pretty bad database, but
>> it's not *that* bad -- your example implies that heavily MyISAM-based
>> (you don't say whether this is MyISAM or InnoDB) sites such as
>> Slashdot and Flickr should be falling over every hour.
>
> I'm not going to comment on who's fault it is, but the OP quoted 100
> updates and 600 selects per *second*. I can't imagine Flickr or Slashdot
> (which is heavily csched for reading) are under anything like that sort
> of constant load.

Uhmmm.... I would not be surprised at *all* at slashdot or flickr doing
that type of velocity. We have customers right now that under peak are
doing 10 times that and yes these are customers that have similar types
of websites.

Sincerely,

Joshua D. Drake


>
> Regards, Dave.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>


--

       === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Very big transaction in a stored procedure : how can i commit in the middle of it ?
Next
From: Teodor Sigaev
Date:
Subject: Re: Postgresql 8.2.4 crash with tsearch2