Re: ODBC SELECT Timeout

Sorry for teh late reply.

(2013/05/29 5:20), ter062424 wrote:
> Hello Hiroshi,
>
> I set UseServerSidePrepare=1 in /etc/odbcinst.ini and then ran odbcinst -i
> -d -f /etc/odbcinst.ini.

I don't know well about odbcinst.
Does the above operation update odbc.ini?

 > The SELECT query over ODBC ran for about 1 hour,
> and then died with:

Could you try
   explain <the query>
using psql etc?

regards,
Hiroshi Inoue