inserting 4800 records at a time

From: Tom Brown <brown(at)esteem(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: inserting 4800 records at a time
Date: 2007-03-28 23:30:04
Message-ID: 200703281630.05722.brown@esteem.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

We use an application that generates 4800 points for the graph of a waveform.
We capture this data and display it to the user. Now we want to save all this
information to a database. I have tried to create a record for each point,
but insertion/retrieval is slow. I thought that maybe I could save one record
per graph and save all the points as a large string, but there would be 148k
characters in the string. Then I'm still not sure what the performance would
be like. Would the use of BLOBs a better way to go here? Any ideas on what
the best approach would be for us?

Thanks,
Tom

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2007-03-28 23:41:30 Re: inserting 4800 records at a time
Previous Message Stephan Szabo 2007-03-28 22:22:37 Re: Order by behaviour