Re: Using Postgres to store high volume streams of sensor readings

Поиск
Список
Период
Сортировка
От marcin mank
Тема Re: Using Postgres to store high volume streams of sensor readings
Дата
Msg-id b1b9fac60811231742x5c15d48cu2df01edecde8dee1@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Using Postgres to store high volume streams of sensor readings  ("Ciprian Dorin Craciun" <ciprian.craciun@gmail.com>)
Ответы Re: Using Postgres to store high volume streams of sensor readings  ("Ciprian Dorin Craciun" <ciprian.craciun@gmail.com>)
Список pgsql-general
>    Yes, the figures are like this:
>    * average number of raw inserts / second (without any optimization
> or previous aggregation): #clients (~ 100 thousand) * #sensors (~ 10)
> / 6seconds = 166 thousand inserts / second...

this is average?
166 000 * 20 bytes per record * 86400 seconds per day = 280GB / day ,
not counting indices.

What is the time span You want to have the data from?

Greetings
Marcin

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

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Running postgresql as a VMware ESx client
Следующее
От: Glen Eustace
Дата:
Сообщение: Re: Running postgresql as a VMware ESx client