Re: realtime data inserts - Mailing list pgsql-general

From Tom Lane
Subject Re: realtime data inserts
Date
Msg-id 6754.1052582402@sss.pgh.pa.us
Whole thread Raw
In response to realtime data inserts  ("Adam Siegel" <adam@sycamorehq.com>)
Responses Re: realtime data inserts  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
"Adam Siegel" <adam@sycamorehq.com> writes:
> I have realtime data flowing at a rate of 500, 512 byte packets per second.
> I want to log the info in a database table with two other columns, one for a
> timestamp and one for a name of the packet.  The max rate I can achieve is
> 350 inserts per second on a sun blade 2000.  The inserts are grouped in a
> transaction and I commit every 1200 records.

Have you thought about using COPY?

            regards, tom lane


pgsql-general by date:

Previous
From: Ericson Smith
Date:
Subject: Re: realtime data inserts
Next
From: "Jim C. Nasby"
Date:
Subject: Re: realtime data inserts