Re: [PERFORM] postgres slowdown question

2005-04-20 Thread John A Meinel
Shachindra Agarwal wrote: Thanks for the note. Please see my responses below: ... We are using JDBC which supports 'inserts' and 'transactions'. We are using both. The business logic adds one business object at a time. Each object is added within its own transaction. Each object add results in 5

Re: [PERFORM] postgres slowdown question

2005-04-20 Thread Shachindra Agarwal
Thanks for the note. Please see my responses below: -Original Message- From: John A Meinel [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 20, 2005 3:48 PM To: Shachindra Agarwal Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] postgres slowdown question Shachindra Agarwal

Re: [PERFORM] postgres slowdown question

2005-04-20 Thread John A Meinel
Shachindra Agarwal wrote: Dear Postgres Masters: We are using postgres 7.4 in our java application on RedHat linux. The Java application connects to Postgres via JDBC. The application goes through a ‘discovery’ phase, whereas it adds large amount of data into postgres. Typically, we are adding a

[PERFORM] postgres slowdown question

2005-04-20 Thread Shachindra Agarwal
Dear Postgres Masters:   We are using postgres 7.4 in our java application on RedHat linux. The Java application connects to Postgres via JDBC. The application goes through a ‘discovery’ phase, whereas it adds large amount of data into postgres. Typically, we are adding about a million re