Hello
Would you try to execute your SELECT within pgAdmin?
If performance is much better now, take a look at my post
http://postgresql.1045698.n5.nabble.com/Result-Set-over-Network-Question-tt5682480.html#a5708971
Best performance you will get by using COPY
http://www.postgresql.org/docs/9.2/static/sql-copy.html
and read the resultset via a text file.
best regards
BGoebel
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Very-slow-perfomance-for-selecting-big-data-resultsets-tp5735505p5735930.html
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.