Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Postgres batch write very slow - what to do
- From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
- To: femski <hypertree(at)yahoo(dot)com>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Postgres batch write very slow - what to do
- Date: Fri, 16 Mar 2007 08:52:32 -0500
On 3/16/07, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
Be careful...you are just testing one very specific thing and it its extremely possible that the Oracle JDBC batch insert is more optimized than PostgreSQL's. On my little pentium 4 workstation, by inserting 10 rows per insert: insert values ([...]), ([...]), [8 more rows];
small correction here, I actually went and looked at the JDBC api and realized 'addBatch' means to run multiple stmts at once, not batch inserting. femski, your best bet is to lobby the JDBC folks to build support for 'copy' into the driver for faster bulk loads (or help out in that regard). merlin
- References:
- Postgres batch write very slow - what to do
- From: femski
- Re: Postgres batch write very slow - what to do
- From: Heikki Linnakangas
- Re: Postgres batch write very slow - what to do
- From: femski
- Re: Postgres batch write very slow - what to do
- From: femski
- Re: Postgres batch write very slow - what to do
- From: Merlin Moncure
- Re: Postgres batch write very slow - what to do
- From: femski
- Re: Postgres batch write very slow - what to do
- From: Merlin Moncure
- Re: Postgres batch write very slow - what to do
- From: femski
- Re: Postgres batch write very slow - what to do
- From: Merlin Moncure
- Postgres batch write very slow - what to do
- Prev by Date: Re: Postgres batch write very slow - what to do
- Next by Date: Re: Postgres batch write very slow - what to do
- Previous by thread: Re: Postgres batch write very slow - what to do
- Next by thread: Re: Postgres batch write very slow - what to do
- Indexes: