[ https://issues.jboss.org/browse/TEIID-3796?page=com.atlassian.jira.plugin... ] Xian Liu updated TEIID-3796: ---------------------------- Description: There is a table about 1000K+ record 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} When I make it available in Teiid, and set driver connection parameter to disableLocalTxn=true;FetchSize=10; It will quickly get the data stream. But when I make this in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+, the client can not get the data stream, what's reason, when I try to directly connect postgresql, it is much more faster. was: There is a table about 1000K+ record The table definition: {code} {code} When I make it available in Teiid, and set driver connection parameter to disableLocalTxn=true;FetchSize=10; It will quickly get the data stream. But when I make this in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+, the client can not get the data stream, what's reason, when I try to directly connect postgresql, it is much more faster. -- This message was sent by Atlassian JIRA (v6.4.11#64026)