Search Postgresql Archives

Re: Using libpq, floats and binary data

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Sep 16, 2010 at 12:37 AM, Merlin Moncure <mmoncure@xxxxxxxxx> wrote:
On Wed, Sep 15, 2010 at 6:18 PM, Arjen Nienhuis <a.g.nienhuis@xxxxxxxxx> wrote:
> Hi,
> Inserting many of rows is almost always IO bound. Converting ints and floats
> to text is CPU bound and really fast anyway. To speed things up first look
> at things like indexes, how often you need to COMMIT or using COPY. Only
> then look at prepared statements and binary transfer modes. Else it's simply
> not worth the headache.

That's an awfully broad statement, and untrue...many applications are
cpu bound. It's easier to scale storage than cpu after a point.  Also,
solid state storage is going to become increasingly common moving
forwards.

Not all type receiving parsing is trivial as you claim; timestamps and
bytea for example are significantly cheaper to send in binary wire
format.  Anyways, libpqtypes gives you all the advantages without all
the fuss.  If you are really looking to shave cycles we allow you to
prepare the format string as well as prepare the statement before
sending it.  We wrote this interface for a reason: I'd say on average
it cuts down query time around 20% on average in addition to the other
advantages it provides.

merlin

I think we can agree on one thing: trying to do it without libpqtypes is a bad idea.

Groeten, Arjen

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux