Hello there,
1. Try using COPY Command, you will see significant decrease in the loading
time.
2. Turn off auto commit and Remove foreign key constraints if it is only one
time load - this will also help in decreasing the load time.
Try these options and let us know how it went.
We load around 6
I am curious to know how much of your delay is due to PostgreSQL and how
much to your Java batch program. If you comment out the call to the
database function, so that you are reading your input file but not doing
anything with the data, how long does your batch program take to run?
RobR
-
2010/4/27 Greg Smith :
> a.bhattacha...@sungard.com wrote:
>>
>> I have *622,000 number of records *but it is taking almost *4 and half
>> hours* to load these data into the tables.
Without the schema and the queries, all you can get is guessing.
--
Vincenzo Romano
NotOrAnd Information Technolog
a.bhattacha...@sungard.com wrote:
I have *622,000 number of records *but it is taking almost *4 and half
hours* to load these data into the tables.
I have a simple function in db which is being called from Java batch
program to populate the records into tables from flat files.
Four likely
Thanks a lot for your help. However I am new to Postgres database
therefore it would be nice if you can let me know how to set autocommit
off.
I know from psql client issuing “\set Autocommit Off” would set it off but
unfortunately it doesn’t set it off.
It's a client-side setting, not a serv
On Tue, Apr 27, 2010 at 5:17 AM, Alban Hertroys
wrote:
> On 27 Apr 2010, at 10:11,
> wrote:
>
>> Dear All Experts,
>>
>> I am using in PostgreSQL 8.3.5 database on windows 64 bit OS.
>> However, I have a batch program written in Java which processes the data and
>> populates them into tables i
On 27 Apr 2010, at 11:15,
wrote:
> Thanks a lot for your help. However I am new to Postgres database therefore
> it would be nice if you can let me know how to set autocommit off.
> I know from psql client issuing “\set Autocommit Off” would set it off but
> unfortunately it doesn’t set it of
I am curious to know how much of your delay is due to PostgreSQL and how
much to your Java batch program. If you comment out the call to the
database function, so that you are reading your input file but not doing
anything with the data, how long does your batch program take to run?
RobR
s for your help.
From: Magnus Hagander [mailto:mag...@hagander.net]
Sent: Tuesday, April 27, 2010 2:19 PM
To: Bhattacharya, A
Cc: pgsql-general
Subject: Re: [GENERAL] PostgreSQL Performance issue
On Tue, Apr 27, 2010 at 10:11, wrote:
Dear All Experts,
I am usin
On 27 Apr 2010, at 10:11,
wrote:
> Dear All Experts,
>
> I am using in PostgreSQL 8.3.5 database on windows 64 bit OS.
> However, I have a batch program written in Java which processes the data and
> populates them into tables in Postgres database.
>
> I have 622,000 number of records but
a.bhattacha...@sungard.com wrote:
Dear All Experts,
I am using in PostgreSQL 8.3.5 database on windows 64 bit OS.
However, I have a batch program written in Java which processes the
data and populates them into tables in Postgres database.
I have *622,000 number of records *but it is taking
On Tue, Apr 27, 2010 at 10:11, wrote:
> Dear All Experts,
>
>
>
> I am using in PostgreSQL 8.3.5 database on windows 64 bit OS.
>
You really need to upgrade. At least to 8.3.10. It has many important
bugfixes.
> However, I have a batch program written in Java which processes the data
> and po
Most likely you are inserting one per transaction. Set autocommit to
false and commit only after all the inserts are done.
-n.
On 27-04-2010 13:41, a.bhattacha...@sungard.com wrote:
Dear All Experts,
I am using in PostgreSQL 8.3.5 database on windows 64 bit OS.
However, I have a batch pr
On 27 April 2010 09:11, wrote:
> Dear All Experts,
>
>
>
> I am using in PostgreSQL 8.3.5 database on windows 64 bit OS.
>
> However, I have a batch program written in Java which processes the data
> and populates them into tables in Postgres database.
>
>
>
> I have *622,000 number of records *
14 matches
Mail list logo
