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

From: "marcin mank" <marcin(dot)mank(at)gmail(dot)com>
To: "Ciprian Dorin Craciun" <ciprian(dot)craciun(at)gmail(dot)com>
Cc: "Michal Szymanski" <dyrex(at)poczta(dot)onet(dot)pl>, pgsql-general(at)postgresql(dot)org
Subject: Re: Using Postgres to store high volume streams of sensor readings
Date: 2008-11-24 01:42:11
Message-ID: b1b9fac60811231742x5c15d48cu2df01edecde8dee1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Glen Eustace 2008-11-24 01:47:26 Re: Running postgresql as a VMware ESx client
Previous Message Scott Marlowe 2008-11-24 01:19:50 Re: Running postgresql as a VMware ESx client