From: Andrew McMillan <andrew@morphoss.com>
To: V S P <toreason@fastmail.fm>
Cc: pgsql-php@postgresql.org
Subject: Re: [Q] PDO use to bind arrays for insert
Date: Mon, 17 Nov 2008 17:05:47 +1300
Message-ID: <1226894747.5577.267.camel@happy.mcmillan.net.nz> (raw)
In-Reply-To: <1226890873.32288.1285117971@webmail.messagingengine.com>
References: <1226803530.24888.1284994985@webmail.messagingengine.com>
<492093A5.7040606@gmail.com>
<20081117002630.d86160fd.knl@bitflop.com>
<1226890873.32288.1285117971@webmail.messagingengine.com>
On Sun, 2008-11-16 at 22:01 -0500, V S P wrote:
>
> I think Chris @ dmagick pointed to a raw string functionality
> that -- so I will need to figure out if
> a) it actually saves on parsing
Using the COPY functionality in PostgreSQL does save on parsing,
although an insert of many rows in a single insert statement doesn't
spend any significant amount of it's time parsing the input, and the
query planning only happens once.
If you are really concerned about the performance impacts of an insert,
you might be better advised to feed the row data to a separate process
which handled the actual inserts.
> b) if it will work with PG connection pooling (which I am not
> using yet, but will in the future).
There's no reason why COPY shouldn't work with connection pooling,
unless your connection pooling is trying to understand the statements
deeply on the way through, without understanding PostgreSQL. I can't
think of why someone would write connection pooling that way though!
Certainly it will work fine with pgpool, which is what I would recommend
for connection pooling with PostgreSQL as it is written by someone on
the core team.
Cheers,
Andrew McMillan.
------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com +64(272)DEBIAN
You have a deep interest in all that is artistic.
------------------------------------------------------------------------
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: andrew@morphoss.com, toreason@fastmail.fm
Subject: Re: [Q] PDO use to bind arrays for insert
In-Reply-To: <1226894747.5577.267.camel@happy.mcmillan.net.nz>
References: <1226803530.24888.1284994985@webmail.messagingengine.com> <492093A5.7040606@gmail.com> <20081117002630.d86160fd.knl@bitflop.com> <1226890873.32288.1285117971@webmail.messagingengine.com> <1226894747.5577.267.camel@happy.mcmillan.net.nz>
* 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