From: | "Jackson, Scott M" <Scott(dot)Jackson(at)pnl(dot)gov> |
---|---|
To: | "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Large delay in pgsql-jdbc SELECT |
Date: | 2002-07-25 18:47:47 |
Message-ID: | 29E6E93D92576F4DB85FE89FF2C23F4403700665@pnlmse03.pnl.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hello,
I am hoping somebody might have an idea about this or a suggestion for
troubleshooting...
I am using jdbc7.1-1.2.jar with jdk1.3.1_01 on an i386 box with RedHat 7.1.
When running a SELECT query that resulted in 10 rows of 100 columns each, I
could average a 1 second response from my application.
However when I ran a similar SELECT that resulted in 100 rows of 100 columns
each (of exactly the same format), I experienced a very definitive hang of
about 20-25 seconds.
When I issued the same query within the psql prompt, the query results
returned immediately.
My application is hanging at the db.createStatement().executeQuery("SELECT
..."); statement
I turned on level 4 debugging and straced -f my postmaster and saw that it
was hanging in a recv statement in file descriptor 5 which is the
/usr/local/pgsql/data/global/pg_control file.
Debug and strace output at the hang is:
......
[pid 24706] 11:40:25 brk(0x8237000) = 0x8237000
[pid 24706] 11:40:25 write(2, "DEBUG: CommitTransactionCommand"...,
33DEBUG: CommitTransactionCommand
) = 33
[pid 24706] 11:40:25 brk(0x8213000) = 0x8213000
[pid 24706] 11:40:25 send(5,
"\0051\0\0\0\0051\0\0\0\0051\0\0\0\0051\0\0\0\0051\0\0\0"..., 1327, 0) =
1327
[pid 24706] 11:40:25 recv(5,
(It hangs here for 20 seconds)
"Qcommit\0", 8192, 0) = 8
[pid 24827] 11:43:09 write(2, "DEBUG: StartTransactionCommand\n", 32DEBUG:
StartTransactionCommand
) = 32
[pid 24827] 11:43:09 write(2, "DEBUG: query: commit\n", 22DEBUG: query:
commit) = 22
...
Top appears to reveal no memory problems, I have all my limits set to
unlimited. I see a very high level of CPU activity during this period.
Does anyone have any thoughts or recommendations?
Thanks for any help you can give me!
Scott Jackson
From | Date | Subject | |
---|---|---|---|
Next Message | Barry Lind | 2002-07-25 18:54:48 | Re: Large delay in pgsql-jdbc SELECT |
Previous Message | Dave Cramer | 2002-07-25 18:14:17 | Re: PostgreSQL and Tomcat? |