using following statement:
UPDATE TABLE1 SET V_VOL = 'ABCD' WHERE TABLE_ID = 10
Regards,
Ravi
-Original Message-
From: Stephan Szabo [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 8:32 PM
To: Ravi T Ramachandra
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Postgre
Title: Message
Hi,
We are using
postgresql 7.3.2 on lunux platform. We performed locking test as
follows via JDBC:
Started 2 concurrent
transaction with autocommit false and isolation
READ_COMMITTED :
Transaction
1:
===
Update row
1
Sleep for 30
seconds
commit:
Transac
Wolff III [mailto:[EMAIL PROTECTED]
Sent: Monday, September 08, 2003 6:43 PM
To: Ravi T Ramachandra
Cc: [EMAIL PROTECTED]; Sandeep Bhasin
Subject: Re: [ADMIN] Performance Issues
On Mon, Sep 08, 2003 at 11:43:42 +0530,
Ravi T Ramachandra <[EMAIL PROTECTED]> wrote:
>
> SELECT * FROM T
Title: Message
Hi,
I recently setup
postgres on a Linux box with 4GB Ram and 2.5 GHz processor. We have
created a database with 1.5 million rows in a table. When we try to select
rows from the table, it is taking enormous time with the default
configuration. It takes 2 to 3 seconds to
