| From: | Alfred Perlstein <bright(at)wintelcom(dot)net> |
|---|---|
| To: | Thomas Weholt <Thomas(at)cintra(dot)no> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Bulk-copy? |
| Date: | 2000-06-02 08:56:20 |
| Message-ID: | 20000602015619.I17973@fw.wintelcom.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
* Thomas Weholt <Thomas(at)cintra(dot)no> [000602 01:45] wrote:
> Hi,
>
> I need to insert about 2000-10000 records into a database. I`m using Python
> to do this. Is there a way to use some form of bulk copy that will do this
> faster than plain-old insert for each and every record?
I don't know if there's python bindings for it, but you may want to look
to at the COPY stuff in the manuals, it's helped me quite a bit.
--
-Alfred Perlstein - [bright(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
"I have the heart of a child; I keep it in a jar on my desk."
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alfred Perlstein | 2000-06-02 08:57:57 | Re: Performance - fsync-off |
| Previous Message | Ron Chmara | 2000-06-02 08:53:54 | Re: Performance |