Postgres Pro
Downloads
Home   >   mailing lists

Re: Using Postgres to store high volume streams of sensor readings - Mailing list pgsql-general

From marcin mank
Subject Re: Using Postgres to store high volume streams of sensor readings
Date
Msg-id b1b9fac60811231742x5c15d48cu2df01edecde8dee1@mail.gmail.com
Whole thread Raw
In response to Re: Using Postgres to store high volume streams of sensor readings  ("Ciprian Dorin Craciun" <ciprian.craciun@gmail.com>)
Responses Re: Using Postgres to store high volume streams of sensor readings  ("Ciprian Dorin Craciun" <ciprian.craciun@gmail.com>)
List pgsql-general
Tree view 
>    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 by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Running postgresql as a VMware ESx client
Next
From: Glen Eustace
Date:
Subject: Re: Running postgresql as a VMware ESx client