| From: | Guy Rouillier <guyr-ml1(at)burntmail(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: looking for some real world performance numbers |
| Date: | 2007-10-22 05:23:34 |
| Message-ID: | 471C33D6.707@burntmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Ow Mun Heng wrote:
> On Sun, 2007-10-21 at 22:54 -0400, Guy Rouillier wrote:
>> The current app uses stored procedures
>> for all inserts, and PG didn't do well with that approach; substituting
>> embedded inserts fixed that problem. So PG can definitely "handle" very
>
>
> Can you explain what is embedded inserts?
Insert via embedded SQL insert statements in our Java code, as opposed
to embedded SQL stored proc invocations, which in turn do the inserts.
The existing code base used the latter approach, which didn't work well
with PG. I suspect it has to do with PG's stored proc overload
capability. The short of it is that *any* DBMS you use will have its
own quirks that you become acquainted with and learn to work around.
--
Guy Rouillier
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ow Mun Heng | 2007-10-22 05:37:09 | Re: looking for some real world performance numbers |
| Previous Message | Tom Lane | 2007-10-22 03:55:16 | Re: Indexes & Primary Keys (based on the same columns) |