what is lslowing me down? JDBC or Postgresql itself?

Поиск
Список
Период
Сортировка
От jeff@amiel.net (Jeff Amiel)
Тема what is lslowing me down? JDBC or Postgresql itself?
Дата
Msg-id e368dd0e.0403300742.fc9345b@posting.google.com
обсуждение исходный текст
Ответы Re: what is lslowing me down? JDBC or Postgresql itself?
Re: what is lslowing me down? JDBC or Postgresql itself?
Список pgsql-jdbc
java test program (running on windows box)

Program starts X threads.

Each thread does it's own classForName and has OWN connection
(autocommit is turned off)

inside each thread, they use a shared queue to perform work on 1000
items.  Each thread will only grab one item (and hence only work on
single row in table)

Each of the 1000 items requires the thread to perform:
    1 select for update (single row)
    5 select statements (not for update) on single row (uses
index...low/no cost..."select count(*) from table where id=2".
Prepared statement...but do not pass in paremeter...hardcode the id
value)
    1 update statement (the one we selected for update)
    1 commit

I put timing logging around the 5 select statements section only
(after checking everything else)

When running a single thread....takes 0 milliseconds
(mostly...sometimes takes 16)
when running 10 threads...takes between 15 and 150 milliseconds.
when running 20 threads....takes between 15 and 250 milliseconds.


I clear the table and vacuum full between each test.

I have tweaked the postgresql.conf settings only slightly from the
default install (increased shared buffers some)


Why is this happening?  Is the jdbc driver the limiting factor?  Is it
the database?  Can anyone give me any suggestions to troubleshoot?

more info....

Postgresql 7.4 running on FreeBSD
jdbc driver version 74_213

single table----

        Table "public.table"
 Column |     Type      | Modifiers
--------+---------------+-----------
 id     | integer       | not null
 data   | character(15) | not null
Indexes:
    "id" primary key, btree (id)
    "tableid" unique, btree (id)


populate initially with 1000 entries...


any help would be greatly appreciated.

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Edoardo Ceccarelli
Дата:
Сообщение: test, don't read
Следующее
От: "Freddy Villalba Arias"
Дата:
Сообщение: JTA / JDBC support