question about frequency of updates/reads

From: Andrew Smith <laconical(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: question about frequency of updates/reads
Date: 2009-06-24 04:12:39
Message-ID: 300497a30906232112i57ce5451kcd82b0bf2bf90086@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I'm working on a problem at the moment where I have some data that I
need to get from a proprietary system into a web page. I was thinking
of using PostgreSQL as a middle man to store the data. E.g

- C++ app reads data from proprietary system and writes it into temp
table in PostgreSQL
- ASP.NET web service reads data from temp table in PostgreSQL and
generates HTML

I already have a database that I'm using for other parts of the web
site, so thought I'd just add an extra table that looks like this:

CREATE TABLE "DataExchange"
(
"DataExchangeID" serial NOT NULL PRIMARY KEY,
"Name" text NOT NULL UNIQUE,
"Value" integer NOT NULL,
"UpdateTime" timestamp without time zone
);

This temp table will probably contain up to 10000 records, each of
which could be changing every second (data is coming from a real-time
monitoring system). On top of this, I've then got the ASP.NET app
reading the updated data values every second or so (the operators want
to see the data as soon as it changes). I was going to do some
performance testing to see how well it would work, but thought I'd ask
the question here first: I know that the number of records isn't a
problem, but how about the frequency of updates/reads? Is 10000
updates/reads a second considered a lot in the PostgreSQL world, or
will it do it easily?

Regards,

Andrew

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-06-24 04:48:52 Re: question about frequency of updates/reads
Previous Message Michael Alan Brewer 2009-06-24 03:16:49 PgDay Athens 2009: Call for Presentations