| 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: | Whole Thread | Raw Message | 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 |