[teiid-issues] [JBoss JIRA] (TEIID-3796) It is much more slow to get the table record through TEIID from postgresql DB
Steven Hawkins (JIRA)
issues at jboss.org
Mon Nov 9 13:40:00 EST 2015
[ https://issues.jboss.org/browse/TEIID-3796?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13127026#comment-13127026 ]
Steven Hawkins commented on TEIID-3796:
---------------------------------------
Is there any update on the details here? If not we'll resolve as incomplete description for now.
> 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.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list