| From: | "Ravi Krishna" <srkrishna(at)gmx(dot)com> |
|---|---|
| To: | john <johnf(at)jfcomputer(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] Does PG support bulk operation in embedded C |
| Date: | 2015-05-20 15:23:51 |
| Message-ID: | trinity-cd0fd5f4-144c-4472-a699-0adb04055119-1432135431375@3capp-mailcom-lxa10 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
> Anyway, taking the function name 'bulk' into account - I think you want
> find the best way to to insert a large number of row/records.
>
> Review the 'copy' command to populate a database:
> http://www.postgresql.org/docs/9.1/static/populate.html - read
> carefully as it will increase performance in a dramatic way.
I am aware of the copy command, but we are talking about application inserting rows from a C++ task
with values coming in variables. Does COPY handle that? COPY looks more closer to sqlloader of Oracle.
DB2 Bulkcopy API is damn good. We have applications inserting tens of rows in one single call.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Midgley | 2015-05-20 15:43:50 | Re: [GENERAL] Does PG support bulk operation in embedded C |
| Previous Message | Musall Maik | 2015-05-20 14:09:51 | Re: Slaves show different results for query |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Midgley | 2015-05-20 15:43:50 | Re: [GENERAL] Does PG support bulk operation in embedded C |
| Previous Message | john | 2015-05-20 13:56:54 | Re: [GENERAL] Does PG support bulk operation in embedded C |