On Tue, Nov 3, 2009 at 8:12 PM, Jay Manni <JManni@xxxxxxxxxxx> wrote: > Hi: > > > > I have an application wherein a process needs to read data from a stream and > store the records for further analysis and reporting. The data in the stream > is in the form of variable length records with clearly defined fields – so > it can be stored in a database or in a file. The only caveat is that the > rate of records coming in the stream could be several 1000 records a second. > > > > The design choice I am faced with currently is whether to use a postgres > database or a flat file for this purpose. My application already maintains a A common approach is to store them in flat files, then insert the flat files at a later time so that if the db falls behind no data is lost. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
