On Mon, Apr 27, 2009 at 12:45 AM, Kris Jurka <books@xxxxxxxxxx> wrote: > Scott Marlowe wrote: >> >> On Sun, Apr 26, 2009 at 11:07 AM, Kris Jurka <books@xxxxxxxxxx> wrote: >>> >>> As a note for non-JDBC users, the JDBC driver's batch interface allows >>> executing multiple statements in a single network roundtrip. This is >>> something you can't get in libpq, so beware of this for comparison's >>> sake.. >> >> Really? I thought that executing statements like so: >> >> select * from a;insert ...;delete; >> >> in psql / libpq would execute them all in one trip. > > Right, but those aren't prepared. I suppose it's possible to issue a > prepare and then issue a batch of comma separated "execute" statements, but > that's not exactly a natural interface. Oh right,. Sorry, didn't realize you were talking about prepared statements. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
