Large delay in pgsql-jdbc SELECT
От | Jackson, Scott M |
---|---|
Тема | Large delay in pgsql-jdbc SELECT |
Дата | |
Msg-id | 29E6E93D92576F4DB85FE89FF2C23F4403700665@pnlmse03.pnl.gov обсуждение исходный текст |
Список | 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
В списке pgsql-jdbc по дате отправления: