Re: [GENERAL] question about frequency of updates/reads

2009-06-24 Thread Craig Ringer
Andrew Smith wrote: - 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 [snip] This temp table will probably contain up to 1 records, each of which could be changing

[GENERAL] question about frequency of updates/reads

2009-06-23 Thread Andrew Smith
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

Re: [GENERAL] question about frequency of updates/reads

2009-06-23 Thread Scott Marlowe
On Tue, Jun 23, 2009 at 10:12 PM, Andrew Smithlaconi...@gmail.com wrote: This temp table will probably contain up to 1 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

Re: [GENERAL] question about frequency of updates/reads

2009-06-23 Thread David Wilson
On Wed, Jun 24, 2009 at 12:48 AM, Scott Marlowescott.marl...@gmail.com wrote: Maybe.  Rows that are updated often are NOT generally pgsql's strong suit, but IF you're running 8.3 or above, and IF you have a low enough fill factor that there's empty space for the updates and IF the fields you