From: | Prajakt Deolasee <bugzilla(dot)prajakt(at)gmail(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Postgres is slow |
Date: | 2005-03-08 13:49:05 |
Message-ID: | 6bf1b0a005030805495ec76763@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Dear All,
I am using Postgres 7.4 on Fedora 3.0. It is running with the default
configuration.
I have a Java code which is using the JDBC 3.0 implementation and the
connection pooling implementation of the Postgres.
I have some tests running against this implementation. I do inserts of
100,000 records. The primary key of this table is a byte array.
The time required for lookup on this 100,000 records keeps increasing
with subsequent tests even though I am not inserting/updating any
recors.
I also noticed that with every test the size of "base" directory which
is there in my DB keeps increasing. I don't think this is a log
directory, then why should its size increase with just "select"
queries? What is it logging?
Can somebody help on this? I think its some misconfiguration on my part?
-Prajakt
From | Date | Subject | |
---|---|---|---|
Next Message | Laszlo Hornyak | 2005-03-08 14:07:02 | Re: Postgres is slow |
Previous Message | Guillaume Cottenceau | 2005-03-08 13:20:15 | Re: PreparedStatement#setString on non-string parameters |