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

From: "Ciprian Dorin Craciun" <ciprian(dot)craciun(at)gmail(dot)com>
To: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Using Postgres to store high volume streams of sensor readings
Date: 2008-11-21 15:07:35
Message-ID: 8e04b5820811210707h121ffef5nd63a06878da16dce@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Nov 21, 2008 at 3:29 PM, Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com> wrote:
> see, I am affraid of the part when it says "randomly", because you probably
> used random(), which isn't the fastest thing on earth :)

I can assure you this is not the problem... The other storage
engines work quite well, and also the generation speed is somewhere at
30 million records / second, which 100 greater than the speed achieved
by the fastest store I've tested so far...

Ciprian.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message paulo matadr 2008-11-21 15:26:30 Res: converter pgplsql funcion
Previous Message Sam Mason 2008-11-21 14:49:34 Re: Using Postgres to store high volume streams of sensor readings