Re: [BUGS] BUG #2236: extremely slow to get unescaped bytea data

2006-02-09 Thread Kalador Tech Support
You guys are smart! Apache was running against an old libpq. I shutdown apache, updated /etc/ld.so.conf with the postgres lib dir, ran ldconfig, restarted apache, and the problem went away. The old libpq was libpq.so.3.0 (pre-installed on machine). The new one is libpq.so.3.2 (installed wi

Re: [BUGS] BUG #2236: extremely slow to get unescaped bytea data

2006-02-09 Thread Kalador Tech Support
inment Inc. Michael Fuhr wrote: On Sat, Feb 04, 2006 at 04:06:11PM -0800, Kalador Tech Support wrote: I've since isolated the problem to the unescape_bytea function not the SELECT. I inserted the same image to a bytea column using base64 encoding, and extracted it from the table (using

Re: [BUGS] BUG #2236: extremely slow to get unescaped bytea data

2006-02-05 Thread Kalador Tech Support
This is a table with just one entry created to test the problem. Should not have any indexing issues. I've since isolated the problem to the unescape_bytea function not the SELECT. I inserted the same image to a bytea column using base64 encoding, and extracted it from the table (using base