From: | Mark Lilback <Mark(dot)Lilback(at)mail(dot)wvu(dot)edu> |
---|---|
To: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | long delay with binary data on ubuntu and 9.4.1 |
Date: | 2015-05-13 20:09:47 |
Message-ID: | 67F45614-EB83-49DC-BB8B-991AF27EA88F@mail.wvu.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
When executed in psql on Ubuntu 14.04 LTS (ubuntu/trusty64) the query "select bindata from rcfiledata where id = 106" hangs from 6-12 seconds before completing. On OS X, it takes a few milliseconds. This happens with the package available from postgresql.org for 9.4 and with a compiled version of 9.4.1.
All tests were with the server running on OS X. Ubuntu was running in vagrant/virtualbox. The attached filedata.sql contains a dump of the table.
The same problem happens when executed in a program using libpq.That program is included in pgtest.c. When breaking in gdb while hung, the backtrace is:
(gdb) bt
#0 0x00007ffff72ab110 in __poll_nocancel () at ../sysdeps/unix/syscall-template.S:81
#1 0x000000000040bb9e in pqSocketCheck ()
#2 0x000000000040c480 in pqWaitTimed ()
#3 0x000000000040a809 in PQgetResult ()
#4 0x000000000040aafe in PQexecFinish ()
#5 0x0000000000402c4b in main (argc=1, argv=0x7fffffffe648) at pgtest.c:9
Attachment | Content-Type | Size |
---|---|---|
filedata.sql | application/octet-stream | 411.4 KB |
pgtest.c | application/octet-stream | 468 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2015-05-13 20:50:50 | Re: long delay with binary data on ubuntu and 9.4.1 |
Previous Message | Heikki Linnakangas | 2015-05-13 07:18:01 | Re: 9.4.1 segfault while creating hash index on temporary table |