There is a table about 1000K+ record
Postgresql Version: server 9.2.7
Postgresql DB JDBC Driver Version: postgresql-9.3-1103.jdbc4.jar
The table definition:

 |            Type             |                         Modifiers                          
------------+-----------------------------+------------------------------------------------------------
| integer                     | not null
| integer                     | 
| integer                     | not null
| timestamp without time zone | not null
| integer                     | not null
| text                        | 
| text                        | 
| bigint                      | 
| bigint                      | not null 
| integer                     | 

I set driver connection parameter to disableLocalTxn=true;FetchSize=10;
1. When I make this table available in Mysql, and select * from it in Teiid, It will quickly get the data stream after around 30s.
2. But when I make this table in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+ client can not get the data stream,
when I try to directly connect this table in Postgresql table, it is much more faster, I do not know the reason.