Re: Optimize update query

Поиск
Список
Период
Сортировка
От Willem Leenen
Тема Re: Optimize update query
Дата
Msg-id DUB104-W48E83E17609D570C42B5AD8F5D0@phx.gbl
обсуждение исходный текст
Ответ на Re: Optimize update query  (Marcin Mirosław <marcin@mejor.pl>)
Ответы Re: Optimize update query
Список pgsql-performance

I assume that SQL databases ( Banks? Telecom?) can handle an used car shop. No need for an unstructured data tool.



> +1, sql databases has limited number of inserts/updates per second. Even
> with highend hardware you won't have more than XXX operations per
> second. As Thomas said, you should feed something like nosql database
> from www server and use other tool to do aggregation and batch inserts
> to postgresql. It will scale much better.
>
> Marcin

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Optimize update query
Следующее
От: Mike Blackwell
Дата:
Сообщение: Re: Savepoints in transactions for speed?