From: Nick Matheson <Nick.D.Matheson@noaa.gov>
To: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Simple (hopefully) throughput question?
Date: Thu, 04 Nov 2010 14:31:25 +0000
Message-ID: <4CD2C3BD.3030609@noaa.gov> (raw)
In-Reply-To: <4CD19785.9060301@enterprisedb.com>
References: <4CD1853F.2010800@noaa.gov>
<4CD19785.9060301@enterprisedb.com>
Heikki-
>
> Try COPY, ie. "COPY bulk_performance.counts TO STDOUT BINARY".
>
Thanks for the suggestion. A preliminary test shows an improvement
closer to our expected 35 MB/s.
Are you familiar with any Java libraries for decoding the COPY format?
The spec is clear and we could clearly write our own, but figured I
would ask. ;)
Nick
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: Nick.D.Matheson@noaa.gov, heikki.linnakangas@enterprisedb.com
Subject: Re: Simple (hopefully) throughput question?
In-Reply-To: <4CD2C3BD.3030609@noaa.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox