Re: Integrity on large sites

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Integrity on large sites
Дата
Msg-id 4655B839.60409@commandprompt.com
обсуждение исходный текст
Ответ на Re: Integrity on large sites  (Dave Page <dpage@postgresql.org>)
Ответы Re: Integrity on large sites  (PFC <lists@peufeu.com>)
Re: Integrity on large sites  (Dave Page <dpage@postgresql.org>)
Список 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 по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Very big transaction in a stored procedure : how can i commit in the middle of it ?
Следующее
От: Teodor Sigaev
Дата:
Сообщение: Re: Postgresql 8.2.4 crash with tsearch2