[teiid-issues] [JBoss JIRA] (TEIID-3796) It is much more slow to get the table record through TEIID from postgresql DB

It is much more slow to get the table record through TEIID from postgresql DB ----------------------------------------------------------------------------- Key: TEIID-3796 URL: https://issues.jboss.org/browse/TEIID-3796 Project: Teiid Issue Type: Bug Reporter: Xian Liu Assignee: Steven Hawkins 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: {code} | 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 | {code} 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.